| 0.0002 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = '6b3e8f8e3f58d67460614b28aed0efd8bbc0e090'Speed: 0.0002 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0003 |
SELECT GET_LOCK('0c34de6a2cfffdf0888c764ba7a98e89', 300) AS ci_session_lockSpeed: 0.0003 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0002 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = '6b3e8f8e3f58d67460614b28aed0efd8bbc0e090'Speed: 0.0002 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `distribution_points`
WHERE `domain` = 'test.90to.ru'Speed: 0.0003 - Possible keys: domain - Key Used: domain - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `distribution_points`
WHERE `id` = '1'Speed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `map_options`
WHERE `distribution_point` = '1'Speed: 0.0002 - Possible keys: distribution_point - Key Used: distribution_point - Type: ref - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `autos_models`
WHERE `id` = '309'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '37851'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `autos_models`
WHERE `id` = '309'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `autos_brands`
WHERE `id` = '4'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'TOYOTA'
AND `article` = '0447860050'Speed: 0.0003 - Possible keys: article - Key Used: article - Type: const - Rows: 1 - Extra: |
| 0.0004 |
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.0004 - Possible keys: distribution_point - Key Used: - Type: ALL - Rows: 21 - Extra: Using where |
| 0.0011 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '777x27238'
AND `firm` = '7RT'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0011 - 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` = 'sp119a'
AND `firm` = 'ADVICS'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '100a22745'
AND `firm` = 'ANTO'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'br0366'
AND `firm` = 'BLITZ'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'br0373'
AND `firm` = 'BLITZ'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0009 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '145ce2614'
AND `firm` = 'CENTO'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'de7845t'
AND `firm` = 'DEPPUL'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '108056'
AND `firm` = 'DEQST'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '400772'
AND `firm` = 'ERT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '400863'
AND `firm` = 'ERT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '0175gsj15f'
AND `firm` = 'FEBEST'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0010 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'crk1019'
AND `firm` = 'FENOX'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'rk401'
AND `firm` = 'FLO AUTO MECHANICS'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '245016'
AND `firm` = 'FRENKIT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); 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` = 'gk269'
AND `firm` = 'G-BRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0010 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '00x22957'
AND `firm` = 'HESSA'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'hlrem115'
AND `firm` = 'HLLT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'kbr121'
AND `firm` = 'KORTEX'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bc0279'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'bc6242'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'mag200019'
AND `firm` = 'MAGTECHNIC'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '77a1201'
AND `firm` = 'MASTERKIT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'mbb0026'
AND `firm` = 'MASUMA'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'n55l22362'
AND `firm` = 'NEROLI'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'nsp040447860050'
AND `firm` = 'NSP'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'pq4500511'
AND `firm` = 'PAQ'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'prk255'
AND `firm` = 'PATRON'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'qz4605a483'
AND `firm` = 'QUARTZ'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'qf40f00002'
AND `firm` = 'QUATTRO FRENI'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'rp0447860050'
AND `firm` = 'ROERS-PARTS'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'st0447860050'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'st0447960081'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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.0011 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'st630013'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0011 - 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` = '26041119'
AND `firm` = 'SEIKEN'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'd4683'
AND `firm` = 'SEINSA AUTOFREN'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'd4776'
AND `firm` = 'SEINSA AUTOFREN'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '0499070sx'
AND `firm` = 'STELLOX'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'tcg1201'
AND `firm` = 'TATSUMI'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'tcg1213'
AND `firm` = 'TATSUMI'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'tg0447860050'
AND `firm` = 'TI-GUAR'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'tg0447960081'
AND `firm` = 'TI-GUAR'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '0447860050'
AND `firm` = 'TOYOTA'
AND `cols` > 0
ORDER BY case when distribution_point=1 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,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` = 'uct60044050'
AND `firm` = 'UKOR AUTO'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'br1144'
AND `firm` = 'ZEKKERT'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = 'zv7845'
AND `firm` = 'ZZVF'
AND `cols` > 0
ORDER BY case when distribution_point=1 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` = '80'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '37851'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `brand_label`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 325 - Extra: |
| 0.0002 |
SELECT `id`, `delivery_time`
FROM `distribution_points`Speed: 0.0002 - 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.0363 |
Total Query Execution Time |
Премиум 
Рекомендуем 
Эконом 
Китай 
Без гарантии 
нет данных