SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004432s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.111' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=BD07&search=1' [ RunTime:0.002141s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002768s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000642s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002631s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.111' ) [ RunTime:0.000657s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002971s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001421s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BD07' LIMIT 1 [ RunTime:0.002072s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-13 17:34:18' WHERE `partno` = 'BD07' [ RunTime:0.001601s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001367s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009132s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571086 LIMIT 5 [ RunTime:0.001140s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571086 ORDER BY `minOrder` ASC [ RunTime:0.005987s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19571086 ORDER BY `unit` DESC [ RunTime:0.007937s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19571086 LIMIT 2 [ RunTime:0.009225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19571086 ORDER BY `minOrder` ASC [ RunTime:0.008767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569389 LIMIT 5 [ RunTime:0.008920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569389 ORDER BY `minOrder` ASC [ RunTime:0.015429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19569389 ORDER BY `unit` DESC [ RunTime:0.001014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19569389 LIMIT 2 [ RunTime:0.000743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19569389 ORDER BY `minOrder` ASC [ RunTime:0.000676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955497 LIMIT 5 [ RunTime:0.007649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955497 ORDER BY `minOrder` ASC [ RunTime:0.002368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18955497 ORDER BY `unit` DESC [ RunTime:0.023173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18955497 LIMIT 2 [ RunTime:0.002311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955497 ORDER BY `minOrder` ASC [ RunTime:0.007145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955768 LIMIT 5 [ RunTime:0.001251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955768 ORDER BY `minOrder` ASC [ RunTime:0.020741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18955768 ORDER BY `unit` DESC [ RunTime:0.001513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18955768 LIMIT 2 [ RunTime:0.010557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955768 ORDER BY `minOrder` ASC [ RunTime:0.004793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684087 LIMIT 5 [ RunTime:0.008947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684087 ORDER BY `minOrder` ASC [ RunTime:0.006037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684087 ORDER BY `unit` DESC [ RunTime:0.006963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684087 LIMIT 2 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684087 ORDER BY `minOrder` ASC [ RunTime:0.008427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683425 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683425 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683425 ORDER BY `unit` DESC [ RunTime:0.002106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683425 LIMIT 2 [ RunTime:0.008260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683425 ORDER BY `minOrder` ASC [ RunTime:0.005831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683027 LIMIT 5 [ RunTime:0.004948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683027 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683027 ORDER BY `unit` DESC [ RunTime:0.001798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683027 LIMIT 2 [ RunTime:0.002828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683027 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12682656 LIMIT 5 [ RunTime:0.005701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12682656 ORDER BY `minOrder` ASC [ RunTime:0.002838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12682656 ORDER BY `unit` DESC [ RunTime:0.016893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12682656 LIMIT 2 [ RunTime:0.006389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12682656 ORDER BY `minOrder` ASC [ RunTime:0.007176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680731 LIMIT 5 [ RunTime:0.013495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680731 ORDER BY `minOrder` ASC [ RunTime:0.004615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680731 ORDER BY `unit` DESC [ RunTime:0.012888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680731 LIMIT 2 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680731 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12680271 LIMIT 5 [ RunTime:0.016256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680271 ORDER BY `minOrder` ASC [ RunTime:0.011151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12680271 ORDER BY `unit` DESC [ RunTime:0.028709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12680271 LIMIT 2 [ RunTime:0.005918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12680271 ORDER BY `minOrder` ASC [ RunTime:0.006234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679820 LIMIT 5 [ RunTime:0.003102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679820 ORDER BY `minOrder` ASC [ RunTime:0.018043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679820 ORDER BY `unit` DESC [ RunTime:0.007201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679820 LIMIT 2 [ RunTime:0.002894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679820 ORDER BY `minOrder` ASC [ RunTime:0.009987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679397 LIMIT 5 [ RunTime:0.007306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679397 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679397 ORDER BY `unit` DESC [ RunTime:0.011007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679397 LIMIT 2 [ RunTime:0.009813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679397 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678915 LIMIT 5 [ RunTime:0.002968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678915 ORDER BY `minOrder` ASC [ RunTime:0.010507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12678915 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12678915 LIMIT 2 [ RunTime:0.002093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678915 ORDER BY `minOrder` ASC [ RunTime:0.005625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12678536 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678536 ORDER BY `minOrder` ASC [ RunTime:0.003443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12678536 ORDER BY `unit` DESC [ RunTime:0.000533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12678536 LIMIT 2 [ RunTime:0.002447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12678536 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12677452 LIMIT 5 [ RunTime:0.002089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677452 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12677452 ORDER BY `unit` DESC [ RunTime:0.001665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12677452 LIMIT 2 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677452 ORDER BY `minOrder` ASC [ RunTime:0.004838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12677060 LIMIT 5 [ RunTime:0.001028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677060 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12677060 ORDER BY `unit` DESC [ RunTime:0.003432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12677060 LIMIT 2 [ RunTime:0.001754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12677060 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674784 LIMIT 5 [ RunTime:0.001959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674784 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12674784 ORDER BY `unit` DESC [ RunTime:0.001420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12674784 LIMIT 2 [ RunTime:0.002253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674784 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12673739 LIMIT 5 [ RunTime:0.001733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673739 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12673739 ORDER BY `unit` DESC [ RunTime:0.001674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12673739 LIMIT 2 [ RunTime:0.013976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673739 ORDER BY `minOrder` ASC [ RunTime:0.006494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672897 LIMIT 5 [ RunTime:0.001471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672897 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12672897 ORDER BY `unit` DESC [ RunTime:0.000539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12672897 LIMIT 2 [ RunTime:0.002017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672897 ORDER BY `minOrder` ASC [ RunTime:0.007072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672679 LIMIT 5 [ RunTime:0.003692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672679 ORDER BY `minOrder` ASC [ RunTime:0.006356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12672679 ORDER BY `unit` DESC [ RunTime:0.003116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12672679 LIMIT 2 [ RunTime:0.011339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672679 ORDER BY `minOrder` ASC [ RunTime:0.007043s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269496 LIMIT 5 [ RunTime:0.001242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269496 ORDER BY `minOrder` ASC [ RunTime:0.008177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269496 ORDER BY `unit` DESC [ RunTime:0.002383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269496 LIMIT 2 [ RunTime:0.002073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269496 ORDER BY `minOrder` ASC [ RunTime:0.004390s ]
select * from pdf where partno='bd075-04-a-1-l-d' and brandshort='gct' limit 1 [ RunTime:0.004236s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bd075-04-a-1-l-d' OR `brand` LIKE 'gct%' ) ) LIMIT 1 [ RunTime:0.008616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309749 LIMIT 5 [ RunTime:0.006934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309749 ORDER BY `minOrder` ASC [ RunTime:0.001601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309749 ORDER BY `unit` DESC [ RunTime:0.003576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309749 LIMIT 2 [ RunTime:0.001570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309749 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
select * from pdf where partno='bd070lic3' and brandshort='ezurio' limit 1 [ RunTime:0.003289s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bd070lic3' OR `brand` LIKE 'ezurio%' ) ) LIMIT 1 [ RunTime:0.005831s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309749 AND `partno` = 'bd070lic3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ezurio%' ) [ RunTime:0.006060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955497 [ RunTime:0.005009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237432 LIMIT 5 [ RunTime:0.005951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237432 ORDER BY `minOrder` ASC [ RunTime:0.007408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237432 ORDER BY `unit` DESC [ RunTime:0.013331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237432 LIMIT 2 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237432 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='bd070lic3' and brandshort='ezurio' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bd070lic3' OR `brand` LIKE 'ezurio%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT `id` FROM `stock` WHERE `id` <> 32237432 AND `partno` = 'bd070lic3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ezurio%' ) [ RunTime:0.000898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955497 [ RunTime:0.008037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309637 LIMIT 5 [ RunTime:0.006483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309637 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309637 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309637 LIMIT 2 [ RunTime:0.001392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309637 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='bd070lic3_mipi' and brandshort='ezurio' limit 1 [ RunTime:0.000943s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bd070lic3_mipi' OR `brand` LIKE 'ezurio%' ) ) LIMIT 1 [ RunTime:0.000793s ]
SELECT `id` FROM `stock` WHERE `id` <> 32309637 AND `partno` = 'bd070lic3_mipi' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ezurio%' ) [ RunTime:0.003867s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955768 [ RunTime:0.001433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32236591 LIMIT 5 [ RunTime:0.001713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236591 ORDER BY `minOrder` ASC [ RunTime:0.002401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32236591 ORDER BY `unit` DESC [ RunTime:0.000617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32236591 LIMIT 2 [ RunTime:0.007725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32236591 ORDER BY `minOrder` ASC [ RunTime:0.005803s ]
select * from pdf where partno='bd070lic3_mipi' and brandshort='ezurio' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'bd070lic3_mipi' OR `brand` LIKE 'ezurio%' ) ) LIMIT 1 [ RunTime:0.001210s ]
SELECT `id` FROM `stock` WHERE `id` <> 32236591 AND `partno` = 'bd070lic3_mipi' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ezurio%' ) [ RunTime:0.003354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955768 [ RunTime:0.015881s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58357932 LIMIT 5 [ RunTime:0.002921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58357932 ORDER BY `minOrder` ASC [ RunTime:0.002712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58357932 ORDER BY `unit` DESC [ RunTime:0.004931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58357932 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58357932 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
select * from pdf where partno='BD07' and brandshort='C&K' limit 1 [ RunTime:0.005565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD07' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.011654s ]
SELECT `id` FROM `stock` WHERE `id` <> 58357932 AND `partno` = 'BD07' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.000893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19569389 [ RunTime:0.007091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58358518 LIMIT 5 [ RunTime:0.004713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58358518 ORDER BY `minOrder` ASC [ RunTime:0.001454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58358518 ORDER BY `unit` DESC [ RunTime:0.002677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58358518 LIMIT 2 [ RunTime:0.003300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58358518 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
select * from pdf where partno='BD07AV' and brandshort='C&K' limit 1 [ RunTime:0.007931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD07AV' OR `brand` LIKE 'C&K%' ) ) LIMIT 1 [ RunTime:0.023544s ]
SELECT `id` FROM `stock` WHERE `id` <> 58358518 AND `partno` = 'BD07AV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%c&k%' ) [ RunTime:0.003991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19571086 [ RunTime:0.003748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133882 LIMIT 5 [ RunTime:0.001488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133882 ORDER BY `minOrder` ASC [ RunTime:0.003881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133882 ORDER BY `unit` DESC [ RunTime:0.005142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133882 LIMIT 2 [ RunTime:0.002746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133882 ORDER BY `minOrder` ASC [ RunTime:0.004844s ]
select * from pdf where partno='BD070LIC3' and brandshort='Ezurio' limit 1 [ RunTime:0.000850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD070LIC3' OR `brand` LIKE 'Ezurio%' ) ) LIMIT 1 [ RunTime:0.000723s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133882 AND `partno` = 'BD070LIC3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ezurio%' ) [ RunTime:0.002853s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955497 [ RunTime:0.004244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59812548 LIMIT 5 [ RunTime:0.006548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59812548 ORDER BY `minOrder` ASC [ RunTime:0.001449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59812548 ORDER BY `unit` DESC [ RunTime:0.002752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59812548 LIMIT 2 [ RunTime:0.006970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59812548 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='BD075-40-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.004202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-40-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.004108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59811702 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811702 ORDER BY `minOrder` ASC [ RunTime:0.006396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59811702 ORDER BY `unit` DESC [ RunTime:0.002356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59811702 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811702 ORDER BY `minOrder` ASC [ RunTime:0.000545s ]
select * from pdf where partno='BD075-39-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.001027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-39-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.004043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59810831 LIMIT 5 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59810831 ORDER BY `minOrder` ASC [ RunTime:0.007919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59810831 ORDER BY `unit` DESC [ RunTime:0.007440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59810831 LIMIT 2 [ RunTime:0.018072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59810831 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='BD075-38-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.006654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-38-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.007896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59810041 LIMIT 5 [ RunTime:0.009300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59810041 ORDER BY `minOrder` ASC [ RunTime:0.011441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59810041 ORDER BY `unit` DESC [ RunTime:0.003568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59810041 LIMIT 2 [ RunTime:0.002627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59810041 ORDER BY `minOrder` ASC [ RunTime:0.001103s ]
select * from pdf where partno='BD075-37-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.007599s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-37-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.001823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59809106 LIMIT 5 [ RunTime:0.003503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59809106 ORDER BY `minOrder` ASC [ RunTime:0.005822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59809106 ORDER BY `unit` DESC [ RunTime:0.002742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59809106 LIMIT 2 [ RunTime:0.006912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59809106 ORDER BY `minOrder` ASC [ RunTime:0.006805s ]
select * from pdf where partno='BD075-36-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.001079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-36-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.003071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59808319 LIMIT 5 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808319 ORDER BY `minOrder` ASC [ RunTime:0.002710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59808319 ORDER BY `unit` DESC [ RunTime:0.002837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59808319 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59808319 ORDER BY `minOrder` ASC [ RunTime:0.000308s ]
select * from pdf where partno='BD075-35-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.007546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-35-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.000671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59807560 LIMIT 5 [ RunTime:0.001990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59807560 ORDER BY `minOrder` ASC [ RunTime:0.004112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59807560 ORDER BY `unit` DESC [ RunTime:0.001663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59807560 LIMIT 2 [ RunTime:0.003589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59807560 ORDER BY `minOrder` ASC [ RunTime:0.009816s ]
select * from pdf where partno='BD075-34-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.008313s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-34-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.004733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59806787 LIMIT 5 [ RunTime:0.008399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806787 ORDER BY `minOrder` ASC [ RunTime:0.005866s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59806787 ORDER BY `unit` DESC [ RunTime:0.004062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59806787 LIMIT 2 [ RunTime:0.000449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806787 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='BD075-33-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.000730s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-33-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.003251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59806000 LIMIT 5 [ RunTime:0.000749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806000 ORDER BY `minOrder` ASC [ RunTime:0.004918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59806000 ORDER BY `unit` DESC [ RunTime:0.002165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59806000 LIMIT 2 [ RunTime:0.007511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59806000 ORDER BY `minOrder` ASC [ RunTime:0.003801s ]
select * from pdf where partno='BD075-32-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.002443s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-32-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.002537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59805194 LIMIT 5 [ RunTime:0.001317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59805194 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59805194 ORDER BY `unit` DESC [ RunTime:0.001743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59805194 LIMIT 2 [ RunTime:0.004937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59805194 ORDER BY `minOrder` ASC [ RunTime:0.004475s ]
select * from pdf where partno='BD075-31-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.000979s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-31-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.021995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59804399 LIMIT 5 [ RunTime:0.002113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804399 ORDER BY `minOrder` ASC [ RunTime:0.017577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59804399 ORDER BY `unit` DESC [ RunTime:0.001916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59804399 LIMIT 2 [ RunTime:0.001830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59804399 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
select * from pdf where partno='BD075-30-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.004205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-30-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.000826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59803589 LIMIT 5 [ RunTime:0.003976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59803589 ORDER BY `minOrder` ASC [ RunTime:0.006418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59803589 ORDER BY `unit` DESC [ RunTime:0.000725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59803589 LIMIT 2 [ RunTime:0.004152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59803589 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
select * from pdf where partno='BD075-29-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.001171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-29-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.002074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59802900 LIMIT 5 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802900 ORDER BY `minOrder` ASC [ RunTime:0.008000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59802900 ORDER BY `unit` DESC [ RunTime:0.003723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59802900 LIMIT 2 [ RunTime:0.008392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802900 ORDER BY `minOrder` ASC [ RunTime:0.001230s ]
select * from pdf where partno='BD075-28-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.004340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-28-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.004614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59802091 LIMIT 5 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802091 ORDER BY `minOrder` ASC [ RunTime:0.001017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59802091 ORDER BY `unit` DESC [ RunTime:0.002797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59802091 LIMIT 2 [ RunTime:0.003842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59802091 ORDER BY `minOrder` ASC [ RunTime:0.002156s ]
select * from pdf where partno='BD075-27-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.002940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-27-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.003555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59801273 LIMIT 5 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801273 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59801273 ORDER BY `unit` DESC [ RunTime:0.005601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59801273 LIMIT 2 [ RunTime:0.004970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59801273 ORDER BY `minOrder` ASC [ RunTime:0.003922s ]
select * from pdf where partno='BD075-26-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.009254s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-26-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.004483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59800497 LIMIT 5 [ RunTime:0.003361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800497 ORDER BY `minOrder` ASC [ RunTime:0.008217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59800497 ORDER BY `unit` DESC [ RunTime:0.010091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59800497 LIMIT 2 [ RunTime:0.005997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59800497 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
select * from pdf where partno='BD075-25-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.014923s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-25-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.002680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59799693 LIMIT 5 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799693 ORDER BY `minOrder` ASC [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59799693 ORDER BY `unit` DESC [ RunTime:0.003925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59799693 LIMIT 2 [ RunTime:0.000819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59799693 ORDER BY `minOrder` ASC [ RunTime:0.002000s ]
select * from pdf where partno='BD075-24-A-1-L-D' and brandshort='GCT' limit 1 [ RunTime:0.011431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BD075-24-A-1-L-D' OR `brand` LIKE 'GCT%' ) ) LIMIT 1 [ RunTime:0.000957s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012212s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002227s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008579s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010541s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013012s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002032s ]
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 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007877s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BD07%' OR `brand` LIKE 'BD07%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007004s ]