| 0.0003 |
SELECT 1
FROM `cardocs_sessions`
WHERE `id` = 'a03174eb441eecb0d9fd4589f47ebfb99477e71a'Speed: 0.0003 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: Using index |
| 0.0140 |
SELECT GET_LOCK('def575f3418747649ba08c92175a709b', 300) AS ci_session_lockSpeed: 0.0140 - Possible keys: - Key Used: - Type: - Rows: - Extra: No tables used |
| 0.0020 |
SELECT `data`
FROM `cardocs_sessions`
WHERE `id` = 'a03174eb441eecb0d9fd4589f47ebfb99477e71a'Speed: 0.0020 - Possible keys: id - Key Used: id - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `distribution_points`
WHERE `domain` = 'test.90to.ru'Speed: 0.0005 - Possible keys: domain - Key Used: domain - Type: const - Rows: 1 - Extra: |
| 0.0005 |
SELECT *
FROM `distribution_points`
WHERE `id` = '1'Speed: 0.0005 - 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` = '653'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0007 |
SELECT *
FROM `autos_model_details`
WHERE `detail_id` = '37557'Speed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `autos_models`
WHERE `id` = '653'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0003 |
SELECT *
FROM `autos_brands`
WHERE `id` = '1'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `my_crosses`
WHERE `brand` = 'NISSAN'
AND `article` = '40202ee500'Speed: 0.0004 - 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.0009 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'dra19943'
AND `firm` = '7RT'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0009 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '25252883'
AND `firm` = 'AMIWA'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'asb23143'
AND `firm` = 'ANTO'
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` = 'nswhc11xfrm'
AND `firm` = 'ASVA'
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` = 'gf050039'
AND `firm` = 'AUTOSFEC'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'gf050390'
AND `firm` = 'AUTOSFEC'
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` = 'aw2220428'
AND `firm` = 'AYWIPARTS'
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` = 'bk5981'
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.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` = 'h12052bta'
AND `firm` = 'BTA'
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` = 'czd40202em00a'
AND `firm` = 'CZD'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '107168'
AND `firm` = 'DEQST'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1060200164'
AND `firm` = 'DODA'
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` = 'hcjn0010mf'
AND `firm` = 'DRIVESTAR'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '713613980'
AND `firm` = 'FAG'
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` = '0282c11xfrm'
AND `firm` = 'FEBEST'
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` = '777c13149'
AND `firm` = 'FENKO'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'whb81166'
AND `firm` = 'FENOX'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'wh016'
AND `firm` = 'FINWHALE'
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` = '41498030s'
AND `firm` = 'FORMPART'
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` = 'gik05038'
AND `firm` = 'GANZ'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'gh31990'
AND `firm` = 'GMB'
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` = 'gh31990m'
AND `firm` = 'GMB'
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` = '9325016'
AND `firm` = 'GSP'
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` = '9325016k'
AND `firm` = 'GSP'
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` = '30204124'
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.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` = 'rv0161'
AND `firm` = 'HAFT'
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` = 'zzxv17658'
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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'ib4117'
AND `firm` = 'IBERIS'
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` = 'pw22001'
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.0008 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'jeh0054'
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.0008 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'kt100626'
AND `firm` = 'KRAFT'
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` = 'k151600'
AND `firm` = 'KRONER'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'lg402021fc0b'
AND `firm` = 'LINKGLOBAL'
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` = 'wh1031'
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` = 'm8137535'
AND `firm` = 'MARSHALL'
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` = '330860'
AND `firm` = 'MAXGEAR'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '5000008'
AND `firm` = 'METACO'
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` = 'db83007'
AND `firm` = 'MILES'
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` = 'mv40202em00a'
AND `firm` = 'MV-PARTS'
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` = 'mv40202jp11a'
AND `firm` = 'MV-PARTS'
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` = 'm2208ny'
AND `firm` = 'NAKAYAMA'
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` = 'n1a15793'
AND `firm` = 'NEROLI'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '40202ee500'
AND `firm` = 'NISSAN'
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,firm - Type: index_merge - Rows: 1 - Extra: Using intersect(code,firm); 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` = '40202em00a'
AND `firm` = 'NISSAN'
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` = '40202em30a'
AND `firm` = 'NISSAN'
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` = '40202em31a'
AND `firm` = 'NISSAN'
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` = '40202zw70a'
AND `firm` = 'NISSAN'
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` = '752234'
AND `firm` = 'NK'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'r16877'
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.0007 - 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.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'klpns052'
AND `firm` = 'NTY'
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` = 'nu7se14412'
AND `firm` = 'NUVICO'
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` = '961207'
AND `firm` = 'OPTIMAL'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0007 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '1bk162h'
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.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` = 'pbk4010h'
AND `firm` = 'PATRON'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0007 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = 'qf10d00049'
AND `firm` = 'QUATTRO FRENI'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.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` = 'ff3u14750'
AND `firm` = 'RUFF'
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` = 'st40202em00a'
AND `firm` = 'SAT'
AND `cols` > 0
ORDER BY case when distribution_point=1 then 1 else 0 end DESC, `price_actual_date` DESCSpeed: 0.0006 - Possible keys: distribution_point,distribution_point_2,code,firm,distribution_point_4,distribution_point_3,distribution_point_5 - Key Used: code - Type: ref - Rows: 1 - Extra: Using index condition; Using where; Using filesort |
| 0.0006 |
SELECT *
FROM `stockroom_exists`
WHERE `distribution_point` IN('2', '7', '12', '1', '21', '20', '26', '27', '29')
AND `code` = '4rkf15176'
AND `firm` = 'SHIMO'
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` = 'vkba7535'
AND `firm` = 'SKF'
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` = '4329035sx'
AND `firm` = 'STELLOX'
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` = 'pl983'
AND `firm` = 'TORQUE'
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` = 'mr1439'
AND `firm` = 'TRIALLI'
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` = 'rl1362'
AND `firm` = 'ZEKKERT'
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` = 'z89121r'
AND `firm` = 'ZIKMAR'
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` = 'hgb35175'
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.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.0002 |
SELECT *
FROM `autos_details`
WHERE `id` = '1'
LIMIT 1Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_groupdetails`
WHERE `id` = '55'
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` = '37557'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0004 |
SELECT *
FROM `brand_label`Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 325 - Extra: |
| 0.0003 |
SELECT `id`, `delivery_time`
FROM `distribution_points`Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 21 - Extra: |
| 0.0002 |
SELECT *
FROM `autos_brands`
WHERE `id` = '1'Speed: 0.0002 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra: |
| 0.0012 |
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.0012 - Possible keys: - Key Used: - Type: ALL - Rows: 21 - Extra: Using where; Using temporary; Using filesort |
| 0.0642 |
Total Query Execution Time |