Height | 0.5mm Pitch | 0.635mm Pitch | 1mm Pitch | 1.25mm Pitch | 2mm Pitch |
---|---|---|---|---|---|
8.10mm |
+1.0 / -1.0 Pin8 18 26 30 |
||||
8.75mm |
+0.5 / -0.5 Pin10 30 40 50 60 |
||||
10.70mm |
+0.5 / -0.5 Pin30 40 50 60 80 90 100 120 |
||||
11.00mm |
+0.5 / -0.5 Pin40 50 60 80 100 120 140 160 |
||||
11.70mm |
+0.5 / -0.5 Pin30 40 50 60 80 90 120 |
||||
12.00mm |
+0.5 / -0.5 Pin40 60 80 100 120 140 |
||||
12.20mm |
+0.5 / -0.5 Pin30 40 50 60 80 90 120 |
||||
13.10mm |
+0.8 / -0.8 Pin6 8 10 12 14 16 18 20 22 24 26 28 30 |
||||
13.90mm |
+1.0 / -1.0 Pin6 8 10 12 16 18 20 22 24 26 30 |
||||
14.30mm |
+1.0 / -1.0 Pin6 8 10 12 14 16 18 20 22 24 26 28 30 |
||||
14.60mm |
+0.8 / -0.8 Pin6 8 10 12 14 16 18 20 22 24 28 30 |
||||
16.10mm |
+0.8 / -0.8 Pin6 8 10 12 14 16 18 20 22 24 26 28 30 |
||||
16.70mm |
+0.5 / -0.5 Pin30 40 50 60 80 90 120 |
||||
18.75mm |
+0.5 / -0.5 Pin30 50 60 80 90 120 |
||||
19.60mm |
+0.8 / -0.8 Pin6 8 10 12 14 16 18 20 22 24 28 30 |
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | show columns from `matings` | 11 | 11 | 0 | |
2 | SELECT `Mating`.`id`, `Mating`.`type`, `Mating`.`height`, `Mating`.`mating_min`, `Mating`.`mating_max`, `Mating`.`series_id1`, `Mating`.`series_id2`, `Mating`.`type1`, `Mating`.`type2`, `Mating`.`created`, `Mating`.`modified` FROM `irisoweb_test`.`matings` AS `Mating` WHERE `type` = 'RightAngle' | 46 | 46 | 1 | |
3 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 19) AND (`type` = 'A'))) OR (((`series_id` = 20) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 5 | 5 | 11 | |
4 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 19) AND (`type` = 'A'))) OR (((`series_id` = 20) AND (`type` = 'B')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 5 | 5 | 11 | |
5 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 19) AND (`type` = 'B'))) OR (((`series_id` = 20) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 5 | 5 | 11 | |
6 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 19) AND (`type` = 'B'))) OR (((`series_id` = 20) AND (`type` = 'B')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 0 | 0 | 11 | |
7 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'B'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 12 | |
8 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'B'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 11 | |
9 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'A'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 11 | |
10 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'A'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 0 | 0 | 11 | |
11 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'F'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 11 | |
12 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'F'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 3 | 3 | 14 | |
13 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'E'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 13 | |
14 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'D'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 11 | |
15 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'D'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 2 | 2 | 11 | |
16 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'C'))) OR (((`series_id` = 560) AND (`type` = 'F')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 11 | |
17 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'C'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 0 | 0 | 11 | |
18 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 8 | 8 | 11 | |
19 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'B')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 15 | |
20 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 16 | |
21 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'B')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 2 | 2 | 16 | |
22 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 16 | |
23 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 16 | |
24 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 11 | |
25 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'D')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 2 | 2 | 11 | |
26 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 11 | |
27 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'H')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 11 | |
28 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 3 | 3 | 11 | |
29 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'B'))) OR (((`series_id` = 17) AND (`type` = 'H')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 1 | 1 | 11 | |
30 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'A'))) OR (((`series_id` = 481) AND (`type` = 'N')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 13 | 13 | 16 | |
31 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'A'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 13 | 13 | 16 | |
32 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'Z04'))) OR (((`series_id` = 481) AND (`type` = 'N')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 13 | 13 | 16 | |
33 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'Z04'))) OR (((`series_id` = 481) AND (`type` = 'W')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 13 | 13 | 16 | |
34 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'A'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 11 | 11 | 15 | |
35 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'Z04'))) OR (((`series_id` = 485) AND (`type` = 'Z02')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 11 | 11 | 12 | |
36 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'A'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 12 | 12 | 11 | |
37 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'Z04'))) OR (((`series_id` = 489) AND (`type` = 'J')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 12 | 12 | 11 | |
38 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'A'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 12 | 12 | 11 | |
39 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 480) AND (`type` = 'Z04'))) OR (((`series_id` = 493) AND (`type` = 'G')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 11 | 11 | 11 | |
40 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 507) AND (`type` = 'A'))) OR (((`series_id` = 508) AND (`type` = 'K')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 11 | 11 | 16 | |
41 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 507) AND (`type` = 'B'))) OR (((`series_id` = 508) AND (`type` = 'K')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 13 | 13 | 14 | |
42 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 510) AND (`type` = 'Z08'))) OR (((`series_id` = 508) AND (`type` = 'K')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 9 | 9 | 16 | |
43 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 450) AND (`type` = 'A'))) OR (((`series_id` = 451) AND (`type` = 'C')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 4 | 4 | 16 | |
44 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 317) AND (`type` = 'A'))) OR (((`series_id` = 316) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 11 | 11 | 15 | |
45 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 317) AND (`type` = 'A'))) OR (((`series_id` = 316) AND (`type` = 'Z04')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 1 | 1 | 16 | |
46 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 17) AND (`type` = 'L')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 6 | 6 | 17 | |
47 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 18) AND (`type` = 'A'))) OR (((`series_id` = 33) AND (`type` = 'A')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 7 | 7 | 15 | |
48 | SELECT `Product`.`嵌合部ピッチ`, `Product`.`極数` FROM `irisoweb_test`.`products` AS `Product` WHERE ((((`series_id` = 558) AND (`type` = 'E'))) OR (((`series_id` = 560) AND (`type` = 'E')))) AND 販売分類 = 'Preferred' GROUP BY 嵌合部ピッチ, 極数 | 0 | 0 | 16 |