(default) 40 queries took 80 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Selection`.`id`, `Selection`.`model`, `Selection`.`field`, `Selection`.`keys`, `Selection`.`values`, `Selection`.`colors`, `Selection`.`tests`, `Selection`.`is_edit`, `Selection`.`is_disable`, `Selection`.`memo`, `Selection`.`modified`, `Selection`.`created` FROM `k9k`.`selections` AS `Selection` WHERE `model` IN ('PrintingEstimate', 'All') AND `keys` != '' AND `values` != ''30301
2SELECT `SystemValue`.`id`, `SystemValue`.`name`, `SystemValue`.`value`, `SystemValue`.`type`, `SystemValue`.`valid`, `SystemValue`.`tag`, `SystemValue`.`class`, `SystemValue`.`comment`, `SystemValue`.`explain`, `SystemValue`.`is_required`, `SystemValue`.`is_view`, `SystemValue`.`memo`, `SystemValue`.`modified` FROM `k9k`.`system_values` AS `SystemValue` WHERE 1 = 121210
3SELECT `Norm`.`id`, `Norm`.`name` FROM `k9k`.`norms` AS `Norm` WHERE `is_delete` = 011110
4SELECT `Selection`.`id`, `Selection`.`model`, `Selection`.`field`, `Selection`.`keys`, `Selection`.`values`, `Selection`.`colors`, `Selection`.`tests`, `Selection`.`is_edit`, `Selection`.`is_disable`, `Selection`.`memo`, `Selection`.`modified`, `Selection`.`created` FROM `k9k`.`selections` AS `Selection` WHERE `model` IN ('PrintingProduct', 'All') AND `keys` != '' AND `values` != ''550
5SELECT `Option`.`id`, `Option`.`brand_id`, `Option`.`name`, `Option`.`aname`, `Option`.`code`, `Option`.`is_printing_estimate_show`, `Option`.`count`, `Option`.`memo`, `Option`.`is_delete`, `Option`.`modify_id`, `Option`.`create_id`, `Option`.`modified`, `Option`.`created`, `Brand`.`id`, `Brand`.`name`, `Brand`.`memo`, `Brand`.`is_delete`, `Brand`.`modify_id`, `Brand`.`create_id`, `Brand`.`modified`, `Brand`.`created` FROM `k9k`.`options` AS `Option` LEFT JOIN `k9k`.`brands` AS `Brand` ON (`Option`.`brand_id` = `Brand`.`id`) WHERE `Option`.`is_printing_estimate_show` = 217171
6SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (27) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10014144
7SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (28) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10019194
8SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (39) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10035355
9SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (40) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100224
10SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (41) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10017174
11SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (42) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100335
12SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (43) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10083835
13SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (44) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100225
14SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (45) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100775
15SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (46) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10016165
16SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (47) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10017175
17SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (48) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100885
18SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (49) ORDER BY `OptionCategory`.`sort` ASC LIMIT 10010105
19SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (51) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100225
20SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (55) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100004
21SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (57) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100004
22SELECT `OptionCategory`.`id`, `OptionCategory`.`option_id`, `OptionCategory`.`name`, `OptionCategory`.`sort`, `OptionCategory`.`is_pricetype`, `OptionCategory`.`whole_price`, `OptionCategory`.`unit_price`, `OptionCategory`.`is_size_type`, `OptionCategory`.`is_pagenum`, `OptionCategory`.`value1`, `OptionCategory`.`value2`, `OptionCategory`.`is_delete`, `OptionCategory`.`modify_id`, `OptionCategory`.`create_id`, `OptionCategory`.`modified`, `OptionCategory`.`created` FROM `k9k`.`option_categories` AS `OptionCategory` WHERE `is_delete` = 0 AND `OptionCategory`.`option_id` = (62) ORDER BY `OptionCategory`.`sort` ASC LIMIT 100334
23SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (27) LIMIT 100000
24SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (28) LIMIT 100000
25SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (39) LIMIT 100000
26SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (40) LIMIT 100000
27SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (41) LIMIT 100000
28SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (42) LIMIT 100000
29SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (43) LIMIT 100000
30SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (44) LIMIT 100000
31SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (45) LIMIT 100000
32SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (46) LIMIT 100000
33SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (47) LIMIT 100000
34SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (48) LIMIT 100000
35SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (49) LIMIT 100000
36SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (51) LIMIT 100000
37SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (55) LIMIT 100000
38SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (57) LIMIT 100000
39SELECT `ProductOption`.`product_id`, `ProductOption`.`option_id`, `ProductOption`.`is_enable`, `ProductOption`.`modify_id`, `ProductOption`.`create_id`, `ProductOption`.`modified`, `ProductOption`.`created` FROM `k9k`.`product_options` AS `ProductOption` WHERE `ProductOption`.`option_id` = (62) LIMIT 100000
40DELETE FROM associates WHERE directory = 'temp' AND NOW() > DATE_ADD(created,INTERVAL 1 DAY);000