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