SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002706s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=11111&search=1' [ RunTime:0.003971s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001544s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000557s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002961s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002785s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002912s ]
SELECT * FROM `stock_search` WHERE `partno` = '11111' LIMIT 1 [ RunTime:0.001231s ]
UPDATE `stock_search` SET `count` = 14 , `updatetime` = '2026-08-05 04:56:10' WHERE `partno` = '11111' [ RunTime:0.012146s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003202s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010768s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471786 LIMIT 5 [ RunTime:0.007689s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471786 ORDER BY `minOrder` ASC [ RunTime:0.006338s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471786 ORDER BY `unit` DESC [ RunTime:0.002337s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471786 LIMIT 2 [ RunTime:0.005667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471786 ORDER BY `minOrder` ASC [ RunTime:0.004746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471795 LIMIT 5 [ RunTime:0.006302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471795 ORDER BY `minOrder` ASC [ RunTime:0.004344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471795 ORDER BY `unit` DESC [ RunTime:0.009459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471795 LIMIT 2 [ RunTime:0.009643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471795 ORDER BY `minOrder` ASC [ RunTime:0.003441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471783 LIMIT 5 [ RunTime:0.008951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471783 ORDER BY `minOrder` ASC [ RunTime:0.003972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471783 ORDER BY `unit` DESC [ RunTime:0.004212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471783 LIMIT 2 [ RunTime:0.008097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471783 ORDER BY `minOrder` ASC [ RunTime:0.004038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203018 LIMIT 5 [ RunTime:0.001804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203018 ORDER BY `minOrder` ASC [ RunTime:0.002999s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203018 ORDER BY `unit` DESC [ RunTime:0.000527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203018 LIMIT 2 [ RunTime:0.005047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203018 ORDER BY `minOrder` ASC [ RunTime:0.003088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200688 LIMIT 5 [ RunTime:0.000349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200688 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200688 ORDER BY `unit` DESC [ RunTime:0.000323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200688 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200688 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471787 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471787 ORDER BY `minOrder` ASC [ RunTime:0.003119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471787 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471787 LIMIT 2 [ RunTime:0.003181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471787 ORDER BY `minOrder` ASC [ RunTime:0.002038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471788 LIMIT 5 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471788 ORDER BY `minOrder` ASC [ RunTime:0.001873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13471788 ORDER BY `unit` DESC [ RunTime:0.000440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13471788 LIMIT 2 [ RunTime:0.002143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13471788 ORDER BY `minOrder` ASC [ RunTime:0.001289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022907 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022907 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19022907 ORDER BY `unit` DESC [ RunTime:0.000455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19022907 LIMIT 2 [ RunTime:0.002527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19022907 ORDER BY `minOrder` ASC [ RunTime:0.001489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13109009 LIMIT 5 [ RunTime:0.005417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109009 ORDER BY `minOrder` ASC [ RunTime:0.001909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13109009 ORDER BY `unit` DESC [ RunTime:0.005174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13109009 LIMIT 2 [ RunTime:0.002772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13109009 ORDER BY `minOrder` ASC [ RunTime:0.001557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11855225 LIMIT 5 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11855225 ORDER BY `minOrder` ASC [ RunTime:0.001727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11855225 ORDER BY `unit` DESC [ RunTime:0.000482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11855225 LIMIT 2 [ RunTime:0.002256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11855225 ORDER BY `minOrder` ASC [ RunTime:0.001607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18987778 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18987778 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18987778 ORDER BY `unit` DESC [ RunTime:0.000450s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18987778 LIMIT 2 [ RunTime:0.001911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18987778 ORDER BY `minOrder` ASC [ RunTime:0.001277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980686 LIMIT 5 [ RunTime:0.000975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980686 ORDER BY `minOrder` ASC [ RunTime:0.001423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18980686 ORDER BY `unit` DESC [ RunTime:0.000415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18980686 LIMIT 2 [ RunTime:0.001832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18980686 ORDER BY `minOrder` ASC [ RunTime:0.001285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975806 LIMIT 5 [ RunTime:0.004074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975806 ORDER BY `minOrder` ASC [ RunTime:0.004679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975806 ORDER BY `unit` DESC [ RunTime:0.000799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975806 LIMIT 2 [ RunTime:0.007236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975806 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975619 LIMIT 5 [ RunTime:0.001840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975619 ORDER BY `minOrder` ASC [ RunTime:0.009671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18975619 ORDER BY `unit` DESC [ RunTime:0.000381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18975619 LIMIT 2 [ RunTime:0.003604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18975619 ORDER BY `minOrder` ASC [ RunTime:0.002137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974519 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974519 ORDER BY `minOrder` ASC [ RunTime:0.002781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18974519 ORDER BY `unit` DESC [ RunTime:0.000372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18974519 LIMIT 2 [ RunTime:0.002860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18974519 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18783331 LIMIT 5 [ RunTime:0.000781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783331 ORDER BY `minOrder` ASC [ RunTime:0.002802s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18783331 ORDER BY `unit` DESC [ RunTime:0.000380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18783331 LIMIT 2 [ RunTime:0.007541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18783331 ORDER BY `minOrder` ASC [ RunTime:0.002929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778623 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778623 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778623 ORDER BY `unit` DESC [ RunTime:0.000369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778623 LIMIT 2 [ RunTime:0.002982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778623 ORDER BY `minOrder` ASC [ RunTime:0.001950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773902 LIMIT 5 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773902 ORDER BY `minOrder` ASC [ RunTime:0.002212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773902 ORDER BY `unit` DESC [ RunTime:0.000346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773902 LIMIT 2 [ RunTime:0.002290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773902 ORDER BY `minOrder` ASC [ RunTime:0.001614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18773001 LIMIT 5 [ RunTime:0.000619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773001 ORDER BY `minOrder` ASC [ RunTime:0.001845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18773001 ORDER BY `unit` DESC [ RunTime:0.002321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18773001 LIMIT 2 [ RunTime:0.002514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18773001 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17391600 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17391600 ORDER BY `minOrder` ASC [ RunTime:0.001395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17391600 ORDER BY `unit` DESC [ RunTime:0.000362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17391600 LIMIT 2 [ RunTime:0.002161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17391600 ORDER BY `minOrder` ASC [ RunTime:0.001465s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001185s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298226 LIMIT 5 [ RunTime:0.002611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298226 ORDER BY `minOrder` ASC [ RunTime:0.004956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298226 ORDER BY `unit` DESC [ RunTime:0.002020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298226 LIMIT 2 [ RunTime:0.002124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298226 ORDER BY `minOrder` ASC [ RunTime:0.005920s ]
select * from pdf where partno='1111175033' and brandshort='Portescap' limit 1 [ RunTime:0.003884s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002563s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111175033' OR `brand` LIKE 'Portescap%' ) ) LIMIT 1 [ RunTime:0.006297s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298226 AND `partno` = '1111175033' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%portescap%' ) [ RunTime:0.003636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471795 [ RunTime:0.003216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298216 LIMIT 5 [ RunTime:0.000601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298216 ORDER BY `minOrder` ASC [ RunTime:0.003756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298216 ORDER BY `unit` DESC [ RunTime:0.000563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298216 LIMIT 2 [ RunTime:0.003262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298216 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
select * from pdf where partno='1111165021' and brandshort='Portescap' limit 1 [ RunTime:0.000553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111165021' OR `brand` LIKE 'Portescap%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298216 AND `partno` = '1111165021' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%portescap%' ) [ RunTime:0.002923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471783 [ RunTime:0.004000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484059 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484059 ORDER BY `minOrder` ASC [ RunTime:0.008447s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484059 ORDER BY `unit` DESC [ RunTime:0.002086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484059 LIMIT 2 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484059 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
select * from pdf where partno='111110000' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.003233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '111110000' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.001706s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484059 AND `partno` = '111110000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.002728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203018 [ RunTime:0.004212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63334346 LIMIT 5 [ RunTime:0.000251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334346 ORDER BY `minOrder` ASC [ RunTime:0.000786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63334346 ORDER BY `unit` DESC [ RunTime:0.000265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63334346 LIMIT 2 [ RunTime:0.000245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63334346 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
select * from pdf where partno='1111102' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111102' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000252s ]
SELECT `id` FROM `stock` WHERE `id` <> 63334346 AND `partno` = '1111102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200688 [ RunTime:0.000232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64484060 LIMIT 5 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484060 ORDER BY `minOrder` ASC [ RunTime:0.003039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64484060 ORDER BY `unit` DESC [ RunTime:0.000480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64484060 LIMIT 2 [ RunTime:0.010761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64484060 ORDER BY `minOrder` ASC [ RunTime:0.001892s ]
select * from pdf where partno='111110100' and brandshort='Essentra Access Solutions' limit 1 [ RunTime:0.002645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '111110100' OR `brand` LIKE 'Essentra Access Solutions%' ) ) LIMIT 1 [ RunTime:0.001428s ]
SELECT `id` FROM `stock` WHERE `id` <> 64484060 AND `partno` = '111110100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%essentra access solutions%' ) [ RunTime:0.001931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19022907 [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335611 LIMIT 5 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335611 ORDER BY `minOrder` ASC [ RunTime:0.002790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335611 ORDER BY `unit` DESC [ RunTime:0.000388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335611 LIMIT 2 [ RunTime:0.002018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335611 ORDER BY `minOrder` ASC [ RunTime:0.001580s ]
select * from pdf where partno='1111161' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001137s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111161' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001683s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335611 AND `partno` = '1111161' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225695 [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298215 LIMIT 5 [ RunTime:0.001117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298215 ORDER BY `minOrder` ASC [ RunTime:0.003136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298215 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298215 LIMIT 2 [ RunTime:0.002195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298215 ORDER BY `minOrder` ASC [ RunTime:0.002309s ]
select * from pdf where partno='1111165020' and brandshort='Portescap' limit 1 [ RunTime:0.000572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111165020' OR `brand` LIKE 'Portescap%' ) ) LIMIT 1 [ RunTime:0.000515s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298215 AND `partno` = '1111165020' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%portescap%' ) [ RunTime:0.003110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471787 [ RunTime:0.000473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298214 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298214 ORDER BY `minOrder` ASC [ RunTime:0.002948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298214 ORDER BY `unit` DESC [ RunTime:0.000426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298214 LIMIT 2 [ RunTime:0.002938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298214 ORDER BY `minOrder` ASC [ RunTime:0.001768s ]
select * from pdf where partno='1111165019' and brandshort='Portescap' limit 1 [ RunTime:0.000868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111165019' OR `brand` LIKE 'Portescap%' ) ) LIMIT 1 [ RunTime:0.000523s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298214 AND `partno` = '1111165019' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%portescap%' ) [ RunTime:0.002821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13471788 [ RunTime:0.004215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60402870 LIMIT 5 [ RunTime:0.004889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402870 ORDER BY `minOrder` ASC [ RunTime:0.011718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60402870 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60402870 LIMIT 2 [ RunTime:0.002783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402870 ORDER BY `minOrder` ASC [ RunTime:0.000879s ]
select * from pdf where partno='1111170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111170000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004015s ]
SELECT `id` FROM `stock` WHERE `id` <> 60402870 AND `partno` = '1111170000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11855225 [ RunTime:0.003541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60402865 LIMIT 5 [ RunTime:0.002827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402865 ORDER BY `minOrder` ASC [ RunTime:0.003556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60402865 ORDER BY `unit` DESC [ RunTime:0.000509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60402865 LIMIT 2 [ RunTime:0.006018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402865 ORDER BY `minOrder` ASC [ RunTime:0.006520s ]
select * from pdf where partno='1111150000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111150000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.005213s ]
SELECT `id` FROM `stock` WHERE `id` <> 60402865 AND `partno` = '1111150000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13109009 [ RunTime:0.005924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60402863 LIMIT 5 [ RunTime:0.009282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402863 ORDER BY `minOrder` ASC [ RunTime:0.007902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60402863 ORDER BY `unit` DESC [ RunTime:0.006229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60402863 LIMIT 2 [ RunTime:0.003732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402863 ORDER BY `minOrder` ASC [ RunTime:0.004447s ]
select * from pdf where partno='1111140000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006413s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111140000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003395s ]
SELECT `id` FROM `stock` WHERE `id` <> 60402863 AND `partno` = '1111140000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60402139 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402139 ORDER BY `minOrder` ASC [ RunTime:0.003082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60402139 ORDER BY `unit` DESC [ RunTime:0.000838s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60402139 LIMIT 2 [ RunTime:0.002487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60402139 ORDER BY `minOrder` ASC [ RunTime:0.001554s ]
select * from pdf where partno='1111130000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111130000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002296s ]
SELECT `id` FROM `stock` WHERE `id` <> 60402139 AND `partno` = '1111130000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64495638 LIMIT 5 [ RunTime:0.000887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495638 ORDER BY `minOrder` ASC [ RunTime:0.003385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64495638 ORDER BY `unit` DESC [ RunTime:0.000880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64495638 LIMIT 2 [ RunTime:0.003002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64495638 ORDER BY `minOrder` ASC [ RunTime:0.001537s ]
select * from pdf where partno='1111190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010428s ]
SELECT `id` FROM `stock` WHERE `id` <> 64495638 AND `partno` = '1111190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14352774 [ RunTime:0.004082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462656 LIMIT 5 [ RunTime:0.000775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462656 ORDER BY `minOrder` ASC [ RunTime:0.003412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462656 ORDER BY `unit` DESC [ RunTime:0.000746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462656 LIMIT 2 [ RunTime:0.002647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462656 ORDER BY `minOrder` ASC [ RunTime:0.001638s ]
select * from pdf where partno='1111126' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001415s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111126' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003607s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462656 AND `partno` = '1111126' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207181 [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64422037 LIMIT 5 [ RunTime:0.002220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64422037 ORDER BY `minOrder` ASC [ RunTime:0.001769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64422037 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64422037 LIMIT 2 [ RunTime:0.002120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64422037 ORDER BY `minOrder` ASC [ RunTime:0.000895s ]
select * from pdf where partno='11111' and brandshort='3M' limit 1 [ RunTime:0.001186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '11111' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004038s ]
SELECT `id` FROM `stock` WHERE `id` <> 64422037 AND `partno` = '11111' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.002981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16996342 [ RunTime:0.001232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63201813 LIMIT 5 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201813 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63201813 ORDER BY `unit` DESC [ RunTime:0.000521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63201813 LIMIT 2 [ RunTime:0.001723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201813 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
select * from pdf where partno='1111177' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111177' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001034s ]
SELECT `id` FROM `stock` WHERE `id` <> 63201813 AND `partno` = '1111177' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975806 [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63201610 LIMIT 5 [ RunTime:0.000483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201610 ORDER BY `minOrder` ASC [ RunTime:0.001677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63201610 ORDER BY `unit` DESC [ RunTime:0.000439s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63201610 LIMIT 2 [ RunTime:0.001018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63201610 ORDER BY `minOrder` ASC [ RunTime:0.000722s ]
select * from pdf where partno='1111178' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111178' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001302s ]
SELECT `id` FROM `stock` WHERE `id` <> 63201610 AND `partno` = '1111178' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18975619 [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63200626 LIMIT 5 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200626 ORDER BY `minOrder` ASC [ RunTime:0.002575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63200626 ORDER BY `unit` DESC [ RunTime:0.003193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63200626 LIMIT 2 [ RunTime:0.005776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63200626 ORDER BY `minOrder` ASC [ RunTime:0.006163s ]
select * from pdf where partno='1111175' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111175' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005594s ]
SELECT `id` FROM `stock` WHERE `id` <> 63200626 AND `partno` = '1111175' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18974519 [ RunTime:0.002929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199211 LIMIT 5 [ RunTime:0.001293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199211 ORDER BY `minOrder` ASC [ RunTime:0.003761s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199211 ORDER BY `unit` DESC [ RunTime:0.002387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199211 LIMIT 2 [ RunTime:0.006230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199211 ORDER BY `minOrder` ASC [ RunTime:0.002643s ]
select * from pdf where partno='1111140' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111140' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000656s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199211 AND `partno` = '1111140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049244 [ RunTime:0.006639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198001 LIMIT 5 [ RunTime:0.001021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198001 ORDER BY `minOrder` ASC [ RunTime:0.006479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198001 ORDER BY `unit` DESC [ RunTime:0.001740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198001 LIMIT 2 [ RunTime:0.006792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198001 ORDER BY `minOrder` ASC [ RunTime:0.009100s ]
select * from pdf where partno='1111142' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1111142' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004861s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198001 AND `partno` = '1111142' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18980686 [ RunTime:0.004421s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001868s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000773s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000737s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000571s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000548s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000556s ]
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 '11111%' OR `brand` LIKE '11111%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003011s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '11111%' OR `brand` LIKE '11111%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001858s ]