| 0.0006 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = 'b19f778f318d9f9262704b0d2553cd3c23ff1fe5'Speed: 0.0006 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0007 |
SELECT GET_LOCK('e79eb51fa9ccb0bd5298cfa3aba0b30a', 300) AS ci_session_lockSpeed: 0.0007 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0002 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = 'b19f778f318d9f9262704b0d2553cd3c23ff1fe5'Speed: 0.0002 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: |
| 0.0012 |
SELECT *
FROM `distribution_points`
WHERE `domain` = 'jpw.90to.ru'Speed: 0.0012 - Possible keys: domain - Key Used: domain - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `distribution_points`
WHERE `id` = '7'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0013 |
SELECT *
FROM `map_options`
WHERE `distribution_point` = '7'Speed: 0.0013 - Possible keys: distribution_point - Key Used: distribution_point - Type: ref - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_models`
WHERE `id` = '1077'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '60584'Speed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0015 |
SELECT *
FROM `autos_models`
WHERE `id` = '1077'Speed: 0.0015 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `autos_brands`
WHERE `id` = '4'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'TOYOTA'
AND `article` = '044660f010'Speed: 0.0005 - Possible keys: article - Key Used: article - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT `distribution_points`.`id`,`distribution_points`.`rule` FROM `distribution_points` join `map_options` on `distribution_points`.`id` = `map_options`.`distribution_point` WHERE `distribution_points`.`organization`=1 and `map_options`.`map_region` = 2Speed: 0.0005 - Possible keys: distribution_point - Key Used: - Type: ALL - Rows: 21 - Extra: Using where |
| 0.0010 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '37735'
AND `firm` = 'ABS'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0010 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0009 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'sn154p'
AND `firm` = 'ADVICS'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0009 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'adb36010'
AND `firm` = 'ALLIED NIPPON'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '5102224'
AND `firm` = 'ASHIKA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '13046038542'
AND `firm` = 'ATE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bb0500'
AND `firm` = 'BLITZ'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'adt342183'
AND `firm` = 'BLUE PRINT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'adt342184'
AND `firm` = 'BLUE PRINT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '0986494404'
AND `firm` = 'BOSCH'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '986494404'
AND `firm` = 'BOSCH'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'p83114'
AND `firm` = 'BREMBO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'lp2193'
AND `firm` = 'DELPHI'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'dfp3547'
AND `firm` = 'DOUBLE FORCE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '322077cegt'
AND `firm` = 'EGT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '322077egt'
AND `firm` = 'EGT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '322077iegt'
AND `firm` = 'EGT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '5502224592'
AND `firm` = 'EUROBRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '116304'
AND `firm` = 'FEBI'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '175211'
AND `firm` = 'FEBI'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'fdb4275'
AND `firm` = 'FERODO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'gp02320'
AND `firm` = 'GBRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '181945'
AND `firm` = 'ICER'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'pp224af'
AND `firm` = 'JAPANPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '4863602010'
AND `firm` = 'JP GROUP'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '572623j'
AND `firm` = 'JURID'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'jq101269'
AND `firm` = 'KAMOKA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'd2320mh'
AND `firm` = 'KASHIYAMA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bd7601'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'mbf016039'
AND `firm` = 'MANDO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '193006'
AND `firm` = 'MAXGEAR'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '3010164'
AND `firm` = 'METACO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '2208800'
AND `firm` = 'METELLI'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1170410'
AND `firm` = 'METZGER'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '0252492616w'
AND `firm` = 'MEYLE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'e410634'
AND `firm` = 'MILES'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'mdb3054'
AND `firm` = 'MINTEX'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'hp8598ny'
AND `firm` = 'NAKAYAMA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'pn1842'
AND `firm` = 'NIBK'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'n3612040'
AND `firm` = 'NIPPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'np1127'
AND `firm` = 'NISSHINBO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '224592'
AND `firm` = 'NK'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1091298'
AND `firm` = 'OJD (QUICK BRAKE)'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1131486x'
AND `firm` = 'OJD (QUICK BRAKE)'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 't282216y'
AND `firm` = 'PARAUT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'qp4929'
AND `firm` = 'QUARO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '145202'
AND `firm` = 'REMSA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '6013763'
AND `firm` = 'SAKURA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'sp4142'
AND `firm` = 'SANGSIN BRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'st044660f010'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bp21842'
AND `firm` = 'SB NAGAMOCHI'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'sg700082'
AND `firm` = 'SEGMATIC'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 's701820'
AND `firm` = 'SRLINE'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '000437bsx'
AND `firm` = 'STELLOX'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '2492601'
AND `firm` = 'TEXTAR'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '044660f010'
AND `firm` = 'TOYOTA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '044660f011'
AND `firm` = 'TOYOTA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '04466yzze7'
AND `firm` = 'TOYOTA'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '811013108'
AND `firm` = 'TRISCAN'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '8970'
AND `firm` = 'TRUSTING'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'gdb3547'
AND `firm` = 'TRW'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '601064'
AND `firm` = 'VALEO'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'w1516bp'
AND `firm` = 'WINKOD'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bs2095'
AND `firm` = 'ZEKKERT'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '249261651'
AND `firm` = 'ZIMMERMANN'
AND `cols` > 0
ORDER BY case when distribution_point=7 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0004 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0002 |
SELECT *
FROM `autos_details`
WHERE `id` = '3'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_groupdetails`
WHERE `id` = '77'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '60584'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `brand_label`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 325 - Extra: |
| 0.0001 |
SELECT `id`, `delivery_time`
FROM `distribution_points`Speed: 0.0001 - Possible keys: - Key Used: - Type: ALL - Rows: 21 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_brands`
WHERE `id` = '4'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0009 |
SELECT `id`, `domicile`, `telephone`, `distribution_points`.`name`, `map_region`, `map_longitude`, `map_latitude`, `map_name`, `map_contact`, `map_activity`, `regions`.`name` as `name_region`
FROM `distribution_points`
LEFT JOIN `map_options` ON `map_options`.`distribution_point` = `distribution_points`.`id`
LEFT JOIN `regions` ON `id_region` = `map_region`
WHERE `domainrequest` = '1'
AND `organization` = '1'
ORDER BY `name_region` ASC, `map_name` ASCSpeed: 0.0009 - Possible keys: - Key Used: - Type: ALL - Rows: 21 - Extra: Using where; Using temporary; Using filesort |
| 0.0424 |
Total Query Execution Time |