SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001574s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=12178&search=1' [ RunTime:0.003654s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001404s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002238s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.001681s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001152s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001492s ]
SELECT * FROM `stock_search` WHERE `partno` = '12178' LIMIT 1 [ RunTime:0.001789s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 18:52:48' WHERE `partno` = '12178' [ RunTime:0.001541s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001331s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021667s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417059 LIMIT 5 [ RunTime:0.000778s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417059 ORDER BY `minOrder` ASC [ RunTime:0.003091s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417059 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417059 LIMIT 2 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417059 ORDER BY `minOrder` ASC [ RunTime:0.003204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4982 LIMIT 5 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4982 ORDER BY `minOrder` ASC [ RunTime:0.005829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4982 ORDER BY `unit` DESC [ RunTime:0.009574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4982 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4982 ORDER BY `minOrder` ASC [ RunTime:0.007621s ]
select * from pdf where partno='1217861-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.007160s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003845s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217861-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.001268s ]
SELECT `id` FROM `stock` WHERE `id` <> 4982 AND `partno` = '1217861-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.009618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16088 [ RunTime:0.004986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17106 [ RunTime:0.007980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11414000 LIMIT 5 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414000 ORDER BY `minOrder` ASC [ RunTime:0.009341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11414000 ORDER BY `unit` DESC [ RunTime:0.000398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11414000 LIMIT 2 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11414000 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17106 LIMIT 5 [ RunTime:0.000356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17106 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17106 ORDER BY `unit` DESC [ RunTime:0.011748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17106 LIMIT 2 [ RunTime:0.022969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17106 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
select * from pdf where partno='1217861-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.008377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217861-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.000450s ]
SELECT `id` FROM `stock` WHERE `id` <> 17106 AND `partno` = '1217861-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.003018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4982 [ RunTime:0.005003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16088 [ RunTime:0.002434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16088 LIMIT 5 [ RunTime:0.002206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16088 ORDER BY `minOrder` ASC [ RunTime:0.005163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16088 ORDER BY `unit` DESC [ RunTime:0.018576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16088 LIMIT 2 [ RunTime:0.008503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16088 ORDER BY `minOrder` ASC [ RunTime:0.001547s ]
select * from pdf where partno='1217861-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217861-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.003271s ]
SELECT `id` FROM `stock` WHERE `id` <> 16088 AND `partno` = '1217861-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.030031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4982 [ RunTime:0.003180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17106 [ RunTime:0.007191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11854816 LIMIT 5 [ RunTime:0.005517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854816 ORDER BY `minOrder` ASC [ RunTime:0.003510s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11854816 ORDER BY `unit` DESC [ RunTime:0.027661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11854816 LIMIT 2 [ RunTime:0.002960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11854816 ORDER BY `minOrder` ASC [ RunTime:0.005877s ]
select * from pdf where partno='1217800000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19589895 LIMIT 5 [ RunTime:0.020782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589895 ORDER BY `minOrder` ASC [ RunTime:0.011342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19589895 ORDER BY `unit` DESC [ RunTime:0.008518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19589895 LIMIT 2 [ RunTime:0.024700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19589895 ORDER BY `minOrder` ASC [ RunTime:0.005728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19578352 LIMIT 5 [ RunTime:0.008102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578352 ORDER BY `minOrder` ASC [ RunTime:0.003833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19578352 ORDER BY `unit` DESC [ RunTime:0.019331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19578352 LIMIT 2 [ RunTime:0.002328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19578352 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18915097 LIMIT 5 [ RunTime:0.014852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18915097 ORDER BY `minOrder` ASC [ RunTime:0.002357s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18915097 ORDER BY `unit` DESC [ RunTime:0.021419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18915097 LIMIT 2 [ RunTime:0.011242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18915097 ORDER BY `minOrder` ASC [ RunTime:0.002566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837630 LIMIT 5 [ RunTime:0.010940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837630 ORDER BY `minOrder` ASC [ RunTime:0.025349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837630 ORDER BY `unit` DESC [ RunTime:0.006592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837630 LIMIT 2 [ RunTime:0.022021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837630 ORDER BY `minOrder` ASC [ RunTime:0.034763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837531 LIMIT 5 [ RunTime:0.020750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837531 ORDER BY `minOrder` ASC [ RunTime:0.021156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837531 ORDER BY `unit` DESC [ RunTime:0.021116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837531 LIMIT 2 [ RunTime:0.024009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837531 ORDER BY `minOrder` ASC [ RunTime:0.009199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837514 LIMIT 5 [ RunTime:0.022409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837514 ORDER BY `minOrder` ASC [ RunTime:0.029395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837514 ORDER BY `unit` DESC [ RunTime:0.026007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837514 LIMIT 2 [ RunTime:0.017346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837514 ORDER BY `minOrder` ASC [ RunTime:0.032994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837442 LIMIT 5 [ RunTime:0.016183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837442 ORDER BY `minOrder` ASC [ RunTime:0.018203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837442 ORDER BY `unit` DESC [ RunTime:0.004378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837442 LIMIT 2 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837442 ORDER BY `minOrder` ASC [ RunTime:0.003760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837422 LIMIT 5 [ RunTime:0.010834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837422 ORDER BY `minOrder` ASC [ RunTime:0.015150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837422 ORDER BY `unit` DESC [ RunTime:0.002400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837422 LIMIT 2 [ RunTime:0.020237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837422 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837421 LIMIT 5 [ RunTime:0.007955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837421 ORDER BY `minOrder` ASC [ RunTime:0.008104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837421 ORDER BY `unit` DESC [ RunTime:0.009460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837421 LIMIT 2 [ RunTime:0.010910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837421 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837059 LIMIT 5 [ RunTime:0.010116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837059 ORDER BY `minOrder` ASC [ RunTime:0.017109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837059 ORDER BY `unit` DESC [ RunTime:0.000684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837059 LIMIT 2 [ RunTime:0.004960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837059 ORDER BY `minOrder` ASC [ RunTime:0.005213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836952 LIMIT 5 [ RunTime:0.005298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836952 ORDER BY `minOrder` ASC [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836952 ORDER BY `unit` DESC [ RunTime:0.001622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836952 LIMIT 2 [ RunTime:0.010082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836952 ORDER BY `minOrder` ASC [ RunTime:0.013293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836950 LIMIT 5 [ RunTime:0.034236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836950 ORDER BY `minOrder` ASC [ RunTime:0.008016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836950 ORDER BY `unit` DESC [ RunTime:0.000644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836950 LIMIT 2 [ RunTime:0.017188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836950 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836864 LIMIT 5 [ RunTime:0.020627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836864 ORDER BY `minOrder` ASC [ RunTime:0.002815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836864 ORDER BY `unit` DESC [ RunTime:0.022107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836864 LIMIT 2 [ RunTime:0.021132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836864 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836703 LIMIT 5 [ RunTime:0.015119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836703 ORDER BY `minOrder` ASC [ RunTime:0.035103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18836703 ORDER BY `unit` DESC [ RunTime:0.025365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18836703 LIMIT 2 [ RunTime:0.007426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18836703 ORDER BY `minOrder` ASC [ RunTime:0.021860s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029325s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60638811 LIMIT 5 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60638811 ORDER BY `minOrder` ASC [ RunTime:0.015939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60638811 ORDER BY `unit` DESC [ RunTime:0.002911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60638811 LIMIT 2 [ RunTime:0.008711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60638811 ORDER BY `minOrder` ASC [ RunTime:0.002398s ]
select * from pdf where partno='1217861-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217861-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.009208s ]
SELECT `id` FROM `stock` WHERE `id` <> 60638811 AND `partno` = '1217861-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.004581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417059 [ RunTime:0.024625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518542 LIMIT 5 [ RunTime:0.013175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518542 ORDER BY `minOrder` ASC [ RunTime:0.018652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518542 ORDER BY `unit` DESC [ RunTime:0.015467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518542 LIMIT 2 [ RunTime:0.012746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518542 ORDER BY `minOrder` ASC [ RunTime:0.004483s ]
select * from pdf where partno='121789' and brandshort='Brady Corporation' limit 1 [ RunTime:0.011225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121789' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.019048s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518542 AND `partno` = '121789' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.035866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505277 [ RunTime:0.013770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518540 LIMIT 5 [ RunTime:0.009045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518540 ORDER BY `minOrder` ASC [ RunTime:0.034762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518540 ORDER BY `unit` DESC [ RunTime:0.043677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518540 LIMIT 2 [ RunTime:0.047199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518540 ORDER BY `minOrder` ASC [ RunTime:0.020015s ]
select * from pdf where partno='121782' and brandshort='Brady Corporation' limit 1 [ RunTime:0.026652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121782' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.015214s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518540 AND `partno` = '121782' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.027675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525552 [ RunTime:0.021187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518536 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518536 ORDER BY `minOrder` ASC [ RunTime:0.006803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518536 ORDER BY `unit` DESC [ RunTime:0.013176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518536 LIMIT 2 [ RunTime:0.012811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518536 ORDER BY `minOrder` ASC [ RunTime:0.008302s ]
select * from pdf where partno='121783' and brandshort='Brady Corporation' limit 1 [ RunTime:0.012423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121783' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.021249s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518536 AND `partno` = '121783' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657057 [ RunTime:0.028943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518534 LIMIT 5 [ RunTime:0.002866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518534 ORDER BY `minOrder` ASC [ RunTime:0.021144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518534 ORDER BY `unit` DESC [ RunTime:0.021237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518534 LIMIT 2 [ RunTime:0.013180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518534 ORDER BY `minOrder` ASC [ RunTime:0.019969s ]
select * from pdf where partno='121787' and brandshort='Brady Corporation' limit 1 [ RunTime:0.017568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121787' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.027432s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518534 AND `partno` = '121787' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.042189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505275 [ RunTime:0.007421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518533 LIMIT 5 [ RunTime:0.015972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518533 ORDER BY `minOrder` ASC [ RunTime:0.067883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518533 ORDER BY `unit` DESC [ RunTime:0.032633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518533 LIMIT 2 [ RunTime:0.032547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518533 ORDER BY `minOrder` ASC [ RunTime:0.001281s ]
select * from pdf where partno='121786' and brandshort='Brady Corporation' limit 1 [ RunTime:0.042701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121786' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.038925s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518533 AND `partno` = '121786' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.076414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505274 [ RunTime:0.050061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518532 LIMIT 5 [ RunTime:0.084063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518532 ORDER BY `minOrder` ASC [ RunTime:0.043895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518532 ORDER BY `unit` DESC [ RunTime:0.085043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518532 LIMIT 2 [ RunTime:0.018379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518532 ORDER BY `minOrder` ASC [ RunTime:0.026394s ]
select * from pdf where partno='121780' and brandshort='Brady Corporation' limit 1 [ RunTime:0.033947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121780' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018660s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518532 AND `partno` = '121780' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.017048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16505273 [ RunTime:0.008232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518531 LIMIT 5 [ RunTime:0.039461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518531 ORDER BY `minOrder` ASC [ RunTime:0.022409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518531 ORDER BY `unit` DESC [ RunTime:0.031058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518531 LIMIT 2 [ RunTime:0.044613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518531 ORDER BY `minOrder` ASC [ RunTime:0.020817s ]
select * from pdf where partno='121788' and brandshort='Brady Corporation' limit 1 [ RunTime:0.029176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121788' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.034641s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518531 AND `partno` = '121788' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.032252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657056 [ RunTime:0.011080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518530 LIMIT 5 [ RunTime:0.011312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518530 ORDER BY `minOrder` ASC [ RunTime:0.029893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518530 ORDER BY `unit` DESC [ RunTime:0.025673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518530 LIMIT 2 [ RunTime:0.013657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518530 ORDER BY `minOrder` ASC [ RunTime:0.004110s ]
select * from pdf where partno='121784' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121784' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.018861s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518530 AND `partno` = '121784' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.012681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657055 [ RunTime:0.020942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518527 LIMIT 5 [ RunTime:0.010961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518527 ORDER BY `minOrder` ASC [ RunTime:0.023570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518527 ORDER BY `unit` DESC [ RunTime:0.012881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518527 LIMIT 2 [ RunTime:0.007375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518527 ORDER BY `minOrder` ASC [ RunTime:0.021147s ]
select * from pdf where partno='121781' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121781' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.014102s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518527 AND `partno` = '121781' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14525547 [ RunTime:0.001400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64518526 LIMIT 5 [ RunTime:0.001917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518526 ORDER BY `minOrder` ASC [ RunTime:0.021526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64518526 ORDER BY `unit` DESC [ RunTime:0.002675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64518526 LIMIT 2 [ RunTime:0.012237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64518526 ORDER BY `minOrder` ASC [ RunTime:0.010360s ]
select * from pdf where partno='121785' and brandshort='Brady Corporation' limit 1 [ RunTime:0.016099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '121785' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.031380s ]
SELECT `id` FROM `stock` WHERE `id` <> 64518526 AND `partno` = '121785' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.019157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13657054 [ RunTime:0.015658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462484 LIMIT 5 [ RunTime:0.012854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462484 ORDER BY `minOrder` ASC [ RunTime:0.004565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462484 ORDER BY `unit` DESC [ RunTime:0.041271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462484 LIMIT 2 [ RunTime:0.007655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462484 ORDER BY `minOrder` ASC [ RunTime:0.003902s ]
select * from pdf where partno='1217814' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217814' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019637s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462484 AND `partno` = '1217814' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.053342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207117 [ RunTime:0.017790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462472 LIMIT 5 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462472 ORDER BY `minOrder` ASC [ RunTime:0.017702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462472 ORDER BY `unit` DESC [ RunTime:0.010789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462472 LIMIT 2 [ RunTime:0.018521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462472 ORDER BY `minOrder` ASC [ RunTime:0.009268s ]
select * from pdf where partno='1217823' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217823' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003894s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462472 AND `partno` = '1217823' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198163 [ RunTime:0.014862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462470 LIMIT 5 [ RunTime:0.016191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462470 ORDER BY `minOrder` ASC [ RunTime:0.008162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462470 ORDER BY `unit` DESC [ RunTime:0.003475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462470 LIMIT 2 [ RunTime:0.035738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462470 ORDER BY `minOrder` ASC [ RunTime:0.004881s ]
select * from pdf where partno='1217829' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217829' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.014765s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462470 AND `partno` = '1217829' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198162 [ RunTime:0.004700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462386 LIMIT 5 [ RunTime:0.056150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462386 ORDER BY `minOrder` ASC [ RunTime:0.039900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462386 ORDER BY `unit` DESC [ RunTime:0.000814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462386 LIMIT 2 [ RunTime:0.028877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462386 ORDER BY `minOrder` ASC [ RunTime:0.008487s ]
select * from pdf where partno='1217820' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.016405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217820' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000819s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462386 AND `partno` = '1217820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198129 [ RunTime:0.017303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462385 LIMIT 5 [ RunTime:0.007741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462385 ORDER BY `minOrder` ASC [ RunTime:0.014819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462385 ORDER BY `unit` DESC [ RunTime:0.018595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462385 LIMIT 2 [ RunTime:0.016766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462385 ORDER BY `minOrder` ASC [ RunTime:0.005680s ]
select * from pdf where partno='1217826' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217826' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024038s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462385 AND `partno` = '1217826' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64462236 LIMIT 5 [ RunTime:0.009405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462236 ORDER BY `minOrder` ASC [ RunTime:0.017092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64462236 ORDER BY `unit` DESC [ RunTime:0.038835s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64462236 LIMIT 2 [ RunTime:0.012542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64462236 ORDER BY `minOrder` ASC [ RunTime:0.022549s ]
select * from pdf where partno='1217835' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.040087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217835' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004873s ]
SELECT `id` FROM `stock` WHERE `id` <> 64462236 AND `partno` = '1217835' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12198052 [ RunTime:0.005773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64461987 LIMIT 5 [ RunTime:0.029280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461987 ORDER BY `minOrder` ASC [ RunTime:0.009592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64461987 ORDER BY `unit` DESC [ RunTime:0.006317s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64461987 LIMIT 2 [ RunTime:0.006761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461987 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
select * from pdf where partno='1217841' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217841' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001899s ]
SELECT `id` FROM `stock` WHERE `id` <> 64461987 AND `partno` = '1217841' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206951 [ RunTime:0.004955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64461986 LIMIT 5 [ RunTime:0.009026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461986 ORDER BY `minOrder` ASC [ RunTime:0.024658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64461986 ORDER BY `unit` DESC [ RunTime:0.013786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64461986 LIMIT 2 [ RunTime:0.021935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461986 ORDER BY `minOrder` ASC [ RunTime:0.000558s ]
select * from pdf where partno='1217846' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217846' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015062s ]
SELECT `id` FROM `stock` WHERE `id` <> 64461986 AND `partno` = '1217846' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.018527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197940 [ RunTime:0.005531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64461983 LIMIT 5 [ RunTime:0.016262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461983 ORDER BY `minOrder` ASC [ RunTime:0.008292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64461983 ORDER BY `unit` DESC [ RunTime:0.003236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64461983 LIMIT 2 [ RunTime:0.012240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64461983 ORDER BY `minOrder` ASC [ RunTime:0.000777s ]
select * from pdf where partno='1217832' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1217832' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002047s ]
SELECT `id` FROM `stock` WHERE `id` <> 64461983 AND `partno` = '1217832' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12197937 [ RunTime:0.009710s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005955s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002828s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003094s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003286s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002824s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003804s ]
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 '12178%' OR `brand` LIKE '12178%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000968s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12178%' OR `brand` LIKE '12178%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008067s ]