SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001536s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=5180P-&search=1' [ RunTime:0.009038s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001408s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005131s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003429s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.008090s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001310s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011487s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003864s ]
SELECT * FROM `stock_search` WHERE `partno` = '5180P-' LIMIT 1 [ RunTime:0.019680s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-17 20:20:51' WHERE `partno` = '5180P-' [ RunTime:0.030418s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002659s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010779s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395936 LIMIT 5 [ RunTime:0.019666s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395936 ORDER BY `minOrder` ASC [ RunTime:0.033195s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395936 ORDER BY `unit` DESC [ RunTime:0.024335s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395936 LIMIT 2 [ RunTime:0.007458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395936 ORDER BY `minOrder` ASC [ RunTime:0.017004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395935 LIMIT 5 [ RunTime:0.011931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395935 ORDER BY `minOrder` ASC [ RunTime:0.014488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395935 ORDER BY `unit` DESC [ RunTime:0.009769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395935 LIMIT 2 [ RunTime:0.020427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395935 ORDER BY `minOrder` ASC [ RunTime:0.015120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395934 LIMIT 5 [ RunTime:0.007217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395934 ORDER BY `minOrder` ASC [ RunTime:0.026491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395934 ORDER BY `unit` DESC [ RunTime:0.023268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395934 LIMIT 2 [ RunTime:0.012477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395934 ORDER BY `minOrder` ASC [ RunTime:0.005678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395932 LIMIT 5 [ RunTime:0.017726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395932 ORDER BY `minOrder` ASC [ RunTime:0.010218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395932 ORDER BY `unit` DESC [ RunTime:0.027783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395932 LIMIT 2 [ RunTime:0.015875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395932 ORDER BY `minOrder` ASC [ RunTime:0.011441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395931 LIMIT 5 [ RunTime:0.012688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395931 ORDER BY `minOrder` ASC [ RunTime:0.027532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395931 ORDER BY `unit` DESC [ RunTime:0.035221s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395931 LIMIT 2 [ RunTime:0.051532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395931 ORDER BY `minOrder` ASC [ RunTime:0.015951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395930 LIMIT 5 [ RunTime:0.031988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395930 ORDER BY `minOrder` ASC [ RunTime:0.005031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395930 ORDER BY `unit` DESC [ RunTime:0.027384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395930 LIMIT 2 [ RunTime:0.018863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395930 ORDER BY `minOrder` ASC [ RunTime:0.015769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395929 LIMIT 5 [ RunTime:0.012756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395929 ORDER BY `minOrder` ASC [ RunTime:0.014242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395929 ORDER BY `unit` DESC [ RunTime:0.014768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395929 LIMIT 2 [ RunTime:0.013107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395929 ORDER BY `minOrder` ASC [ RunTime:0.031630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395928 LIMIT 5 [ RunTime:0.022367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395928 ORDER BY `minOrder` ASC [ RunTime:0.025970s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395928 ORDER BY `unit` DESC [ RunTime:0.009276s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395928 LIMIT 2 [ RunTime:0.014357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395928 ORDER BY `minOrder` ASC [ RunTime:0.019883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395927 LIMIT 5 [ RunTime:0.030749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395927 ORDER BY `minOrder` ASC [ RunTime:0.037592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395927 ORDER BY `unit` DESC [ RunTime:0.020594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395927 LIMIT 2 [ RunTime:0.035963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395927 ORDER BY `minOrder` ASC [ RunTime:0.023794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395926 LIMIT 5 [ RunTime:0.013604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395926 ORDER BY `minOrder` ASC [ RunTime:0.008401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395926 ORDER BY `unit` DESC [ RunTime:0.014784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395926 LIMIT 2 [ RunTime:0.023161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395926 ORDER BY `minOrder` ASC [ RunTime:0.017668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395925 LIMIT 5 [ RunTime:0.018152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395925 ORDER BY `minOrder` ASC [ RunTime:0.013623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395925 ORDER BY `unit` DESC [ RunTime:0.006984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395925 LIMIT 2 [ RunTime:0.002699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395925 ORDER BY `minOrder` ASC [ RunTime:0.003304s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395923 LIMIT 5 [ RunTime:0.006607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395923 ORDER BY `minOrder` ASC [ RunTime:0.037009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395923 ORDER BY `unit` DESC [ RunTime:0.019141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395923 LIMIT 2 [ RunTime:0.032499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395923 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395920 LIMIT 5 [ RunTime:0.009847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395920 ORDER BY `minOrder` ASC [ RunTime:0.021884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395920 ORDER BY `unit` DESC [ RunTime:0.006282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395920 LIMIT 2 [ RunTime:0.013959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395920 ORDER BY `minOrder` ASC [ RunTime:0.014420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395915 LIMIT 5 [ RunTime:0.017772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395915 ORDER BY `minOrder` ASC [ RunTime:0.015211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395915 ORDER BY `unit` DESC [ RunTime:0.009046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395915 LIMIT 2 [ RunTime:0.004636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395915 ORDER BY `minOrder` ASC [ RunTime:0.002390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395914 LIMIT 5 [ RunTime:0.004328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395914 ORDER BY `minOrder` ASC [ RunTime:0.018707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395914 ORDER BY `unit` DESC [ RunTime:0.001301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395914 LIMIT 2 [ RunTime:0.009613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395914 ORDER BY `minOrder` ASC [ RunTime:0.010650s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395912 LIMIT 5 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395912 ORDER BY `minOrder` ASC [ RunTime:0.016709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395912 ORDER BY `unit` DESC [ RunTime:0.011242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395912 LIMIT 2 [ RunTime:0.014758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395912 ORDER BY `minOrder` ASC [ RunTime:0.007465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395911 LIMIT 5 [ RunTime:0.005884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395911 ORDER BY `minOrder` ASC [ RunTime:0.007025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395911 ORDER BY `unit` DESC [ RunTime:0.008038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395911 LIMIT 2 [ RunTime:0.008683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395911 ORDER BY `minOrder` ASC [ RunTime:0.000524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395909 LIMIT 5 [ RunTime:0.007009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395909 ORDER BY `minOrder` ASC [ RunTime:0.003298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395909 ORDER BY `unit` DESC [ RunTime:0.002335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395909 LIMIT 2 [ RunTime:0.001082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395909 ORDER BY `minOrder` ASC [ RunTime:0.001731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395907 LIMIT 5 [ RunTime:0.010099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395907 ORDER BY `minOrder` ASC [ RunTime:0.006786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14395907 ORDER BY `unit` DESC [ RunTime:0.013452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14395907 LIMIT 2 [ RunTime:0.006609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14395907 ORDER BY `minOrder` ASC [ RunTime:0.002937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524819 LIMIT 5 [ RunTime:0.006240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524819 ORDER BY `minOrder` ASC [ RunTime:0.001942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13524819 ORDER BY `unit` DESC [ RunTime:0.006990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13524819 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13524819 ORDER BY `minOrder` ASC [ RunTime:0.000403s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007038s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514459 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514459 ORDER BY `minOrder` ASC [ RunTime:0.004466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514459 ORDER BY `unit` DESC [ RunTime:0.017543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514459 LIMIT 2 [ RunTime:0.006113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514459 ORDER BY `minOrder` ASC [ RunTime:0.003129s ]
select * from pdf where partno='5180P-9' and brandshort='Brady Corporation' limit 1 [ RunTime:0.028049s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-9' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019192s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514459 AND `partno` = '5180P-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524819 [ RunTime:0.016301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514457 LIMIT 5 [ RunTime:0.013771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514457 ORDER BY `minOrder` ASC [ RunTime:0.015651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514457 ORDER BY `unit` DESC [ RunTime:0.012947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514457 LIMIT 2 [ RunTime:0.007778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514457 ORDER BY `minOrder` ASC [ RunTime:0.004375s ]
select * from pdf where partno='5180P-O' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-O' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019499s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514457 AND `partno` = '5180P-O' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524817 [ RunTime:0.012685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514453 LIMIT 5 [ RunTime:0.006551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514453 ORDER BY `minOrder` ASC [ RunTime:0.002828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514453 ORDER BY `unit` DESC [ RunTime:0.011937s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514453 LIMIT 2 [ RunTime:0.009380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514453 ORDER BY `minOrder` ASC [ RunTime:0.014234s ]
select * from pdf where partno='5180P-8' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-8' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004580s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514453 AND `partno` = '5180P-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524815 [ RunTime:0.017268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514448 LIMIT 5 [ RunTime:0.012472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514448 ORDER BY `minOrder` ASC [ RunTime:0.011870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514448 ORDER BY `unit` DESC [ RunTime:0.007613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514448 LIMIT 2 [ RunTime:0.010371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514448 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='5180P-K' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-K' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.010018s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514448 AND `partno` = '5180P-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524812 [ RunTime:0.023105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514447 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514447 ORDER BY `minOrder` ASC [ RunTime:0.013738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514447 ORDER BY `unit` DESC [ RunTime:0.007078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514447 LIMIT 2 [ RunTime:0.010166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514447 ORDER BY `minOrder` ASC [ RunTime:0.001239s ]
select * from pdf where partno='5180P-V' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-V' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008473s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514447 AND `partno` = '5180P-V' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395936 [ RunTime:0.006819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514446 LIMIT 5 [ RunTime:0.001791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514446 ORDER BY `minOrder` ASC [ RunTime:0.008024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514446 ORDER BY `unit` DESC [ RunTime:0.008416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514446 LIMIT 2 [ RunTime:0.007932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514446 ORDER BY `minOrder` ASC [ RunTime:0.001488s ]
select * from pdf where partno='5180P-0' and brandshort='Brady Corporation' limit 1 [ RunTime:0.008616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-0' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.008423s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514446 AND `partno` = '5180P-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395935 [ RunTime:0.014458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514445 LIMIT 5 [ RunTime:0.003211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514445 ORDER BY `minOrder` ASC [ RunTime:0.001001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514445 ORDER BY `unit` DESC [ RunTime:0.007582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514445 LIMIT 2 [ RunTime:0.001590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514445 ORDER BY `minOrder` ASC [ RunTime:0.014071s ]
select * from pdf where partno='5180P-N' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-N' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.007279s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514445 AND `partno` = '5180P-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395934 [ RunTime:0.000709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514443 LIMIT 5 [ RunTime:0.003905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514443 ORDER BY `minOrder` ASC [ RunTime:0.002813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514443 ORDER BY `unit` DESC [ RunTime:0.003508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514443 LIMIT 2 [ RunTime:0.001895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514443 ORDER BY `minOrder` ASC [ RunTime:0.011322s ]
select * from pdf where partno='5180P-2' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000829s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-2' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.013923s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514443 AND `partno` = '5180P-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524811 [ RunTime:0.000897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514442 LIMIT 5 [ RunTime:0.001107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514442 ORDER BY `minOrder` ASC [ RunTime:0.008051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514442 ORDER BY `unit` DESC [ RunTime:0.006983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514442 LIMIT 2 [ RunTime:0.004617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514442 ORDER BY `minOrder` ASC [ RunTime:0.010888s ]
select * from pdf where partno='5180P-6' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-6' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004396s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514442 AND `partno` = '5180P-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524810 [ RunTime:0.003872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514441 LIMIT 5 [ RunTime:0.004998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514441 ORDER BY `minOrder` ASC [ RunTime:0.002950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514441 ORDER BY `unit` DESC [ RunTime:0.002377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514441 LIMIT 2 [ RunTime:0.012265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514441 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='5180P-C' and brandshort='Brady Corporation' limit 1 [ RunTime:0.014239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-C' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.011200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514441 AND `partno` = '5180P-C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.018955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524809 [ RunTime:0.018327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514439 LIMIT 5 [ RunTime:0.010248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514439 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514439 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514439 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514439 ORDER BY `minOrder` ASC [ RunTime:0.000699s ]
select * from pdf where partno='5180P-X' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-X' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021662s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514439 AND `partno` = '5180P-X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.005496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524807 [ RunTime:0.013325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514436 LIMIT 5 [ RunTime:0.008987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514436 ORDER BY `minOrder` ASC [ RunTime:0.011201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514436 ORDER BY `unit` DESC [ RunTime:0.013261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514436 LIMIT 2 [ RunTime:0.028563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514436 ORDER BY `minOrder` ASC [ RunTime:0.005125s ]
select * from pdf where partno='5180P-F' and brandshort='Brady Corporation' limit 1 [ RunTime:0.035235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-F' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015308s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514436 AND `partno` = '5180P-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.013343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524804 [ RunTime:0.002649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514435 LIMIT 5 [ RunTime:0.011177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514435 ORDER BY `minOrder` ASC [ RunTime:0.015493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514435 ORDER BY `unit` DESC [ RunTime:0.034027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514435 LIMIT 2 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514435 ORDER BY `minOrder` ASC [ RunTime:0.002810s ]
select * from pdf where partno='5180P-E' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016605s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-E' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009793s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514435 AND `partno` = '5180P-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395932 [ RunTime:0.017550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514434 LIMIT 5 [ RunTime:0.014884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514434 ORDER BY `minOrder` ASC [ RunTime:0.047807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514434 ORDER BY `unit` DESC [ RunTime:0.008609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514434 LIMIT 2 [ RunTime:0.003109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514434 ORDER BY `minOrder` ASC [ RunTime:0.044714s ]
select * from pdf where partno='5180P-D' and brandshort='Brady Corporation' limit 1 [ RunTime:0.015874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-D' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.041654s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514434 AND `partno` = '5180P-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395931 [ RunTime:0.019387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514433 LIMIT 5 [ RunTime:0.041250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514433 ORDER BY `minOrder` ASC [ RunTime:0.010458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514433 ORDER BY `unit` DESC [ RunTime:0.010160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514433 LIMIT 2 [ RunTime:0.032924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514433 ORDER BY `minOrder` ASC [ RunTime:0.024694s ]
select * from pdf where partno='5180P-L' and brandshort='Brady Corporation' limit 1 [ RunTime:0.031279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-L' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.012752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514433 AND `partno` = '5180P-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.036781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395930 [ RunTime:0.030832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514432 LIMIT 5 [ RunTime:0.047989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514432 ORDER BY `minOrder` ASC [ RunTime:0.033238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514432 ORDER BY `unit` DESC [ RunTime:0.036686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514432 LIMIT 2 [ RunTime:0.022502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514432 ORDER BY `minOrder` ASC [ RunTime:0.031364s ]
select * from pdf where partno='5180P-3' and brandshort='Brady Corporation' limit 1 [ RunTime:0.036368s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-3' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.032001s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514432 AND `partno` = '5180P-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.021584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395929 [ RunTime:0.006523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514430 LIMIT 5 [ RunTime:0.019241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514430 ORDER BY `minOrder` ASC [ RunTime:0.033350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514430 ORDER BY `unit` DESC [ RunTime:0.009848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514430 LIMIT 2 [ RunTime:0.014728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514430 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
select * from pdf where partno='5180P-7' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-7' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020379s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514430 AND `partno` = '5180P-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.039728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13524802 [ RunTime:0.017760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514429 LIMIT 5 [ RunTime:0.009539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514429 ORDER BY `minOrder` ASC [ RunTime:0.002782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514429 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514429 LIMIT 2 [ RunTime:0.015842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514429 ORDER BY `minOrder` ASC [ RunTime:0.018728s ]
select * from pdf where partno='5180P-W' and brandshort='Brady Corporation' limit 1 [ RunTime:0.022773s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-W' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.020733s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514429 AND `partno` = '5180P-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.024777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395928 [ RunTime:0.033866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514428 LIMIT 5 [ RunTime:0.032174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514428 ORDER BY `minOrder` ASC [ RunTime:0.037069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514428 ORDER BY `unit` DESC [ RunTime:0.040041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514428 LIMIT 2 [ RunTime:0.008384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514428 ORDER BY `minOrder` ASC [ RunTime:0.012497s ]
select * from pdf where partno='5180P-H' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-H' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.023752s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514428 AND `partno` = '5180P-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.009017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395927 [ RunTime:0.000566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64514427 LIMIT 5 [ RunTime:0.020028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514427 ORDER BY `minOrder` ASC [ RunTime:0.015517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64514427 ORDER BY `unit` DESC [ RunTime:0.000513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64514427 LIMIT 2 [ RunTime:0.012840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64514427 ORDER BY `minOrder` ASC [ RunTime:0.010707s ]
select * from pdf where partno='5180P-S' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5180P-S' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002669s ]
SELECT `id` FROM `stock` WHERE `id` <> 64514427 AND `partno` = '5180P-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14395926 [ RunTime:0.002494s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028981s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024196s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022428s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015159s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027234s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013564s ]
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 '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011407s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5180P-%' OR `brand` LIKE '5180P-%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018991s ]