| 0.0002 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = 'ea7b54b31cd25fc047fa4cfef83c3aad5cba1a7e'Speed: 0.0002 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0001 |
SELECT GET_LOCK('4b4ca4415f86c6e618610d81562d104d', 300) AS ci_session_lockSpeed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0001 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = 'ea7b54b31cd25fc047fa4cfef83c3aad5cba1a7e'Speed: 0.0001 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `distribution_points`
WHERE `domain` = 'jpl.90to.ru'Speed: 0.0003 - Possible keys: domain - Key Used: domain - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `distribution_points`
WHERE `id` = '2'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `map_options`
WHERE `distribution_point` = '2'Speed: 0.0003 - Possible keys: distribution_point - Key Used: distribution_point - Type: ref - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_models`
WHERE `id` = '248'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '63617'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_models`
WHERE `id` = '248'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0001 |
SELECT *
FROM `autos_brands`
WHERE `id` = '23'Speed: 0.0001 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'BMW'
AND `article` = '34216868940'Speed: 0.0002 - Possible keys: article - Key Used: article - Type: const - Rows: 1 - Extra: |
| 0.0003 |
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.0003 - Possible keys: distribution_point - Key Used: - Type: ALL - Rows: 21 - Extra: Using where |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'bw422016'
AND `firm` = 'ABSEL'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'adc1728v'
AND `firm` = 'ALLIED NIPPON'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'ap0022'
AND `firm` = 'ALPHA ENGINEERING'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '24012002061'
AND `firm` = 'ATE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'br0272s'
AND `firm` = 'AVANTECH'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bs0273'
AND `firm` = 'BLITZ'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'adb114304'
AND `firm` = 'BLUE PRINT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '34216771970'
AND `firm` = 'BMW'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '34216793247'
AND `firm` = 'BMW'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '34216868940'
AND `firm` = 'BMW'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '34216886479'
AND `firm` = 'BMW'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '0986479442'
AND `firm` = 'BOSCH'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '986479442'
AND `firm` = 'BOSCH'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'br40973'
AND `firm` = 'BRANNOR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '09992511'
AND `firm` = 'BREMBO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '0999251x'
AND `firm` = 'BREMBO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '3421970s'
AND `firm` = 'BRYMAN'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'adc1758v'
AND `firm` = 'COMLINE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bg4168'
AND `firm` = 'DELPHI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'de0120100002'
AND `firm` = 'DOMINANT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'dbd1715'
AND `firm` = 'DYNAMATRIX-KOREA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'ebd19004'
AND `firm` = 'EAS'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '5815201583'
AND `firm` = 'EUROBRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'er03012051'
AND `firm` = 'EUROREPAR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '36386'
AND `firm` = 'FEBI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'ddf1715'
AND `firm` = 'FERODO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'ddf1715c'
AND `firm` = 'FERODO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bd1970'
AND `firm` = 'FREMAX'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '845235001'
AND `firm` = 'FREY'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'b1g22002061'
AND `firm` = 'GALFER'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'gij06152'
AND `firm` = 'GANZ'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'gr21040'
AND `firm` = 'GBRAKE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'dskr061w'
AND `firm` = 'GERAT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bm34216868940se'
AND `firm` = 'GPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '1463204800'
AND `firm` = 'JP GROUP'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '562521jc'
AND `firm` = 'JURID'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '103216'
AND `firm` = 'KAMOKA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'kd0219'
AND `firm` = 'KORTEX'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'b2054v'
AND `firm` = 'LPR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'b2054v'
AND `firm` = 'LPR/AP'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bn1012'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'mtd1398'
AND `firm` = 'M-TEX'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'm2000612'
AND `firm` = 'MARSHALL'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bde0045'
AND `firm` = 'MASUMA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '192411'
AND `firm` = 'MAXGEAR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '3060096'
AND `firm` = 'METACO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '231025c'
AND `firm` = 'METELLI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '6110589'
AND `firm` = 'METZGER'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '3155230024pd'
AND `firm` = 'MEYLE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'k010038'
AND `firm` = 'MILES'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'k210038'
AND `firm` = 'MILES'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'q5218'
AND `firm` = 'NAKAYAMA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'rn1593'
AND `firm` = 'NIBK'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'rn1593dset'
AND `firm` = 'NIBK'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'rn1593v'
AND `firm` = 'NIBK'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '201583'
AND `firm` = 'NK'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '311583'
AND `firm` = 'NK'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bs8278c'
AND `firm` = 'OPTIMAL'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'db6082'
AND `firm` = 'PARTRA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'pbd4854'
AND `firm` = 'PATRON'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'ebr1031'
AND `firm` = 'POWER STOP'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'qd7585'
AND `firm` = 'QUARO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '6128710'
AND `firm` = 'REMSA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'st34216793247'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'st34216793247pf'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'br32123t'
AND `firm` = 'SB NAGAMOCHI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'd00021'
AND `firm` = 'SCHNIEDER'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'sbd30093201'
AND `firm` = 'SEGMATIC'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '171931'
AND `firm` = 'STARKE'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'fx1004'
AND `firm` = 'SUFIX'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '20936386'
AND `firm` = 'SWAG'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'tcc1049'
AND `firm` = 'TATSUMI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '92161103'
AND `firm` = 'TEXTAR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'tg34216793247'
AND `firm` = 'TI-GUAR'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '502030'
AND `firm` = 'TOPRAN'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'df261502'
AND `firm` = 'TRIALLI'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'df4854s'
AND `firm` = 'TRW'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '297179'
AND `firm` = 'VALEO'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'bs5073'
AND `firm` = 'ZEKKERT'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'z06111'
AND `firm` = 'ZENTPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = 'df4854szfr'
AND `firm` = 'ZF RUSSIA'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '150345020'
AND `firm` = 'ZIMMERMANN'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '150345052'
AND `firm` = 'ZIMMERMANN'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '150345053'
AND `firm` = 'ZIMMERMANN'
AND `cols` > 0
ORDER BY case when distribution_point=2 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` = '91'
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` = '63617'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` = '23'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.0448 |
Total Query Execution Time |
Премиум 
Рекомендуем 
Эконом 
Китай 
Без гарантии 
нет данных