| 0.0004 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = '34ac433516f32c15b4acc379f714292fc5f60f3a'Speed: 0.0004 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0002 |
SELECT GET_LOCK('f22f439de03c225588964a334d709154', 300) AS ci_session_lockSpeed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0002 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = '34ac433516f32c15b4acc379f714292fc5f60f3a'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.0003 |
SELECT *
FROM `distribution_points`
WHERE `id` = '1'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `map_options`
WHERE `distribution_point` = '1'Speed: 0.0003 - Possible keys: distribution_point - Key Used: distribution_point - Type: ref - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `autos_models`
WHERE `id` = '1158'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '63122'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM `autos_models`
WHERE `id` = '1158'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM `autos_brands`
WHERE `id` = '22'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'VAG'
AND `article` = '8e0498625b'Speed: 0.0007 - 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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'dra31809'
AND `firm` = '7RT'
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` = 'asb35009'
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.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'adwh8ebf'
AND `firm` = 'ASVA'
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` = '110084810'
AND `firm` = 'AUTOMEGA'
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` = 'bk1034'
AND `firm` = 'B-RING'
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` = 'hbk1034'
AND `firm` = 'B-RING'
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` = 'bsg90600011'
AND `firm` = 'BSG AUTO PARTS'
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` = 'cha029'
AND `firm` = 'COMLINE'
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` = 'cha088'
AND `firm` = 'COMLINE'
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` = '107073'
AND `firm` = 'DEQST'
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` = 'eb108811'
AND `firm` = 'DJB'
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` = 'eb5419'
AND `firm` = 'DJB'
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` = 'dwh3536'
AND `firm` = 'DYNAMATRIX-KOREA'
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` = '29skv029'
AND `firm` = 'ESEN SKV'
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` = '1623952580'
AND `firm` = 'EUROREPAR'
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` = '713610380'
AND `firm` = 'FAG'
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` = '713610390'
AND `firm` = 'FAG'
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` = '713610430'
AND `firm` = 'FAG'
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` = '1782a4f'
AND `firm` = 'FEBEST'
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` = '26376'
AND `firm` = 'FEBI'
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` = '29837'
AND `firm` = 'FEBI'
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` = 'whb71103'
AND `firm` = 'FENOX'
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` = 'gh21940'
AND `firm` = 'GMB'
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` = '9245010'
AND `firm` = 'GSP'
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` = '30204064'
AND `firm` = 'H&Q'
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` = 'rv0142'
AND `firm` = 'HAFT'
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` = 'h20041'
AND `firm` = 'HARUMA'
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` = '501010'
AND `firm` = 'HDE'
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` = 'zzxv29524'
AND `firm` = 'HESSA'
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` = 'ib4274'
AND `firm` = 'IBERIS'
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` = '101111'
AND `firm` = 'IJS'
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` = 'ij132005'
AND `firm` = 'ILJIN'
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` = 'ij132025'
AND `firm` = 'ILJIN'
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` = 'hwb33006'
AND `firm` = 'JIKIU'
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.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1141302210'
AND `firm` = 'JP GROUP'
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` = 'jeh0151'
AND `firm` = 'JUST DRIVE'
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` = '5500130'
AND `firm` = 'KAMOKA'
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` = 'khb4203std'
AND `firm` = 'KORTEX'
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` = 'kt100642'
AND `firm` = 'KRAFT'
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` = 'wbk0006du'
AND `firm` = 'KRAUF'
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.0015 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'k151304'
AND `firm` = 'KRONER'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0015 - 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` = 'lgr4751'
AND `firm` = 'LGR'
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` = '713610430'
AND `firm` = 'LUK'
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` = 'wb1001'
AND `firm` = 'LYNXAUTO'
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` = 'mt5726'
AND `firm` = 'M-TEX'
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` = '26754'
AND `firm` = 'MAPCO'
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` = 'm8133536'
AND `firm` = 'MARSHALL'
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` = '3605setms'
AND `firm` = 'MASTER-SPORT'
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` = 'mwe1034'
AND `firm` = 'MASUMA'
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` = '330402'
AND `firm` = 'MAXGEAR'
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` = '191581'
AND `firm` = 'METELLI'
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` = '1004070092'
AND `firm` = 'MEYLE'
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` = '1004980122'
AND `firm` = 'MEYLE'
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` = '1006530033'
AND `firm` = 'MEYLE'
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` = '1006530034'
AND `firm` = 'MEYLE'
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` = 'auwb11008'
AND `firm` = 'MOOG'
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` = 'm2193ny'
AND `firm` = 'NAKAYAMA'
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` = 'nbe1112'
AND `firm` = 'NARICHIN'
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` = 'n1a27659'
AND `firm` = 'NEROLI'
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` = '754729'
AND `firm` = 'NK'
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` = 'r15726'
AND `firm` = 'NTN-SNR'
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` = 'klpau006'
AND `firm` = 'NTY'
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` = '100053'
AND `firm` = 'OPTIMAL'
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` = '06826'
AND `firm` = 'OSSCA'
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` = '1bk125h'
AND `firm` = 'PART-ONE'
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` = 'pbk3536h'
AND `firm` = 'PATRON'
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` = 'wb3008'
AND `firm` = 'QML'
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` = 'rg8e0598625a'
AND `firm` = 'RIGINAL'
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` = 'rggh20460'
AND `firm` = 'RIGINAL'
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` = 'st8e0498625a'
AND `firm` = 'SAT'
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` = 'vkba3536'
AND `firm` = 'SKF'
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` = '4030051sx'
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.0004 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '4328717sx'
AND `firm` = 'STELLOX'
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` = 'sm1144'
AND `firm` = 'SUFIX'
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` = '32926376'
AND `firm` = 'SWAG'
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` = 'tde1052'
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` = '110517'
AND `firm` = 'TOPRAN'
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` = '110517001'
AND `firm` = 'TOPRAN'
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` = 'gr1185'
AND `firm` = 'TRAFORD RING'
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` = 'mr1831'
AND `firm` = 'TRIALLI'
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` = '0731183'
AND `firm` = 'TRUCKTEC'
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` = '4d0407625d'
AND `firm` = 'VAG'
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` = '4d0407625h'
AND `firm` = 'VAG'
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` = '8d0498625c'
AND `firm` = 'VAG'
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` = '8e0498625a'
AND `firm` = 'VAG'
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` = '8e0498625b'
AND `firm` = 'VAG'
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` = 'v102109'
AND `firm` = 'VAICO'
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` = '44980800201'
AND `firm` = 'VIKA'
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` = 'voevhb2029'
AND `firm` = 'VOE'
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` = 'ykm7125040701'
AND `firm` = 'YOKOMITSU'
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` = '236n10092z'
AND `firm` = 'ZAUFER'
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` = 'rl1343'
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` = 'z89176r'
AND `firm` = 'ZIKMAR'
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` = '1'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `autos_groupdetails`
WHERE `id` = '55'
LIMIT 1Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '63122'Speed: 0.0002 - 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.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` = '22'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.0496 |
Total Query Execution Time |
Премиум 
Рекомендуем 
Эконом 
Китай 
Без гарантии 
нет данных