SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001305s ]
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=SZ4-6.00-F5PGN&search=1' [ RunTime:0.001745s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001350s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000605s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002291s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.006314s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001853s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.012979s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003005s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SZ4-6.00-F5PGN' LIMIT 1 [ RunTime:0.008357s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-05 08:39:50' WHERE `partno` = 'SZ4-6.00-F5PGN' [ RunTime:0.010328s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002326s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013716s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217140 LIMIT 5 [ RunTime:0.039791s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217140 ORDER BY `minOrder` ASC [ RunTime:0.028837s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.016572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217140 ORDER BY `unit` DESC [ RunTime:0.021037s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217140 LIMIT 2 [ RunTime:0.040924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217140 ORDER BY `minOrder` ASC [ RunTime:0.008974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217139 LIMIT 5 [ RunTime:0.024915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217139 ORDER BY `minOrder` ASC [ RunTime:0.033883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217139 ORDER BY `unit` DESC [ RunTime:0.092136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217139 LIMIT 2 [ RunTime:0.098802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217139 ORDER BY `minOrder` ASC [ RunTime:0.033233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217031 LIMIT 5 [ RunTime:0.086053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217031 ORDER BY `minOrder` ASC [ RunTime:0.038010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217031 ORDER BY `unit` DESC [ RunTime:0.048827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217031 LIMIT 2 [ RunTime:0.051888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217031 ORDER BY `minOrder` ASC [ RunTime:0.048402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217019 LIMIT 5 [ RunTime:0.099884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217019 ORDER BY `minOrder` ASC [ RunTime:0.016698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217019 ORDER BY `unit` DESC [ RunTime:0.120924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217019 LIMIT 2 [ RunTime:0.134236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217019 ORDER BY `minOrder` ASC [ RunTime:0.020502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217017 LIMIT 5 [ RunTime:0.057585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217017 ORDER BY `minOrder` ASC [ RunTime:0.028226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217017 ORDER BY `unit` DESC [ RunTime:0.040628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217017 LIMIT 2 [ RunTime:0.064013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217017 ORDER BY `minOrder` ASC [ RunTime:0.038352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217013 LIMIT 5 [ RunTime:0.034330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217013 ORDER BY `minOrder` ASC [ RunTime:0.051942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12217013 ORDER BY `unit` DESC [ RunTime:0.043340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12217013 LIMIT 2 [ RunTime:0.072127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12217013 ORDER BY `minOrder` ASC [ RunTime:0.035050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220722 LIMIT 5 [ RunTime:0.025479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220722 ORDER BY `minOrder` ASC [ RunTime:0.050796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11220722 ORDER BY `unit` DESC [ RunTime:0.065494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11220722 LIMIT 2 [ RunTime:0.022685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220722 ORDER BY `minOrder` ASC [ RunTime:0.035711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220719 LIMIT 5 [ RunTime:0.011384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220719 ORDER BY `minOrder` ASC [ RunTime:0.027737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11220719 ORDER BY `unit` DESC [ RunTime:0.015583s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11220719 LIMIT 2 [ RunTime:0.018559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220719 ORDER BY `minOrder` ASC [ RunTime:0.005939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220713 LIMIT 5 [ RunTime:0.032883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220713 ORDER BY `minOrder` ASC [ RunTime:0.029124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11220713 ORDER BY `unit` DESC [ RunTime:0.028499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11220713 LIMIT 2 [ RunTime:0.033137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220713 ORDER BY `minOrder` ASC [ RunTime:0.031802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220711 LIMIT 5 [ RunTime:0.007390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220711 ORDER BY `minOrder` ASC [ RunTime:0.066587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11220711 ORDER BY `unit` DESC [ RunTime:0.026973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11220711 LIMIT 2 [ RunTime:0.053964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220711 ORDER BY `minOrder` ASC [ RunTime:0.004023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220636 LIMIT 5 [ RunTime:0.017299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220636 ORDER BY `minOrder` ASC [ RunTime:0.008972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11220636 ORDER BY `unit` DESC [ RunTime:0.041261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11220636 LIMIT 2 [ RunTime:0.033870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11220636 ORDER BY `minOrder` ASC [ RunTime:0.006092s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049554s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41291004 LIMIT 5 [ RunTime:0.023036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41291004 ORDER BY `minOrder` ASC [ RunTime:0.018389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41291004 ORDER BY `unit` DESC [ RunTime:0.036667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41291004 LIMIT 2 [ RunTime:0.034295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41291004 ORDER BY `minOrder` ASC [ RunTime:0.067228s ]
select * from pdf where partno='SZ4-6.00-F5PGN54-6' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.041668s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54-6' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.044263s ]
SELECT `id` FROM `stock` WHERE `id` <> 41291004 AND `partno` = 'SZ4-6.00-F5PGN54-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.073253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220722 [ RunTime:0.091960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41291000 LIMIT 5 [ RunTime:0.056565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41291000 ORDER BY `minOrder` ASC [ RunTime:0.069499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41291000 ORDER BY `unit` DESC [ RunTime:0.009622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41291000 LIMIT 2 [ RunTime:0.086466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41291000 ORDER BY `minOrder` ASC [ RunTime:0.047226s ]
select * from pdf where partno='SZ4-6.00-F5PGN54-9' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.082568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54-9' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.089171s ]
SELECT `id` FROM `stock` WHERE `id` <> 41291000 AND `partno` = 'SZ4-6.00-F5PGN54-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.129258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220719 [ RunTime:0.109627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290988 LIMIT 5 [ RunTime:0.051048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290988 ORDER BY `minOrder` ASC [ RunTime:0.037573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290988 ORDER BY `unit` DESC [ RunTime:0.032125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290988 LIMIT 2 [ RunTime:0.078389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290988 ORDER BY `minOrder` ASC [ RunTime:0.109552s ]
select * from pdf where partno='SZ4-6.00-F5PGN54-4' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.050750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54-4' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.059669s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290988 AND `partno` = 'SZ4-6.00-F5PGN54-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.075145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217140 [ RunTime:0.047581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290987 LIMIT 5 [ RunTime:0.090776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290987 ORDER BY `minOrder` ASC [ RunTime:0.069182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290987 ORDER BY `unit` DESC [ RunTime:0.164922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290987 LIMIT 2 [ RunTime:0.079344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290987 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='SZ4-6.00-F5PGN54' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.112099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.089369s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290987 AND `partno` = 'SZ4-6.00-F5PGN54' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.098367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217139 [ RunTime:0.040519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290984 LIMIT 5 [ RunTime:0.077785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290984 ORDER BY `minOrder` ASC [ RunTime:0.017092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290984 ORDER BY `unit` DESC [ RunTime:0.076084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290984 LIMIT 2 [ RunTime:0.055117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290984 ORDER BY `minOrder` ASC [ RunTime:0.042828s ]
select * from pdf where partno='SZ4-6.00-F5PGN54-5' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.032781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54-5' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.005533s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290984 AND `partno` = 'SZ4-6.00-F5PGN54-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.043996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220713 [ RunTime:0.014922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290982 LIMIT 5 [ RunTime:0.037277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290982 ORDER BY `minOrder` ASC [ RunTime:0.029348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290982 ORDER BY `unit` DESC [ RunTime:0.031008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290982 LIMIT 2 [ RunTime:0.008961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290982 ORDER BY `minOrder` ASC [ RunTime:0.014336s ]
select * from pdf where partno='SZ4-6.00-F5PGN54-2' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.001154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN54-2' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.001210s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290982 AND `partno` = 'SZ4-6.00-F5PGN54-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.020211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220711 [ RunTime:0.013841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290775 LIMIT 5 [ RunTime:0.006355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290775 ORDER BY `minOrder` ASC [ RunTime:0.002266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290775 ORDER BY `unit` DESC [ RunTime:0.007216s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290775 LIMIT 2 [ RunTime:0.007863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290775 ORDER BY `minOrder` ASC [ RunTime:0.002425s ]
select * from pdf where partno='SZ4-6.00-F5PGN-6' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.001093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN-6' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.002139s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290775 AND `partno` = 'SZ4-6.00-F5PGN-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.012950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290766 LIMIT 5 [ RunTime:0.009862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290766 ORDER BY `minOrder` ASC [ RunTime:0.002661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290766 ORDER BY `unit` DESC [ RunTime:0.000742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290766 LIMIT 2 [ RunTime:0.011317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290766 ORDER BY `minOrder` ASC [ RunTime:0.000508s ]
select * from pdf where partno='SZ4-6.00-F5PGN-4' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.001135s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN-4' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.002140s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290766 AND `partno` = 'SZ4-6.00-F5PGN-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.004391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217031 [ RunTime:0.009828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290762 LIMIT 5 [ RunTime:0.014139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290762 ORDER BY `minOrder` ASC [ RunTime:0.024177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290762 ORDER BY `unit` DESC [ RunTime:0.001277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290762 LIMIT 2 [ RunTime:0.020674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290762 ORDER BY `minOrder` ASC [ RunTime:0.001396s ]
select * from pdf where partno='SZ4-6.00-F5PGN-2' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.001598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN-2' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.002647s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290762 AND `partno` = 'SZ4-6.00-F5PGN-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.026315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11220636 [ RunTime:0.005864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290745 LIMIT 5 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290745 ORDER BY `minOrder` ASC [ RunTime:0.005523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290745 ORDER BY `unit` DESC [ RunTime:0.015639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290745 LIMIT 2 [ RunTime:0.008662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290745 ORDER BY `minOrder` ASC [ RunTime:0.009179s ]
select * from pdf where partno='SZ4-6.00-F5PGN-5' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.003367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN-5' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.014742s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290745 AND `partno` = 'SZ4-6.00-F5PGN-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217019 [ RunTime:0.007348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290743 LIMIT 5 [ RunTime:0.021707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290743 ORDER BY `minOrder` ASC [ RunTime:0.013983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290743 ORDER BY `unit` DESC [ RunTime:0.013064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290743 LIMIT 2 [ RunTime:0.024047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290743 ORDER BY `minOrder` ASC [ RunTime:0.010079s ]
select * from pdf where partno='SZ4-6.00-F5PGN-9' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.007485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN-9' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.004061s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290743 AND `partno` = 'SZ4-6.00-F5PGN-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.013542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217017 [ RunTime:0.000976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41290736 LIMIT 5 [ RunTime:0.009446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290736 ORDER BY `minOrder` ASC [ RunTime:0.008282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41290736 ORDER BY `unit` DESC [ RunTime:0.005264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41290736 LIMIT 2 [ RunTime:0.005599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41290736 ORDER BY `minOrder` ASC [ RunTime:0.002055s ]
select * from pdf where partno='SZ4-6.00-F5PGN' and brandshort='Bivar Inc.' limit 1 [ RunTime:0.003367s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SZ4-6.00-F5PGN' OR `brand` LIKE 'Bivar Inc.%' ) ) LIMIT 1 [ RunTime:0.013371s ]
SELECT `id` FROM `stock` WHERE `id` <> 41290736 AND `partno` = 'SZ4-6.00-F5PGN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bivar inc.%' ) [ RunTime:0.007947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12217013 [ RunTime:0.007577s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001815s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003857s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004182s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022876s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004200s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001136s ]
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 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003370s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SZ4-6.00-F5PGN%' OR `brand` LIKE 'SZ4-6.00-F5PGN%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003822s ]