SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003248s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028895s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13818172 LIMIT 5 [ RunTime:0.018767s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13818172 ORDER BY `minOrder` ASC [ RunTime:0.001504s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13818172 ORDER BY `unit` DESC [ RunTime:0.023174s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13818172 LIMIT 2 [ RunTime:0.000496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13818172 ORDER BY `minOrder` ASC [ RunTime:0.004393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077019 LIMIT 5 [ RunTime:0.034077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077019 ORDER BY `minOrder` ASC [ RunTime:0.025376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12077019 ORDER BY `unit` DESC [ RunTime:0.003510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12077019 LIMIT 2 [ RunTime:0.008916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12077019 ORDER BY `minOrder` ASC [ RunTime:0.015595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344812 LIMIT 5 [ RunTime:0.010113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344812 ORDER BY `minOrder` ASC [ RunTime:0.024926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13344812 ORDER BY `unit` DESC [ RunTime:0.011056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13344812 LIMIT 2 [ RunTime:0.030124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13344812 ORDER BY `minOrder` ASC [ RunTime:0.005502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471004 LIMIT 5 [ RunTime:0.014470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471004 ORDER BY `minOrder` ASC [ RunTime:0.051041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471004 ORDER BY `unit` DESC [ RunTime:0.019033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471004 LIMIT 2 [ RunTime:0.066411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471004 ORDER BY `minOrder` ASC [ RunTime:0.056377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045920 LIMIT 5 [ RunTime:0.022853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045920 ORDER BY `minOrder` ASC [ RunTime:0.055147s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12045920 ORDER BY `unit` DESC [ RunTime:0.077424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12045920 LIMIT 2 [ RunTime:0.019431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045920 ORDER BY `minOrder` ASC [ RunTime:0.010642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10854909 LIMIT 5 [ RunTime:0.030394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10854909 ORDER BY `minOrder` ASC [ RunTime:0.096558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10854909 ORDER BY `unit` DESC [ RunTime:0.042960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10854909 LIMIT 2 [ RunTime:0.015778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10854909 ORDER BY `minOrder` ASC [ RunTime:0.019200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898928 LIMIT 5 [ RunTime:0.031250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898928 ORDER BY `minOrder` ASC [ RunTime:0.050878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10898928 ORDER BY `unit` DESC [ RunTime:0.063682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10898928 LIMIT 2 [ RunTime:0.039479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10898928 ORDER BY `minOrder` ASC [ RunTime:0.042244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13516321 LIMIT 5 [ RunTime:0.023106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516321 ORDER BY `minOrder` ASC [ RunTime:0.025110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13516321 ORDER BY `unit` DESC [ RunTime:0.064616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13516321 LIMIT 2 [ RunTime:0.015083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13516321 ORDER BY `minOrder` ASC [ RunTime:0.032360s ]
select * from pdf where partno='5180/20C SL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.029990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17161817 LIMIT 5 [ RunTime:0.031078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161817 ORDER BY `minOrder` ASC [ RunTime:0.052952s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17161817 ORDER BY `unit` DESC [ RunTime:0.015434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17161817 LIMIT 2 [ RunTime:0.014274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161817 ORDER BY `minOrder` ASC [ RunTime:0.009813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17161543 LIMIT 5 [ RunTime:0.046918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161543 ORDER BY `minOrder` ASC [ RunTime:0.016409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17161543 ORDER BY `unit` DESC [ RunTime:0.015271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17161543 LIMIT 2 [ RunTime:0.007590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161543 ORDER BY `minOrder` ASC [ RunTime:0.012789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17161313 LIMIT 5 [ RunTime:0.107132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161313 ORDER BY `minOrder` ASC [ RunTime:0.026934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17161313 ORDER BY `unit` DESC [ RunTime:0.012314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17161313 LIMIT 2 [ RunTime:0.008771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161313 ORDER BY `minOrder` ASC [ RunTime:0.007765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17161220 LIMIT 5 [ RunTime:0.068120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161220 ORDER BY `minOrder` ASC [ RunTime:0.035441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17161220 ORDER BY `unit` DESC [ RunTime:0.044470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17161220 LIMIT 2 [ RunTime:0.041763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17161220 ORDER BY `minOrder` ASC [ RunTime:0.028893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17157983 LIMIT 5 [ RunTime:0.008259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17157983 ORDER BY `minOrder` ASC [ RunTime:0.014595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17157983 ORDER BY `unit` DESC [ RunTime:0.021966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17157983 LIMIT 2 [ RunTime:0.015984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17157983 ORDER BY `minOrder` ASC [ RunTime:0.015710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16436271 LIMIT 5 [ RunTime:0.024970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436271 ORDER BY `minOrder` ASC [ RunTime:0.007699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16436271 ORDER BY `unit` DESC [ RunTime:0.028963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16436271 LIMIT 2 [ RunTime:0.023198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16436271 ORDER BY `minOrder` ASC [ RunTime:0.016708s ]
select * from pdf where partno='518058 NA075' and brandshort='Alpha Wire' limit 1 [ RunTime:0.023466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395936 LIMIT 5 [ RunTime:0.031504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395936 ORDER BY `minOrder` ASC [ RunTime:0.039092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395936 ORDER BY `unit` DESC [ RunTime:0.028830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395936 LIMIT 2 [ RunTime:0.032072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395936 ORDER BY `minOrder` ASC [ RunTime:0.035776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395935 LIMIT 5 [ RunTime:0.085506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395935 ORDER BY `minOrder` ASC [ RunTime:0.042201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395935 ORDER BY `unit` DESC [ RunTime:0.007461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395935 LIMIT 2 [ RunTime:0.052055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395935 ORDER BY `minOrder` ASC [ RunTime:0.035981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395934 LIMIT 5 [ RunTime:0.048335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395934 ORDER BY `minOrder` ASC [ RunTime:0.030497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395934 ORDER BY `unit` DESC [ RunTime:0.057405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395934 LIMIT 2 [ RunTime:0.042342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395934 ORDER BY `minOrder` ASC [ RunTime:0.036722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395932 LIMIT 5 [ RunTime:0.060423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395932 ORDER BY `minOrder` ASC [ RunTime:0.047696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395932 ORDER BY `unit` DESC [ RunTime:0.062944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395932 LIMIT 2 [ RunTime:0.014480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395932 ORDER BY `minOrder` ASC [ RunTime:0.015406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395931 LIMIT 5 [ RunTime:0.014508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395931 ORDER BY `minOrder` ASC [ RunTime:0.014277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395931 ORDER BY `unit` DESC [ RunTime:0.025968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395931 LIMIT 2 [ RunTime:0.049189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395931 ORDER BY `minOrder` ASC [ RunTime:0.003469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395930 LIMIT 5 [ RunTime:0.031483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395930 ORDER BY `minOrder` ASC [ RunTime:0.079846s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395930 ORDER BY `unit` DESC [ RunTime:0.019125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395930 LIMIT 2 [ RunTime:0.113911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395930 ORDER BY `minOrder` ASC [ RunTime:0.071254s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.111539s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32187898 LIMIT 5 [ RunTime:0.066479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187898 ORDER BY `minOrder` ASC [ RunTime:0.019710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32187898 ORDER BY `unit` DESC [ RunTime:0.061383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32187898 LIMIT 2 [ RunTime:0.031780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32187898 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
select * from pdf where partno='5180' and brandshort='adafruit' limit 1 [ RunTime:0.023365s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.024035s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63526747 LIMIT 5 [ RunTime:0.026233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526747 ORDER BY `minOrder` ASC [ RunTime:0.033530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63526747 ORDER BY `unit` DESC [ RunTime:0.035604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63526747 LIMIT 2 [ RunTime:0.046059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63526747 ORDER BY `minOrder` ASC [ RunTime:0.016858s ]
select * from pdf where partno='5180' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.014396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.008307s ]
SELECT `id` FROM `stock` WHERE `id` <> 63526747 AND `partno` = '5180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.008136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12077019 [ RunTime:0.008056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298004 LIMIT 5 [ RunTime:0.005866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298004 ORDER BY `minOrder` ASC [ RunTime:0.014398s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298004 ORDER BY `unit` DESC [ RunTime:0.020972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298004 LIMIT 2 [ RunTime:0.006133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298004 ORDER BY `minOrder` ASC [ RunTime:0.002579s ]
select * from pdf where partno='5180' and brandshort='Pololu' limit 1 [ RunTime:0.000773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.022835s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298004 AND `partno` = '5180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.017092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471004 [ RunTime:0.005226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63293259 LIMIT 5 [ RunTime:0.001467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293259 ORDER BY `minOrder` ASC [ RunTime:0.005757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63293259 ORDER BY `unit` DESC [ RunTime:0.005945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63293259 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63293259 ORDER BY `minOrder` ASC [ RunTime:0.000652s ]
select * from pdf where partno='5180937' and brandshort='Yageo Nexensos' limit 1 [ RunTime:0.003992s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180937' OR `brand` LIKE 'Yageo Nexensos%' ) ) LIMIT 1 [ RunTime:0.003268s ]
SELECT `id` FROM `stock` WHERE `id` <> 63293259 AND `partno` = '5180937' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yageo nexensos%' ) [ RunTime:0.005201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045920 [ RunTime:0.000612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64575918 LIMIT 5 [ RunTime:0.006054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64575918 ORDER BY `minOrder` ASC [ RunTime:0.002479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64575918 ORDER BY `unit` DESC [ RunTime:0.001120s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64575918 LIMIT 2 [ RunTime:0.003533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64575918 ORDER BY `minOrder` ASC [ RunTime:0.003256s ]
select * from pdf where partno='5180CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.003669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001134s ]
SELECT `id` FROM `stock` WHERE `id` <> 64575918 AND `partno` = '5180CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13344812 [ RunTime:0.000558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61146934 LIMIT 5 [ RunTime:0.000521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61146934 ORDER BY `minOrder` ASC [ RunTime:0.003455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61146934 ORDER BY `unit` DESC [ RunTime:0.004190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61146934 LIMIT 2 [ RunTime:0.004089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61146934 ORDER BY `minOrder` ASC [ RunTime:0.007922s ]
select * from pdf where partno='5180-3PG-3DC' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.001290s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180-3PG-3DC' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.011392s ]
SELECT `id` FROM `stock` WHERE `id` <> 61146934 AND `partno` = '5180-3PG-3DC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.016982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10854909 [ RunTime:0.005369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61151523 LIMIT 5 [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61151523 ORDER BY `minOrder` ASC [ RunTime:0.006653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61151523 ORDER BY `unit` DESC [ RunTime:0.000481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61151523 LIMIT 2 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61151523 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
select * from pdf where partno='5180-3SG-530' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.000461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180-3SG-530' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.002589s ]
SELECT `id` FROM `stock` WHERE `id` <> 61151523 AND `partno` = '5180-3SG-530' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.000582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10898928 [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61146889 LIMIT 5 [ RunTime:0.002455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61146889 ORDER BY `minOrder` ASC [ RunTime:0.004971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61146889 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61146889 LIMIT 2 [ RunTime:0.000686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61146889 ORDER BY `minOrder` ASC [ RunTime:0.000489s ]
select * from pdf where partno='5180-3PG-515' and brandshort='Conxall/Switchcraft' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180-3PG-515' OR `brand` LIKE 'Conxall/Switchcraft%' ) ) LIMIT 1 [ RunTime:0.005293s ]
SELECT `id` FROM `stock` WHERE `id` <> 61146889 AND `partno` = '5180-3PG-515' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conxall/switchcraft%' ) [ RunTime:0.003294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58513415 LIMIT 5 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513415 ORDER BY `minOrder` ASC [ RunTime:0.005910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58513415 ORDER BY `unit` DESC [ RunTime:0.023038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58513415 LIMIT 2 [ RunTime:0.008980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58513415 ORDER BY `minOrder` ASC [ RunTime:0.004127s ]
select * from pdf where partno='5180' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.006889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.005341s ]
SELECT `id` FROM `stock` WHERE `id` <> 58513415 AND `partno` = '5180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.013881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11190509 [ RunTime:0.003250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514459 LIMIT 5 [ RunTime:0.007454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514459 ORDER BY `minOrder` ASC [ RunTime:0.016234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514459 ORDER BY `unit` DESC [ RunTime:0.009767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514459 LIMIT 2 [ RunTime:0.004752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514459 ORDER BY `minOrder` ASC [ RunTime:0.008855s ]
select * from pdf where partno='5180P-9' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-9' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005023s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514459 AND `partno` = '5180P-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524819 [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514457 LIMIT 5 [ RunTime:0.007164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514457 ORDER BY `minOrder` ASC [ RunTime:0.007618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514457 ORDER BY `unit` DESC [ RunTime:0.000577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514457 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514457 ORDER BY `minOrder` ASC [ RunTime:0.004877s ]
select * from pdf where partno='5180P-O' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-O' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016654s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514457 AND `partno` = '5180P-O' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524817 [ RunTime:0.005475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514453 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514453 ORDER BY `minOrder` ASC [ RunTime:0.008552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514453 ORDER BY `unit` DESC [ RunTime:0.002188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514453 LIMIT 2 [ RunTime:0.003289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514453 ORDER BY `minOrder` ASC [ RunTime:0.007403s ]
select * from pdf where partno='5180P-8' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-8' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008014s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514453 AND `partno` = '5180P-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524815 [ RunTime:0.006878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514448 LIMIT 5 [ RunTime:0.000695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514448 ORDER BY `minOrder` ASC [ RunTime:0.008112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514448 ORDER BY `unit` DESC [ RunTime:0.014933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514448 LIMIT 2 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514448 ORDER BY `minOrder` ASC [ RunTime:0.002044s ]
select * from pdf where partno='5180P-K' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000936s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-K' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002868s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514448 AND `partno` = '5180P-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524812 [ RunTime:0.019982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514447 LIMIT 5 [ RunTime:0.015587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514447 ORDER BY `minOrder` ASC [ RunTime:0.007775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514447 ORDER BY `unit` DESC [ RunTime:0.018362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514447 LIMIT 2 [ RunTime:0.005649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514447 ORDER BY `minOrder` ASC [ RunTime:0.009641s ]
select * from pdf where partno='5180P-V' and brandshort='Brady Corporation' limit 1 [ RunTime:0.006941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-V' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021813s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514447 AND `partno` = '5180P-V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395936 [ RunTime:0.016057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514446 LIMIT 5 [ RunTime:0.021237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514446 ORDER BY `minOrder` ASC [ RunTime:0.017573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514446 ORDER BY `unit` DESC [ RunTime:0.015819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514446 LIMIT 2 [ RunTime:0.001382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514446 ORDER BY `minOrder` ASC [ RunTime:0.003046s ]
select * from pdf where partno='5180P-0' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-0' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000917s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514446 AND `partno` = '5180P-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395935 [ RunTime:0.021735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514445 LIMIT 5 [ RunTime:0.004750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514445 ORDER BY `minOrder` ASC [ RunTime:0.040577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514445 ORDER BY `unit` DESC [ RunTime:0.063650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514445 LIMIT 2 [ RunTime:0.013981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514445 ORDER BY `minOrder` ASC [ RunTime:0.003218s ]
select * from pdf where partno='5180P-N' and brandshort='Brady Corporation' limit 1 [ RunTime:0.047827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-N' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.022511s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514445 AND `partno` = '5180P-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395934 [ RunTime:0.020796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514443 LIMIT 5 [ RunTime:0.069999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514443 ORDER BY `minOrder` ASC [ RunTime:0.056596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514443 ORDER BY `unit` DESC [ RunTime:0.054111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514443 LIMIT 2 [ RunTime:0.023446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514443 ORDER BY `minOrder` ASC [ RunTime:0.036389s ]
select * from pdf where partno='5180P-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.058061s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.119749s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514443 AND `partno` = '5180P-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.023177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524811 [ RunTime:0.020765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514442 LIMIT 5 [ RunTime:0.042080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514442 ORDER BY `minOrder` ASC [ RunTime:0.090506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514442 ORDER BY `unit` DESC [ RunTime:0.034057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514442 LIMIT 2 [ RunTime:0.056735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514442 ORDER BY `minOrder` ASC [ RunTime:0.002829s ]
select * from pdf where partno='5180P-6' and brandshort='Brady Corporation' limit 1 [ RunTime:0.025228s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-6' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.025410s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514442 AND `partno` = '5180P-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.044973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524810 [ RunTime:0.035473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514441 LIMIT 5 [ RunTime:0.010911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514441 ORDER BY `minOrder` ASC [ RunTime:0.043272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514441 ORDER BY `unit` DESC [ RunTime:0.037481s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514441 LIMIT 2 [ RunTime:0.067561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514441 ORDER BY `minOrder` ASC [ RunTime:0.015435s ]
select * from pdf where partno='5180P-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.034002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.041878s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514441 AND `partno` = '5180P-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.039180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524809 [ RunTime:0.018391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514439 LIMIT 5 [ RunTime:0.058109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514439 ORDER BY `minOrder` ASC [ RunTime:0.013485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514439 ORDER BY `unit` DESC [ RunTime:0.015058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514439 LIMIT 2 [ RunTime:0.029407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514439 ORDER BY `minOrder` ASC [ RunTime:0.008252s ]
select * from pdf where partno='5180P-X' and brandshort='Brady Corporation' limit 1 [ RunTime:0.027986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-X' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005569s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514439 AND `partno` = '5180P-X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524807 [ RunTime:0.004586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514436 LIMIT 5 [ RunTime:0.013325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514436 ORDER BY `minOrder` ASC [ RunTime:0.020741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514436 ORDER BY `unit` DESC [ RunTime:0.002038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514436 LIMIT 2 [ RunTime:0.028509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514436 ORDER BY `minOrder` ASC [ RunTime:0.003633s ]
select * from pdf where partno='5180P-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012836s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514436 AND `partno` = '5180P-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.003696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524804 [ RunTime:0.006210s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013709s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009180s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012316s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011689s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008009s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004525s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008686s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180%' OR `brand` LIKE '5180%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003463s ]