SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001917s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.58' , `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=60343&search=1' [ RunTime:0.001825s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002396s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.004798s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003829s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.58' ) [ RunTime:0.000475s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002168s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000460s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001246s ]
SELECT * FROM `stock_search` WHERE `partno` = '60343' LIMIT 1 [ RunTime:0.008447s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-07 02:07:17' WHERE `partno` = '60343' [ RunTime:0.001504s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002054s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012720s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784251 LIMIT 5 [ RunTime:0.001048s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784251 ORDER BY `minOrder` ASC [ RunTime:0.014103s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18784251 ORDER BY `unit` DESC [ RunTime:0.009130s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18784251 LIMIT 2 [ RunTime:0.012456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18784251 ORDER BY `minOrder` ASC [ RunTime:0.014364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19527146 LIMIT 5 [ RunTime:0.005872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19527146 ORDER BY `minOrder` ASC [ RunTime:0.022339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19527146 ORDER BY `unit` DESC [ RunTime:0.008865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19527146 LIMIT 2 [ RunTime:0.003900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19527146 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778619 LIMIT 5 [ RunTime:0.015285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778619 ORDER BY `minOrder` ASC [ RunTime:0.011261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18778619 ORDER BY `unit` DESC [ RunTime:0.008632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18778619 LIMIT 2 [ RunTime:0.008938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18778619 ORDER BY `minOrder` ASC [ RunTime:0.007975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17504495 LIMIT 5 [ RunTime:0.009778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17504495 ORDER BY `minOrder` ASC [ RunTime:0.012267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17504495 ORDER BY `unit` DESC [ RunTime:0.000858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17504495 LIMIT 2 [ RunTime:0.007944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17504495 ORDER BY `minOrder` ASC [ RunTime:0.004547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502988 LIMIT 5 [ RunTime:0.003493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502988 ORDER BY `minOrder` ASC [ RunTime:0.000820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17502988 ORDER BY `unit` DESC [ RunTime:0.003169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17502988 LIMIT 2 [ RunTime:0.016327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502988 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502406 LIMIT 5 [ RunTime:0.005057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502406 ORDER BY `minOrder` ASC [ RunTime:0.012670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17502406 ORDER BY `unit` DESC [ RunTime:0.005764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17502406 LIMIT 2 [ RunTime:0.001011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17502406 ORDER BY `minOrder` ASC [ RunTime:0.000839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693050 LIMIT 5 [ RunTime:0.001248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693050 ORDER BY `minOrder` ASC [ RunTime:0.006436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14693050 ORDER BY `unit` DESC [ RunTime:0.005297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14693050 LIMIT 2 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14693050 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292336 LIMIT 5 [ RunTime:0.001140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292336 ORDER BY `minOrder` ASC [ RunTime:0.010988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292336 ORDER BY `unit` DESC [ RunTime:0.006214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292336 LIMIT 2 [ RunTime:0.001579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292336 ORDER BY `minOrder` ASC [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292194 LIMIT 5 [ RunTime:0.001786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292194 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13292194 ORDER BY `unit` DESC [ RunTime:0.002170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13292194 LIMIT 2 [ RunTime:0.006385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13292194 ORDER BY `minOrder` ASC [ RunTime:0.002814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288295 LIMIT 5 [ RunTime:0.011030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288295 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13288295 ORDER BY `unit` DESC [ RunTime:0.011866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13288295 LIMIT 2 [ RunTime:0.013418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13288295 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285405 LIMIT 5 [ RunTime:0.001029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285405 ORDER BY `minOrder` ASC [ RunTime:0.009973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13285405 ORDER BY `unit` DESC [ RunTime:0.012606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13285405 LIMIT 2 [ RunTime:0.011066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285405 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12180800 LIMIT 5 [ RunTime:0.001062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180800 ORDER BY `minOrder` ASC [ RunTime:0.004115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12180800 ORDER BY `unit` DESC [ RunTime:0.000615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12180800 LIMIT 2 [ RunTime:0.005280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12180800 ORDER BY `minOrder` ASC [ RunTime:0.016728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027961 LIMIT 5 [ RunTime:0.005361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027961 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12027961 ORDER BY `unit` DESC [ RunTime:0.011997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12027961 LIMIT 2 [ RunTime:0.000658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12027961 ORDER BY `minOrder` ASC [ RunTime:0.013224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017645 LIMIT 5 [ RunTime:0.008022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017645 ORDER BY `minOrder` ASC [ RunTime:0.008850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12017645 ORDER BY `unit` DESC [ RunTime:0.005008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12017645 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12017645 ORDER BY `minOrder` ASC [ RunTime:0.004477s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002110s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63335152 LIMIT 5 [ RunTime:0.003259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335152 ORDER BY `minOrder` ASC [ RunTime:0.000850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63335152 ORDER BY `unit` DESC [ RunTime:0.003316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63335152 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63335152 ORDER BY `minOrder` ASC [ RunTime:0.009618s ]
select * from pdf where partno='6034330' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005634s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034330' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015612s ]
SELECT `id` FROM `stock` WHERE `id` <> 63335152 AND `partno` = '6034330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18784251 [ RunTime:0.005108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343060 LIMIT 5 [ RunTime:0.011060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343060 ORDER BY `minOrder` ASC [ RunTime:0.010521s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343060 ORDER BY `unit` DESC [ RunTime:0.003579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343060 LIMIT 2 [ RunTime:0.013421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343060 ORDER BY `minOrder` ASC [ RunTime:0.006979s ]
select * from pdf where partno='6034337' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034337' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006510s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343060 AND `partno` = '6034337' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18778619 [ RunTime:0.012041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62203413 LIMIT 5 [ RunTime:0.025538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62203413 ORDER BY `minOrder` ASC [ RunTime:0.002301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62203413 ORDER BY `unit` DESC [ RunTime:0.010872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62203413 LIMIT 2 [ RunTime:0.003849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62203413 ORDER BY `minOrder` ASC [ RunTime:0.001339s ]
select * from pdf where partno='6034394' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001307s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034394' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003159s ]
SELECT `id` FROM `stock` WHERE `id` <> 62203413 AND `partno` = '6034394' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17504495 [ RunTime:0.000699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62201056 LIMIT 5 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201056 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62201056 ORDER BY `unit` DESC [ RunTime:0.003520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62201056 LIMIT 2 [ RunTime:0.004920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201056 ORDER BY `minOrder` ASC [ RunTime:0.002638s ]
select * from pdf where partno='6034392' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034392' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011423s ]
SELECT `id` FROM `stock` WHERE `id` <> 62201056 AND `partno` = '6034392' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14693050 [ RunTime:0.010571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62201050 LIMIT 5 [ RunTime:0.007865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201050 ORDER BY `minOrder` ASC [ RunTime:0.014691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62201050 ORDER BY `unit` DESC [ RunTime:0.002950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62201050 LIMIT 2 [ RunTime:0.006974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62201050 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='6034393' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034393' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024099s ]
SELECT `id` FROM `stock` WHERE `id` <> 62201050 AND `partno` = '6034393' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.007544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502988 [ RunTime:0.009035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62200152 LIMIT 5 [ RunTime:0.010943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62200152 ORDER BY `minOrder` ASC [ RunTime:0.009359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62200152 ORDER BY `unit` DESC [ RunTime:0.001943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62200152 LIMIT 2 [ RunTime:0.000997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62200152 ORDER BY `minOrder` ASC [ RunTime:0.002428s ]
select * from pdf where partno='6034391' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034391' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004496s ]
SELECT `id` FROM `stock` WHERE `id` <> 62200152 AND `partno` = '6034391' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.008464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17502406 [ RunTime:0.011252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32698906 LIMIT 5 [ RunTime:0.001872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698906 ORDER BY `minOrder` ASC [ RunTime:0.016873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32698906 ORDER BY `unit` DESC [ RunTime:0.012144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32698906 LIMIT 2 [ RunTime:0.011077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32698906 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
select * from pdf where partno='6034361' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034361' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32698906 AND `partno` = '6034361' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12027961 [ RunTime:0.014391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32688643 LIMIT 5 [ RunTime:0.002344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32688643 ORDER BY `minOrder` ASC [ RunTime:0.012049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32688643 ORDER BY `unit` DESC [ RunTime:0.008400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32688643 LIMIT 2 [ RunTime:0.000827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32688643 ORDER BY `minOrder` ASC [ RunTime:0.003585s ]
select * from pdf where partno='6034363' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034363' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 32688643 AND `partno` = '6034363' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32612133 LIMIT 5 [ RunTime:0.003235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32612133 ORDER BY `minOrder` ASC [ RunTime:0.002756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32612133 ORDER BY `unit` DESC [ RunTime:0.002631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32612133 LIMIT 2 [ RunTime:0.009209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32612133 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
select * from pdf where partno='6034312' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034312' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003133s ]
SELECT `id` FROM `stock` WHERE `id` <> 32612133 AND `partno` = '6034312' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13292336 [ RunTime:0.013660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32514941 LIMIT 5 [ RunTime:0.010420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514941 ORDER BY `minOrder` ASC [ RunTime:0.010891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32514941 ORDER BY `unit` DESC [ RunTime:0.000578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32514941 LIMIT 2 [ RunTime:0.003528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32514941 ORDER BY `minOrder` ASC [ RunTime:0.006925s ]
select * from pdf where partno='6034362' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034362' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027766s ]
SELECT `id` FROM `stock` WHERE `id` <> 32514941 AND `partno` = '6034362' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13288295 [ RunTime:0.000942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32421052 LIMIT 5 [ RunTime:0.012696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421052 ORDER BY `minOrder` ASC [ RunTime:0.015045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32421052 ORDER BY `unit` DESC [ RunTime:0.008916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32421052 LIMIT 2 [ RunTime:0.003693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32421052 ORDER BY `minOrder` ASC [ RunTime:0.004927s ]
select * from pdf where partno='6034332' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000673s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034332' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.010121s ]
SELECT `id` FROM `stock` WHERE `id` <> 32421052 AND `partno` = '6034332' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015277s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12017645 [ RunTime:0.018722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32401033 LIMIT 5 [ RunTime:0.002122s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401033 ORDER BY `minOrder` ASC [ RunTime:0.001139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32401033 ORDER BY `unit` DESC [ RunTime:0.006342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32401033 LIMIT 2 [ RunTime:0.004517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32401033 ORDER BY `minOrder` ASC [ RunTime:0.004405s ]
select * from pdf where partno='6034331' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034331' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004869s ]
SELECT `id` FROM `stock` WHERE `id` <> 32401033 AND `partno` = '6034331' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32377693 LIMIT 5 [ RunTime:0.008578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32377693 ORDER BY `minOrder` ASC [ RunTime:0.002747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32377693 ORDER BY `unit` DESC [ RunTime:0.011024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32377693 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32377693 ORDER BY `minOrder` ASC [ RunTime:0.000753s ]
select * from pdf where partno='6034359' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6034359' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005835s ]
SELECT `id` FROM `stock` WHERE `id` <> 32377693 AND `partno` = '6034359' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001008s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009978s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019620s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003649s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003009s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001320s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004405s ]
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 '60343%' OR `brand` LIKE '60343%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008355s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60343%' OR `brand` LIKE '60343%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006634s ]