| 0.0003 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = 'e9958505743cb800257ed2b70b0f4a672d78957a'Speed: 0.0003 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0001 |
SELECT GET_LOCK('73d354b2f84a39f5bd0004f655405ffe', 300) AS ci_session_lockSpeed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0002 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = 'e9958505743cb800257ed2b70b0f4a672d78957a'Speed: 0.0002 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `distribution_points`
WHERE `domain` = 'bze.90to.ru'Speed: 0.0003 - Possible keys: domain - Key Used: domain - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `distribution_points`
WHERE `id` = '3'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `map_options`
WHERE `distribution_point` = '3'Speed: 0.0002 - Possible keys: distribution_point - Key Used: distribution_point - Type: ref - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_models`
WHERE `id` = '1209'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '65580'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_models`
WHERE `id` = '1209'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_brands`
WHERE `id` = '10'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'BIG FILTER'
AND `article` = 'gb9968'Speed: 0.0003 - Possible keys: article - Key Used: article - Type: const - Rows: 1 - Extra: |
| 0.0002 |
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` = 5Speed: 0.0002 - Possible keys: distribution_point - Key Used: - Type: ALL - Rows: 21 - Extra: Using where |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '700'
AND `firm` = '3F QUALITY'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'ms6413'
AND `firm` = 'ALCO'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'mc5121'
AND `firm` = 'AMC FILTER'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '21mama12'
AND `firm` = 'ASHIKA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'gb9968'
AND `firm` = 'BIG FILTER'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'gb9968c'
AND `firm` = 'BIG FILTER'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'adm52522'
AND `firm` = 'BLUE PRINT'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '1987432209'
AND `firm` = 'BOSCH'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'brc0824'
AND `firm` = 'BRONCO'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ccf0466'
AND `firm` = 'CHAMPION'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ekf3362'
AND `firm` = 'COMLINE'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '80001735'
AND `firm` = 'CORTECO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '80001736'
AND `firm` = 'CORTECO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'b140g0004'
AND `firm` = 'CWORKS'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'tsp0325332'
AND `firm` = 'DELPHI'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'dx400342'
AND `firm` = 'DEXTRIM'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '1110050023'
AND `firm` = 'DODA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'dcf501s'
AND `firm` = 'DYNAMATRIX-KOREA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'fcc119'
AND `firm` = 'FENOX'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'fcs119'
AND `firm` = 'FENOX'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'k13122x'
AND `firm` = 'FILTRON'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'fs074'
AND `firm` = 'FORTECH'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'cf108242'
AND `firm` = 'FRAM'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'ag3562kcf'
AND `firm` = 'GOODWILL'
AND `cols` > 0
ORDER BY case when distribution_point=3 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,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ag3782kcfc'
AND `firm` = 'GOODWILL'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'if0183'
AND `firm` = 'GREEN FILTER'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'e3928li2'
AND `firm` = 'HENGST'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ib772030'
AND `firm` = 'IBERIS'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'faama12'
AND `firm` = 'JAPANPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '21ma12'
AND `firm` = 'JAPKO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'ac0157set'
AND `firm` = 'JS ASAKASHI'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0005 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); Using where; Using filesort |
| 0.0005 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'jdacx048c'
AND `firm` = 'JUST DRIVE'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'kc0054'
AND `firm` = 'KORTEX'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'kc0054s'
AND `firm` = 'KORTEX'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'lac1909'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'lac1909c'
AND `firm` = 'LYNXAUTO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'la501s'
AND `firm` = 'MAHLE/KNECHT'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'cu260082'
AND `firm` = 'MANN-FILTER'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '65544'
AND `firm` = 'MAPCO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'mc2044cl'
AND `firm` = 'MASUMA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'bbp261j6x'
AND `firm` = 'MAZDA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'bbp261j6x9a'
AND `firm` = 'MAZDA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '17535x2'
AND `firm` = 'MEAT & DORIA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '1010039'
AND `firm` = 'METACO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '1010039c'
AND `firm` = 'METACO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'rcf8858b'
AND `firm` = 'MICRO'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'afw2199'
AND `firm` = 'MILES'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'afw2293'
AND `firm` = 'MILES'
AND `cols` > 0
ORDER BY case when distribution_point=3 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('3')
AND `code` = 'fc211ny'
AND `firm` = 'NAKAYAMA'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'nfz2120'
AND `firm` = 'NARICHIN'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'n1343020'
AND `firm` = 'NIPPARTS'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'pc408c'
AND `firm` = 'PARTS-MALL'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'pf2220'
AND `firm` = 'PATRON'
AND `cols` > 0
ORDER BY case when distribution_point=3 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.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ah2922'
AND `firm` = 'PURFLUX'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ca17150'
AND `firm` = 'SAKURA'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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('3')
AND `code` = 'cac17150'
AND `firm` = 'SAKURA'
AND `cols` > 0
ORDER BY case when distribution_point=3 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,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'stbbp261j6x'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 's043081'
AND `firm` = 'SHIBATO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'egc599c'
AND `firm` = 'SI VENTO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'g306'
AND `firm` = 'SI VENTO'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = '7110411sx'
AND `firm` = 'STELLOX'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ac406e'
AND `firm` = 'VIC'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'ac406ex'
AND `firm` = 'VIC'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'if3166'
AND `firm` = 'ZEKKERT'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0003 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('3')
AND `code` = 'if3166k'
AND `firm` = 'ZEKKERT'
AND `cols` > 0
ORDER BY case when distribution_point=3 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0003 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_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` = '4'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_groupdetails`
WHERE `id` = '11'
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` = '65580'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 *
FROM `autos_brands`
WHERE `id` = '10'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.0272 |
Total Query Execution Time |