SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002401s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.94' , `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=3146&search=1' [ RunTime:0.002174s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003039s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003211s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003475s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.94' ) [ RunTime:0.000707s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002331s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001305s ]
SELECT * FROM `stock_search` WHERE `partno` = '3146' LIMIT 1 [ RunTime:0.000630s ]
UPDATE `stock_search` SET `count` = 10 , `updatetime` = '2026-11-04 23:53:54' WHERE `partno` = '3146' [ RunTime:0.001511s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001254s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006285s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067458 LIMIT 5 [ RunTime:0.000872s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067458 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12067458 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12067458 LIMIT 2 [ RunTime:0.000324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12067458 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593901 LIMIT 5 [ RunTime:0.001081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593901 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593901 ORDER BY `unit` DESC [ RunTime:0.000402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593901 LIMIT 2 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593901 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='3146-2-00-80-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001029s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16397938 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16397938 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16397938 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16397938 LIMIT 2 [ RunTime:0.000307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16397938 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591717 LIMIT 5 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591717 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591717 ORDER BY `unit` DESC [ RunTime:0.000303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591717 LIMIT 2 [ RunTime:0.000795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591717 ORDER BY `minOrder` ASC [ RunTime:0.000630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13272428 LIMIT 5 [ RunTime:0.001103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13272428 ORDER BY `minOrder` ASC [ RunTime:0.000483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13272428 ORDER BY `unit` DESC [ RunTime:0.000486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13272428 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13272428 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700804 LIMIT 5 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700804 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700804 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700804 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700804 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171978 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171978 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171978 ORDER BY `unit` DESC [ RunTime:0.000446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171978 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171978 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186680 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186680 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186680 ORDER BY `unit` DESC [ RunTime:0.000454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186680 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186680 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081385 LIMIT 5 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081385 ORDER BY `minOrder` ASC [ RunTime:0.000492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20081385 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20081385 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081385 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765743 LIMIT 5 [ RunTime:0.000866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765743 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18765743 ORDER BY `unit` DESC [ RunTime:0.000446s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18765743 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765743 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18765660 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765660 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18765660 ORDER BY `unit` DESC [ RunTime:0.000445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18765660 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18765660 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753543 LIMIT 5 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753543 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753543 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753543 LIMIT 2 [ RunTime:0.000422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753543 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18744004 LIMIT 5 [ RunTime:0.000753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744004 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18744004 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18744004 LIMIT 2 [ RunTime:0.000425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18744004 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18738030 LIMIT 5 [ RunTime:0.000741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18738030 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18738030 ORDER BY `unit` DESC [ RunTime:0.000462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18738030 LIMIT 2 [ RunTime:0.000430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18738030 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18738029 LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18738029 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18738029 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18738029 LIMIT 2 [ RunTime:0.000419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18738029 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18701298 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701298 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18701298 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18701298 LIMIT 2 [ RunTime:0.000426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18701298 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300132 LIMIT 5 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300132 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300132 ORDER BY `unit` DESC [ RunTime:0.000437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300132 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300132 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997063 LIMIT 5 [ RunTime:0.000865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997063 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997063 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997063 LIMIT 2 [ RunTime:0.000424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997063 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16148104 LIMIT 5 [ RunTime:0.001015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148104 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16148104 ORDER BY `unit` DESC [ RunTime:0.000409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16148104 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16148104 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15442662 LIMIT 5 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442662 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15442662 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15442662 LIMIT 2 [ RunTime:0.000372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15442662 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='3146-2-00-01-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001332s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71665209 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71665209 ORDER BY `minOrder` ASC [ RunTime:0.002905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71665209 ORDER BY `unit` DESC [ RunTime:0.000471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71665209 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71665209 ORDER BY `minOrder` ASC [ RunTime:0.000475s ]
select * from pdf where partno='3146' and brandshort='adafruit' limit 1 [ RunTime:0.000860s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51075758 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51075758 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51075758 ORDER BY `unit` DESC [ RunTime:0.000382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51075758 LIMIT 2 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51075758 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='3146460000' and brandshort='weidmuller' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146460000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 51075758 AND `partno` = '3146460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71384374 [ RunTime:0.000363s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67123183 LIMIT 5 [ RunTime:0.000257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67123183 ORDER BY `minOrder` ASC [ RunTime:0.000627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67123183 ORDER BY `unit` DESC [ RunTime:0.000218s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67123183 LIMIT 2 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67123183 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='3146-2-00-80-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146-2-00-80-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 67123183 AND `partno` = '3146-2-00-80-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593901 [ RunTime:0.000293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65127390 LIMIT 5 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65127390 ORDER BY `minOrder` ASC [ RunTime:0.000561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65127390 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65127390 LIMIT 2 [ RunTime:0.000201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65127390 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='3146' and brandshort='Pololu' limit 1 [ RunTime:0.000303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.000657s ]
SELECT `id` FROM `stock` WHERE `id` <> 65127390 AND `partno` = '3146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16397938 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71325061 LIMIT 5 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71325061 ORDER BY `minOrder` ASC [ RunTime:0.000568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71325061 ORDER BY `unit` DESC [ RunTime:0.000212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71325061 LIMIT 2 [ RunTime:0.000241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71325061 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='3146CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.000332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.000322s ]
SELECT `id` FROM `stock` WHERE `id` <> 71325061 AND `partno` = '3146CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.000357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12067458 [ RunTime:0.000278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70313104 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70313104 ORDER BY `minOrder` ASC [ RunTime:0.000594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70313104 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70313104 LIMIT 2 [ RunTime:0.000201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70313104 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='3146' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000419s ]
SELECT `id` FROM `stock` WHERE `id` <> 70313104 AND `partno` = '3146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13272428 [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71384374 LIMIT 5 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384374 ORDER BY `minOrder` ASC [ RunTime:0.000616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71384374 ORDER BY `unit` DESC [ RunTime:0.000253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71384374 LIMIT 2 [ RunTime:0.000243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384374 ORDER BY `minOrder` ASC [ RunTime:0.000271s ]
select * from pdf where partno='3146460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000535s ]
SELECT `id` FROM `stock` WHERE `id` <> 71384374 AND `partno` = '3146460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51075758 [ RunTime:0.000207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71384365 LIMIT 5 [ RunTime:0.000229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384365 ORDER BY `minOrder` ASC [ RunTime:0.000232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71384365 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71384365 LIMIT 2 [ RunTime:0.000195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384365 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='3146450000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146450000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000513s ]
SELECT `id` FROM `stock` WHERE `id` <> 71384365 AND `partno` = '3146450000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67123304 LIMIT 5 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67123304 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67123304 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67123304 LIMIT 2 [ RunTime:0.000197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67123304 ORDER BY `minOrder` ASC [ RunTime:0.000244s ]
select * from pdf where partno='3146-2-00-21-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146-2-00-21-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000266s ]
SELECT `id` FROM `stock` WHERE `id` <> 67123304 AND `partno` = '3146-2-00-21-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591717 [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65330450 LIMIT 5 [ RunTime:0.000219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330450 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65330450 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65330450 LIMIT 2 [ RunTime:0.000200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65330450 ORDER BY `minOrder` ASC [ RunTime:0.000222s ]
select * from pdf where partno='31460' and brandshort='Wiha' limit 1 [ RunTime:0.000416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31460' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000370s ]
SELECT `id` FROM `stock` WHERE `id` <> 65330450 AND `partno` = '31460' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186680 [ RunTime:0.000230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71384387 LIMIT 5 [ RunTime:0.000205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384387 ORDER BY `minOrder` ASC [ RunTime:0.000241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71384387 ORDER BY `unit` DESC [ RunTime:0.000205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71384387 LIMIT 2 [ RunTime:0.000198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71384387 ORDER BY `minOrder` ASC [ RunTime:0.000233s ]
select * from pdf where partno='3146470000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146470000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000528s ]
SELECT `id` FROM `stock` WHERE `id` <> 71384387 AND `partno` = '3146470000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65399705 LIMIT 5 [ RunTime:0.000204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65399705 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65399705 ORDER BY `unit` DESC [ RunTime:0.000205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65399705 LIMIT 2 [ RunTime:0.000197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65399705 ORDER BY `minOrder` ASC [ RunTime:0.000230s ]
select * from pdf where partno='3146A' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146A' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000369s ]
SELECT `id` FROM `stock` WHERE `id` <> 65399705 AND `partno` = '3146A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.000287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171978 [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65399704 LIMIT 5 [ RunTime:0.000207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65399704 ORDER BY `minOrder` ASC [ RunTime:0.000231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65399704 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65399704 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65399704 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='3146B' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.000336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146B' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.000308s ]
SELECT `id` FROM `stock` WHERE `id` <> 65399704 AND `partno` = '3146B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700804 [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71297455 LIMIT 5 [ RunTime:0.000203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297455 ORDER BY `minOrder` ASC [ RunTime:0.000575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71297455 ORDER BY `unit` DESC [ RunTime:0.000206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71297455 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71297455 ORDER BY `minOrder` ASC [ RunTime:0.000218s ]
select * from pdf where partno='31467LS-A' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31467LS-A' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000524s ]
SELECT `id` FROM `stock` WHERE `id` <> 71297455 AND `partno` = '31467LS-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551454 [ RunTime:0.000587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71280500 LIMIT 5 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71280500 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71280500 ORDER BY `unit` DESC [ RunTime:0.000205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71280500 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71280500 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
select * from pdf where partno='31467LS' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31467LS' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000295s ]
SELECT `id` FROM `stock` WHERE `id` <> 71280500 AND `partno` = '31467LS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14396754 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 71205996 LIMIT 5 [ RunTime:0.000212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71205996 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 71205996 ORDER BY `unit` DESC [ RunTime:0.000208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 71205996 LIMIT 2 [ RunTime:0.000208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 71205996 ORDER BY `minOrder` ASC [ RunTime:0.000217s ]
select * from pdf where partno='3146B' and brandshort='3M' limit 1 [ RunTime:0.000279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146B' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001120s ]
SELECT `id` FROM `stock` WHERE `id` <> 71205996 AND `partno` = '3146B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.000290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997063 [ RunTime:0.000221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70959285 LIMIT 5 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70959285 ORDER BY `minOrder` ASC [ RunTime:0.000760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70959285 ORDER BY `unit` DESC [ RunTime:0.000248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70959285 LIMIT 2 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70959285 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='3146.000.00' and brandshort='FEIG Electronic' limit 1 [ RunTime:0.000339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146.000.00' OR `brand` LIKE 'FEIG Electronic%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT `id` FROM `stock` WHERE `id` <> 70959285 AND `partno` = '3146.000.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%feig electronic%' ) [ RunTime:0.000344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13267936 [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70959284 LIMIT 5 [ RunTime:0.000241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70959284 ORDER BY `minOrder` ASC [ RunTime:0.000273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70959284 ORDER BY `unit` DESC [ RunTime:0.000269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70959284 LIMIT 2 [ RunTime:0.000199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70959284 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
select * from pdf where partno='3146.000.00.00' and brandshort='FEIG Electronic' limit 1 [ RunTime:0.000281s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146.000.00.00' OR `brand` LIKE 'FEIG Electronic%' ) ) LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70144684 LIMIT 5 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70144684 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70144684 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70144684 LIMIT 2 [ RunTime:0.000244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70144684 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='3146' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000414s ]
SELECT `id` FROM `stock` WHERE `id` <> 70144684 AND `partno` = '3146' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13320741 [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70072196 LIMIT 5 [ RunTime:0.000250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70072196 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70072196 ORDER BY `unit` DESC [ RunTime:0.000209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70072196 LIMIT 2 [ RunTime:0.000196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70072196 ORDER BY `minOrder` ASC [ RunTime:0.000235s ]
select * from pdf where partno='3146-100K' and brandshort='Honeywell Sensing and Productivity Solutions T&M' limit 1 [ RunTime:0.000282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146-100K' OR `brand` LIKE 'Honeywell Sensing and Productivity Solutions T&M%' ) ) LIMIT 1 [ RunTime:0.000271s ]
SELECT `id` FROM `stock` WHERE `id` <> 70072196 AND `partno` = '3146-100K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%honeywell sensing and productivity solutions t&m%' ) [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081385 [ RunTime:0.000229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67435441 LIMIT 5 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67435441 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67435441 ORDER BY `unit` DESC [ RunTime:0.000207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67435441 LIMIT 2 [ RunTime:0.000194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67435441 ORDER BY `minOrder` ASC [ RunTime:0.000220s ]
select * from pdf where partno='3146.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.000272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000775s ]
SELECT `id` FROM `stock` WHERE `id` <> 67435441 AND `partno` = '3146.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67124966 LIMIT 5 [ RunTime:0.000335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67124966 ORDER BY `minOrder` ASC [ RunTime:0.000848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67124966 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67124966 LIMIT 2 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67124966 ORDER BY `minOrder` ASC [ RunTime:0.000264s ]
select * from pdf where partno='3146-2-00-34-00-00-08-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3146-2-00-34-00-00-08-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 67124966 AND `partno` = '3146-2-00-34-00-00-08-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300132 [ RunTime:0.000281s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000582s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000484s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000468s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000460s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000386s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000380s ]
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 '3146%' OR `brand` LIKE '3146%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000420s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3146%' OR `brand` LIKE '3146%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000598s ]