1 | SELECT `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` != '' | | 30 | 30 | 1 |
2 | SELECT `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 = 1 | | 21 | 21 | 1 |
3 | SELECT `Norm`.`id`, `Norm`.`name` FROM `k9k`.`norms` AS `Norm` WHERE `is_delete` = 0 | | 11 | 11 | 0 |
4 | SELECT `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` != '' | | 5 | 5 | 1 |
5 | SELECT `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` = 2 | | 17 | 17 | 2 |
6 | SELECT `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 100 | | 14 | 14 | 9 |
7 | SELECT `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 100 | | 19 | 19 | 9 |
8 | SELECT `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 100 | | 35 | 35 | 9 |
9 | SELECT `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 100 | | 2 | 2 | 9 |
10 | SELECT `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 100 | | 17 | 17 | 9 |
11 | SELECT `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 100 | | 3 | 3 | 9 |
12 | SELECT `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 100 | | 83 | 83 | 9 |
13 | SELECT `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 100 | | 2 | 2 | 9 |
14 | SELECT `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 100 | | 7 | 7 | 9 |
15 | SELECT `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 100 | | 16 | 16 | 9 |
16 | SELECT `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 100 | | 17 | 17 | 9 |
17 | SELECT `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 100 | | 8 | 8 | 9 |
18 | SELECT `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 100 | | 10 | 10 | 9 |
19 | SELECT `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 100 | | 2 | 2 | 9 |
20 | SELECT `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 100 | | 0 | 0 | 9 |
21 | SELECT `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 100 | | 0 | 0 | 9 |
22 | SELECT `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 100 | | 3 | 3 | 9 |
23 | SELECT `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 100 | | 0 | 0 | 0 |
24 | SELECT `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 100 | | 0 | 0 | 0 |
25 | SELECT `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 100 | | 0 | 0 | 0 |
26 | SELECT `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 100 | | 0 | 0 | 0 |
27 | SELECT `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 100 | | 0 | 0 | 0 |
28 | SELECT `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 100 | | 0 | 0 | 0 |
29 | SELECT `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 100 | | 0 | 0 | 0 |
30 | SELECT `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 100 | | 0 | 0 | 0 |
31 | SELECT `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 100 | | 0 | 0 | 0 |
32 | SELECT `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 100 | | 0 | 0 | 0 |
33 | SELECT `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 100 | | 0 | 0 | 0 |
34 | SELECT `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 100 | | 0 | 0 | 0 |
35 | SELECT `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 100 | | 0 | 0 | 0 |
36 | SELECT `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 100 | | 0 | 0 | 0 |
37 | SELECT `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 100 | | 0 | 0 | 0 |
38 | SELECT `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 100 | | 0 | 0 | 0 |
39 | SELECT `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 100 | | 0 | 0 | 0 |
40 | DELETE FROM associates WHERE directory = 'temp' AND NOW() > DATE_ADD(created,INTERVAL 1 DAY); | | 0 | 0 | 0 |
41 | SELECT `PrintingProductNormPrice`.`id`, `PrintingProductNormPrice`.`printing_product_norm_id`, `PrintingProductNormPrice`.`quantity`, `PrintingProductNormPrice`.`price`, `PrintingProductNormPrice`.`is_delete`, `PrintingProductNormPrice`.`modified`, `PrintingProductNormPrice`.`created`, `PrintingProductNorm`.`id`, `PrintingProductNorm`.`printing_product_id`, `PrintingProductNorm`.`norm_category_id1`, `PrintingProductNorm`.`norm_category_id2`, `PrintingProductNorm`.`is_delete`, `PrintingProductNorm`.`modify_id`, `PrintingProductNorm`.`create_id`, `PrintingProductNorm`.`modified`, `PrintingProductNorm`.`created` FROM `k9k`.`printing_product_norm_prices` AS `PrintingProductNormPrice` LEFT JOIN `k9k`.`printing_product_norms` AS `PrintingProductNorm` ON (`PrintingProductNormPrice`.`printing_product_norm_id` = `PrintingProductNorm`.`id`) WHERE `PrintingProductNormPrice`.`id` = 89175 AND `PrintingProductNormPrice`.`is_delete` = 0 LIMIT 1 | | 1 | 1 | 0 |
42 | SELECT `PrintingProduct`.`id`, `PrintingProduct`.`is_print_type`, `PrintingProduct`.`is_color_type`, `PrintingProduct`.`is_size_type`, `PrintingProduct`.`norm_id1`, `PrintingProduct`.`norm_id2`, `PrintingProduct`.`wp_url`, `PrintingProduct`.`memo`, `PrintingProduct`.`is_delete`, `PrintingProduct`.`modify_id`, `PrintingProduct`.`create_id`, `PrintingProduct`.`modified`, `PrintingProduct`.`created` FROM `k9k`.`printing_products` AS `PrintingProduct` WHERE `PrintingProduct`.`id` = 8 AND `PrintingProduct`.`is_delete` = 0 LIMIT 1 | | 1 | 1 | 0 |
43 | SELECT `PrintingProductNorm`.`id`, `PrintingProductNorm`.`printing_product_id`, `PrintingProductNorm`.`norm_category_id1`, `PrintingProductNorm`.`norm_category_id2`, `PrintingProductNorm`.`is_delete`, `PrintingProductNorm`.`modify_id`, `PrintingProductNorm`.`create_id`, `PrintingProductNorm`.`modified`, `PrintingProductNorm`.`created`, `PrintingProduct`.`id`, `PrintingProduct`.`is_print_type`, `PrintingProduct`.`is_color_type`, `PrintingProduct`.`is_size_type`, `PrintingProduct`.`norm_id1`, `PrintingProduct`.`norm_id2`, `PrintingProduct`.`wp_url`, `PrintingProduct`.`memo`, `PrintingProduct`.`is_delete`, `PrintingProduct`.`modify_id`, `PrintingProduct`.`create_id`, `PrintingProduct`.`modified`, `PrintingProduct`.`created`, `NormCategory1`.`id`, `NormCategory1`.`norm_id`, `NormCategory1`.`name`, `NormCategory1`.`sort`, `NormCategory1`.`is_delete`, `NormCategory1`.`modify_id`, `NormCategory1`.`create_id`, `NormCategory1`.`modified`, `NormCategory1`.`created`, `NormCategory2`.`id`, `NormCategory2`.`norm_id`, `NormCategory2`.`name`, `NormCategory2`.`sort`, `NormCategory2`.`is_delete`, `NormCategory2`.`modify_id`, `NormCategory2`.`create_id`, `NormCategory2`.`modified`, `NormCategory2`.`created` FROM `k9k`.`printing_product_norms` AS `PrintingProductNorm` LEFT JOIN `k9k`.`printing_products` AS `PrintingProduct` ON (`PrintingProductNorm`.`printing_product_id` = `PrintingProduct`.`id`) LEFT JOIN `k9k`.`norm_categories` AS `NormCategory1` ON (`PrintingProductNorm`.`norm_category_id1` = `NormCategory1`.`id`) LEFT JOIN `k9k`.`norm_categories` AS `NormCategory2` ON (`PrintingProductNorm`.`norm_category_id2` = `NormCategory2`.`id`) WHERE `PrintingProductNorm`.`id` = 6853 LIMIT 1 | | 1 | 1 | 1 |
44 | SELECT name FROM norm_categories WHERE norm_id = 24 AND `name` > 132 ORDER BY `sort` ASC limit 1 | | 1 | 1 | 1 |
45 | SELECT `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` FROM `k9k`.`options` AS `Option` WHERE `is_printing_estimate_show` = 3 AND `is_delete` = 0 | | 2 | 2 | 1 |
46 | SELECT `OptionCategory`.`id`, `OptionCategory`.`name` FROM `k9k`.`option_categories` AS `OptionCategory` LEFT JOIN `k9k`.`options` AS `Option` ON (`OptionCategory`.`option_id` = `Option`.`id`) WHERE `option_id` = 486 AND `OptionCategory`.`is_delete` = 0 ORDER BY `OptionCategory`.`sort` ASC | | 12 | 12 | 12 |
47 | SELECT `OptionCategory`.`id`, `OptionCategory`.`name` FROM `k9k`.`option_categories` AS `OptionCategory` LEFT JOIN `k9k`.`options` AS `Option` ON (`OptionCategory`.`option_id` = `Option`.`id`) WHERE `option_id` = 487 AND `OptionCategory`.`is_delete` = 0 ORDER BY `OptionCategory`.`sort` ASC | | 4 | 4 | 12 |
48 | SELECT `PrintingProduct`.`id`, `PrintingProduct`.`is_print_type`, `PrintingProduct`.`is_color_type`, `PrintingProduct`.`is_size_type`, `PrintingProduct`.`norm_id1`, `PrintingProduct`.`norm_id2`, `PrintingProduct`.`wp_url`, `PrintingProduct`.`memo`, `PrintingProduct`.`is_delete`, `PrintingProduct`.`modify_id`, `PrintingProduct`.`create_id`, `PrintingProduct`.`modified`, `PrintingProduct`.`created` FROM `k9k`.`printing_products` AS `PrintingProduct` WHERE `is_delete` = 0 AND `id` = 8 LIMIT 1 | | 1 | 1 | 0 |