Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
(default) 13 queries took 18 ms Nr Query Error Affected Num. rows Took (ms)
1 SHOW FULL COLUMNS FROM `cake_programs` 4 4 2
2 SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; 1 1 1
3 SHOW FULL COLUMNS FROM `cake_dispensing_solutions` 8 8 5
4 SHOW FULL COLUMNS FROM `cake_patient_buildings` 9 9 2
5 SHOW FULL COLUMNS FROM `cake_practice_operations` 9 9 3
6 SHOW FULL COLUMNS FROM `cake_team_training_educations` 13 13 2
7 SHOW FULL COLUMNS FROM `cake_locations` 22 22 2
8 START TRANSACTION 0 0
9 INSERT INTO `cake_programs` (`goals`, `modified`, `created`, `id`) VALUES ('{\"year_1\":\"1,111\",\"year_2\":\"$11.11\",\"year_3\":\"3000\"}', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-61d4-40de-8154-0309e0943fa0') 1 1
10 INSERT INTO `cake_locations` (`doc_first_name`, `doc_last_name`, `practice_name`, `address_1`, `address_2`, `city`, `province`, `postal`, `phone`, `fax`, `primary_contact_first_name`, `primary_contact_last_name`, `primary_contact_title`, `primary_contact_email`, `primary_contact_phone`, `primary_contact_fax`, `modified`, `created`, `id`) VALUES ('4yan', '4ibbons', '4yan Gibbons', '4300 Ridglea Place', '4uite 408', '4ort Worth', '4X', '46116', '4177571839', '4178621401', '4yan', '4ibbons', '4r', '4yan.gibbons@warrendouglas.com', '4128399493', '4372939394', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-15a0-4ed1-bfb7-0309e0943fa0') 1 0
11 INSERT INTO `cake_team_training_educations` (`dispenser_quick_start_program`, `dispenser_program_signups`, `apollo_advanced_eyecare_professionals`, `apollo_signups`, `essilor_resource_library`, `manage_care_training_services`, `manage_care_training_plans`, `practice_management_workshops`, `practice_workshops_signups`, `program_id`, `modified`, `created`, `id`) VALUES (1, '[{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"1\"},{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21b\"}]', 1, '[{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21b\"},{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\",\"start_date\":\"01\\/10\",\"certification_level\":\"21e\"}]', 1, 1, '[{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"1\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"2\"},{\"vision_plans\":\"3\",\"customer_percent\":\"3\",\"rank_comfort\":\"3\"}]', 1, '{\"event\":\"21b\",\"0\":{\"name\":\"John Doe\",\"email\":\"jdoe@wd.com\"}}', '4d111fc2-61d4-40de-8154-0309e0943fa0', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-bd50-4d3c-96f8-0309e0943fa0') 1 0
12 INSERT INTO `cake_patient_buildings` (`employer_initiatives`, `eloa_marketbuilder`, `myonlineoptical`, `taye_crizal_advertising_campaign`, `appointment_scheduling`, `program_id`, `modified`, `created`, `id`) VALUES (1, 1, 1, 1, 1, '4d111fc2-61d4-40de-8154-0309e0943fa0', '2010-12-21 15:44:34', '2010-12-21 15:44:34', '4d111fc2-a78c-4edf-a83d-0309e0943fa0') 1 0
13 COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.