SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001490s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=10928&search=1' [ RunTime:0.001689s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001027s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001521s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001345s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000984s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002308s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001046s ]
SELECT * FROM `stock_search` WHERE `partno` = '10928' LIMIT 1 [ RunTime:0.002075s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 09:23:00' WHERE `partno` = '10928' [ RunTime:0.001639s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001593s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015924s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068332 LIMIT 5 [ RunTime:0.016567s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068332 ORDER BY `minOrder` ASC [ RunTime:0.004820s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12068332 ORDER BY `unit` DESC [ RunTime:0.017703s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12068332 LIMIT 2 [ RunTime:0.010112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12068332 ORDER BY `minOrder` ASC [ RunTime:0.017061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12892159 LIMIT 5 [ RunTime:0.038197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892159 ORDER BY `minOrder` ASC [ RunTime:0.026007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12892159 ORDER BY `unit` DESC [ RunTime:0.005712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12892159 LIMIT 2 [ RunTime:0.033147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12892159 ORDER BY `minOrder` ASC [ RunTime:0.019812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982746 LIMIT 5 [ RunTime:0.010055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982746 ORDER BY `minOrder` ASC [ RunTime:0.049490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982746 ORDER BY `unit` DESC [ RunTime:0.029200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982746 LIMIT 2 [ RunTime:0.058510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982746 ORDER BY `minOrder` ASC [ RunTime:0.015496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982039 LIMIT 5 [ RunTime:0.061769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982039 ORDER BY `minOrder` ASC [ RunTime:0.028559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982039 ORDER BY `unit` DESC [ RunTime:0.044459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982039 LIMIT 2 [ RunTime:0.033904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982039 ORDER BY `minOrder` ASC [ RunTime:0.020187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981505 LIMIT 5 [ RunTime:0.028460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981505 ORDER BY `minOrder` ASC [ RunTime:0.003313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981505 ORDER BY `unit` DESC [ RunTime:0.022299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981505 LIMIT 2 [ RunTime:0.007246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981505 ORDER BY `minOrder` ASC [ RunTime:0.004920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18785757 LIMIT 5 [ RunTime:0.024190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18785757 ORDER BY `minOrder` ASC [ RunTime:0.027337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18785757 ORDER BY `unit` DESC [ RunTime:0.004707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18785757 LIMIT 2 [ RunTime:0.003225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18785757 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18782291 LIMIT 5 [ RunTime:0.005163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18782291 ORDER BY `minOrder` ASC [ RunTime:0.012707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18782291 ORDER BY `unit` DESC [ RunTime:0.011912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18782291 LIMIT 2 [ RunTime:0.003800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18782291 ORDER BY `minOrder` ASC [ RunTime:0.002217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779848 LIMIT 5 [ RunTime:0.020457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779848 ORDER BY `minOrder` ASC [ RunTime:0.006990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18779848 ORDER BY `unit` DESC [ RunTime:0.011433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18779848 LIMIT 2 [ RunTime:0.013062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18779848 ORDER BY `minOrder` ASC [ RunTime:0.007748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772482 LIMIT 5 [ RunTime:0.004231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772482 ORDER BY `minOrder` ASC [ RunTime:0.012919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18772482 ORDER BY `unit` DESC [ RunTime:0.012802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18772482 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18772482 ORDER BY `minOrder` ASC [ RunTime:0.001799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771467 LIMIT 5 [ RunTime:0.014589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771467 ORDER BY `minOrder` ASC [ RunTime:0.010358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18771467 ORDER BY `unit` DESC [ RunTime:0.004412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18771467 LIMIT 2 [ RunTime:0.034376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18771467 ORDER BY `minOrder` ASC [ RunTime:0.010225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705789 LIMIT 5 [ RunTime:0.018217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705789 ORDER BY `minOrder` ASC [ RunTime:0.007137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705789 ORDER BY `unit` DESC [ RunTime:0.009559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705789 LIMIT 2 [ RunTime:0.020030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705789 ORDER BY `minOrder` ASC [ RunTime:0.016286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049381 LIMIT 5 [ RunTime:0.027259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049381 ORDER BY `minOrder` ASC [ RunTime:0.020705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17049381 ORDER BY `unit` DESC [ RunTime:0.005231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17049381 LIMIT 2 [ RunTime:0.017718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17049381 ORDER BY `minOrder` ASC [ RunTime:0.007672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048946 LIMIT 5 [ RunTime:0.012456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048946 ORDER BY `minOrder` ASC [ RunTime:0.014755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17048946 ORDER BY `unit` DESC [ RunTime:0.023759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17048946 LIMIT 2 [ RunTime:0.034898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048946 ORDER BY `minOrder` ASC [ RunTime:0.018396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266322 LIMIT 5 [ RunTime:0.028766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266322 ORDER BY `minOrder` ASC [ RunTime:0.019896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266322 ORDER BY `unit` DESC [ RunTime:0.031658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266322 LIMIT 2 [ RunTime:0.014111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266322 ORDER BY `minOrder` ASC [ RunTime:0.019229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224689 LIMIT 5 [ RunTime:0.018385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224689 ORDER BY `minOrder` ASC [ RunTime:0.042082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15224689 ORDER BY `unit` DESC [ RunTime:0.030023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15224689 LIMIT 2 [ RunTime:0.036351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15224689 ORDER BY `minOrder` ASC [ RunTime:0.007835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185708 LIMIT 5 [ RunTime:0.006679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14185708 ORDER BY `minOrder` ASC [ RunTime:0.047531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14185708 ORDER BY `unit` DESC [ RunTime:0.059986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14185708 LIMIT 2 [ RunTime:0.051032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14185708 ORDER BY `minOrder` ASC [ RunTime:0.021926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030358 LIMIT 5 [ RunTime:0.014850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030358 ORDER BY `minOrder` ASC [ RunTime:0.053044s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12030358 ORDER BY `unit` DESC [ RunTime:0.044535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12030358 LIMIT 2 [ RunTime:0.011229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12030358 ORDER BY `minOrder` ASC [ RunTime:0.002728s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020544s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57743104 LIMIT 5 [ RunTime:0.033941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743104 ORDER BY `minOrder` ASC [ RunTime:0.040035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57743104 ORDER BY `unit` DESC [ RunTime:0.022895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57743104 LIMIT 2 [ RunTime:0.023815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57743104 ORDER BY `minOrder` ASC [ RunTime:0.014595s ]
select * from pdf where partno='10928CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.083607s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002725s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10928CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.049294s ]
SELECT `id` FROM `stock` WHERE `id` <> 57743104 AND `partno` = '10928CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.057342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12068332 [ RunTime:0.043716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63379778 LIMIT 5 [ RunTime:0.060920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63379778 ORDER BY `minOrder` ASC [ RunTime:0.127711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63379778 ORDER BY `unit` DESC [ RunTime:0.041345s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63379778 LIMIT 2 [ RunTime:0.083098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63379778 ORDER BY `minOrder` ASC [ RunTime:0.054118s ]
select * from pdf where partno='10928' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.069976s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10928' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.030916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63348442 LIMIT 5 [ RunTime:0.036415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348442 ORDER BY `minOrder` ASC [ RunTime:0.041186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63348442 ORDER BY `unit` DESC [ RunTime:0.045631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63348442 LIMIT 2 [ RunTime:0.068794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63348442 ORDER BY `minOrder` ASC [ RunTime:0.046641s ]
select * from pdf where partno='1092863' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.047640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092863' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012250s ]
SELECT `id` FROM `stock` WHERE `id` <> 63348442 AND `partno` = '1092863' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18782291 [ RunTime:0.026829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63344850 LIMIT 5 [ RunTime:0.038877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344850 ORDER BY `minOrder` ASC [ RunTime:0.053734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63344850 ORDER BY `unit` DESC [ RunTime:0.076485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63344850 LIMIT 2 [ RunTime:0.104288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63344850 ORDER BY `minOrder` ASC [ RunTime:0.051106s ]
select * from pdf where partno='1092841' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092841' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.045268s ]
SELECT `id` FROM `stock` WHERE `id` <> 63344850 AND `partno` = '1092841' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.051834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18779848 [ RunTime:0.062247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63343303 LIMIT 5 [ RunTime:0.180291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343303 ORDER BY `minOrder` ASC [ RunTime:0.055362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63343303 ORDER BY `unit` DESC [ RunTime:0.051224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63343303 LIMIT 2 [ RunTime:0.051268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63343303 ORDER BY `minOrder` ASC [ RunTime:0.051624s ]
select * from pdf where partno='1092839' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092839' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.062972s ]
SELECT `id` FROM `stock` WHERE `id` <> 63343303 AND `partno` = '1092839' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.059411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15224689 [ RunTime:0.060644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63339135 LIMIT 5 [ RunTime:0.053475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339135 ORDER BY `minOrder` ASC [ RunTime:0.015790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63339135 ORDER BY `unit` DESC [ RunTime:0.024239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63339135 LIMIT 2 [ RunTime:0.063208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63339135 ORDER BY `minOrder` ASC [ RunTime:0.120227s ]
select * from pdf where partno='1092840' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.069834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092840' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.097111s ]
SELECT `id` FROM `stock` WHERE `id` <> 63339135 AND `partno` = '1092840' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.052108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18785757 [ RunTime:0.107637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199919 LIMIT 5 [ RunTime:0.068559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199919 ORDER BY `minOrder` ASC [ RunTime:0.031424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199919 ORDER BY `unit` DESC [ RunTime:0.061520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199919 LIMIT 2 [ RunTime:0.065025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199919 ORDER BY `minOrder` ASC [ RunTime:0.046887s ]
select * from pdf where partno='1092886' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.065173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092886' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.093262s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199919 AND `partno` = '1092886' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982746 [ RunTime:0.068308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63199305 LIMIT 5 [ RunTime:0.119679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199305 ORDER BY `minOrder` ASC [ RunTime:0.037110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63199305 ORDER BY `unit` DESC [ RunTime:0.042018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63199305 LIMIT 2 [ RunTime:0.101044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63199305 ORDER BY `minOrder` ASC [ RunTime:0.081382s ]
select * from pdf where partno='1092866' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.034222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092866' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021574s ]
SELECT `id` FROM `stock` WHERE `id` <> 63199305 AND `partno` = '1092866' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.013565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982039 [ RunTime:0.015710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198586 LIMIT 5 [ RunTime:0.038799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198586 ORDER BY `minOrder` ASC [ RunTime:0.034312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198586 ORDER BY `unit` DESC [ RunTime:0.019552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198586 LIMIT 2 [ RunTime:0.050305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198586 ORDER BY `minOrder` ASC [ RunTime:0.003030s ]
select * from pdf where partno='1092896' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092896' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019349s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198586 AND `partno` = '1092896' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.024986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981505 [ RunTime:0.046309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63198572 LIMIT 5 [ RunTime:0.057537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198572 ORDER BY `minOrder` ASC [ RunTime:0.007046s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63198572 ORDER BY `unit` DESC [ RunTime:0.036409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63198572 LIMIT 2 [ RunTime:0.035058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63198572 ORDER BY `minOrder` ASC [ RunTime:0.017823s ]
select * from pdf where partno='1092867' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.058949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092867' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.015102s ]
SELECT `id` FROM `stock` WHERE `id` <> 63198572 AND `partno` = '1092867' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.028555s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266322 [ RunTime:0.004926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63197854 LIMIT 5 [ RunTime:0.006478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63197854 ORDER BY `minOrder` ASC [ RunTime:0.038051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63197854 ORDER BY `unit` DESC [ RunTime:0.020930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63197854 LIMIT 2 [ RunTime:0.040196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63197854 ORDER BY `minOrder` ASC [ RunTime:0.008090s ]
select * from pdf where partno='1092897' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.018702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092897' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.024849s ]
SELECT `id` FROM `stock` WHERE `id` <> 63197854 AND `partno` = '1092897' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048946 [ RunTime:0.018237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60326808 LIMIT 5 [ RunTime:0.020342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60326808 ORDER BY `minOrder` ASC [ RunTime:0.016998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60326808 ORDER BY `unit` DESC [ RunTime:0.010683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60326808 LIMIT 2 [ RunTime:0.015210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60326808 ORDER BY `minOrder` ASC [ RunTime:0.010108s ]
select * from pdf where partno='1092802' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.009318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092802' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.015612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986823 LIMIT 5 [ RunTime:0.008593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986823 ORDER BY `minOrder` ASC [ RunTime:0.007742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986823 ORDER BY `unit` DESC [ RunTime:0.013596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986823 LIMIT 2 [ RunTime:0.015372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986823 ORDER BY `minOrder` ASC [ RunTime:0.023816s ]
select * from pdf where partno='1092884' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.020479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092884' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018161s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986823 AND `partno` = '1092884' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.015865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17049381 [ RunTime:0.005020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57982730 LIMIT 5 [ RunTime:0.010666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57982730 ORDER BY `minOrder` ASC [ RunTime:0.010304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57982730 ORDER BY `unit` DESC [ RunTime:0.002739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57982730 LIMIT 2 [ RunTime:0.022982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57982730 ORDER BY `minOrder` ASC [ RunTime:0.010545s ]
select * from pdf where partno='1092805' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014173s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092805' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011362s ]
SELECT `id` FROM `stock` WHERE `id` <> 57982730 AND `partno` = '1092805' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18772482 [ RunTime:0.022185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57981068 LIMIT 5 [ RunTime:0.005308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981068 ORDER BY `minOrder` ASC [ RunTime:0.005869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57981068 ORDER BY `unit` DESC [ RunTime:0.023408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57981068 LIMIT 2 [ RunTime:0.025542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57981068 ORDER BY `minOrder` ASC [ RunTime:0.004962s ]
select * from pdf where partno='1092842' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.010720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092842' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006885s ]
SELECT `id` FROM `stock` WHERE `id` <> 57981068 AND `partno` = '1092842' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18771467 [ RunTime:0.006357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57306689 LIMIT 5 [ RunTime:0.011679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57306689 ORDER BY `minOrder` ASC [ RunTime:0.007154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57306689 ORDER BY `unit` DESC [ RunTime:0.014206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57306689 LIMIT 2 [ RunTime:0.010187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57306689 ORDER BY `minOrder` ASC [ RunTime:0.010461s ]
select * from pdf where partno='1092860' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.008648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092860' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016359s ]
SELECT `id` FROM `stock` WHERE `id` <> 57306689 AND `partno` = '1092860' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.009295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14185708 [ RunTime:0.004479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32777737 LIMIT 5 [ RunTime:0.007581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32777737 ORDER BY `minOrder` ASC [ RunTime:0.020443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32777737 ORDER BY `unit` DESC [ RunTime:0.019394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32777737 LIMIT 2 [ RunTime:0.013292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32777737 ORDER BY `minOrder` ASC [ RunTime:0.012945s ]
select * from pdf where partno='1092824' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1092824' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018054s ]
SELECT `id` FROM `stock` WHERE `id` <> 32777737 AND `partno` = '1092824' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12030358 [ RunTime:0.014612s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014335s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007598s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001103s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003716s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002357s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003696s ]
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 '10928%' OR `brand` LIKE '10928%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008994s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10928%' OR `brand` LIKE '10928%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001595s ]