SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001147s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=4820&search=1' [ RunTime:0.003468s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001834s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005370s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002421s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.001102s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001547s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002596s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001207s ]
SELECT * FROM `stock_search` WHERE `partno` = '4820' LIMIT 1 [ RunTime:0.005434s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-16 20:54:31' WHERE `partno` = '4820' [ RunTime:0.004378s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001983s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016041s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16808142 LIMIT 5 [ RunTime:0.013803s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16808142 ORDER BY `minOrder` ASC [ RunTime:0.011294s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.020488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16808142 ORDER BY `unit` DESC [ RunTime:0.030766s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.036056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16808142 LIMIT 2 [ RunTime:0.023652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16808142 ORDER BY `minOrder` ASC [ RunTime:0.023091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13190919 LIMIT 5 [ RunTime:0.024914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190919 ORDER BY `minOrder` ASC [ RunTime:0.035702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13190919 ORDER BY `unit` DESC [ RunTime:0.022709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13190919 LIMIT 2 [ RunTime:0.040694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190919 ORDER BY `minOrder` ASC [ RunTime:0.029383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13190920 LIMIT 5 [ RunTime:0.007270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190920 ORDER BY `minOrder` ASC [ RunTime:0.000533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13190920 ORDER BY `unit` DESC [ RunTime:0.011372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13190920 LIMIT 2 [ RunTime:0.021934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13190920 ORDER BY `minOrder` ASC [ RunTime:0.006642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16808984 LIMIT 5 [ RunTime:0.021559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16808984 ORDER BY `minOrder` ASC [ RunTime:0.001742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16808984 ORDER BY `unit` DESC [ RunTime:0.013130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16808984 LIMIT 2 [ RunTime:0.006211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16808984 ORDER BY `minOrder` ASC [ RunTime:0.041128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317597 LIMIT 5 [ RunTime:0.055591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317597 ORDER BY `minOrder` ASC [ RunTime:0.037670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13317597 ORDER BY `unit` DESC [ RunTime:0.060108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13317597 LIMIT 2 [ RunTime:0.024115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317597 ORDER BY `minOrder` ASC [ RunTime:0.014512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17896130 LIMIT 5 [ RunTime:0.036063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17896130 ORDER BY `minOrder` ASC [ RunTime:0.054755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17896130 ORDER BY `unit` DESC [ RunTime:0.042801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17896130 LIMIT 2 [ RunTime:0.060948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17896130 ORDER BY `minOrder` ASC [ RunTime:0.017818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14078123 LIMIT 5 [ RunTime:0.027954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14078123 ORDER BY `minOrder` ASC [ RunTime:0.037906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14078123 ORDER BY `unit` DESC [ RunTime:0.067945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14078123 LIMIT 2 [ RunTime:0.064000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14078123 ORDER BY `minOrder` ASC [ RunTime:0.011759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18977870 LIMIT 5 [ RunTime:0.037773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18977870 ORDER BY `minOrder` ASC [ RunTime:0.014173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18977870 ORDER BY `unit` DESC [ RunTime:0.008072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18977870 LIMIT 2 [ RunTime:0.017881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18977870 ORDER BY `minOrder` ASC [ RunTime:0.018759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196307 LIMIT 5 [ RunTime:0.028928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196307 ORDER BY `minOrder` ASC [ RunTime:0.023747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14196307 ORDER BY `unit` DESC [ RunTime:0.020463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14196307 LIMIT 2 [ RunTime:0.018927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14196307 ORDER BY `minOrder` ASC [ RunTime:0.007433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048833 LIMIT 5 [ RunTime:0.015685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048833 ORDER BY `minOrder` ASC [ RunTime:0.013311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17048833 ORDER BY `unit` DESC [ RunTime:0.020819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17048833 LIMIT 2 [ RunTime:0.012043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17048833 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973970 LIMIT 5 [ RunTime:0.006560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18973970 ORDER BY `minOrder` ASC [ RunTime:0.000623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18973970 ORDER BY `unit` DESC [ RunTime:0.008632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18973970 LIMIT 2 [ RunTime:0.009616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18973970 ORDER BY `minOrder` ASC [ RunTime:0.008335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13466436 LIMIT 5 [ RunTime:0.004942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13466436 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13466436 ORDER BY `unit` DESC [ RunTime:0.000456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13466436 LIMIT 2 [ RunTime:0.023366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13466436 ORDER BY `minOrder` ASC [ RunTime:0.005472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973969 LIMIT 5 [ RunTime:0.004494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18973969 ORDER BY `minOrder` ASC [ RunTime:0.007833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18973969 ORDER BY `unit` DESC [ RunTime:0.007631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18973969 LIMIT 2 [ RunTime:0.007700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18973969 ORDER BY `minOrder` ASC [ RunTime:0.015699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982314 LIMIT 5 [ RunTime:0.013230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982314 ORDER BY `minOrder` ASC [ RunTime:0.009874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982314 ORDER BY `unit` DESC [ RunTime:0.031019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982314 LIMIT 2 [ RunTime:0.010413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982314 ORDER BY `minOrder` ASC [ RunTime:0.007022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754790 LIMIT 5 [ RunTime:0.010492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754790 ORDER BY `minOrder` ASC [ RunTime:0.009731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754790 ORDER BY `unit` DESC [ RunTime:0.011042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754790 LIMIT 2 [ RunTime:0.018794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754790 ORDER BY `minOrder` ASC [ RunTime:0.008510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720138 LIMIT 5 [ RunTime:0.003435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720138 ORDER BY `minOrder` ASC [ RunTime:0.009817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720138 ORDER BY `unit` DESC [ RunTime:0.013548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720138 LIMIT 2 [ RunTime:0.025678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720138 ORDER BY `minOrder` ASC [ RunTime:0.004418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910268 LIMIT 5 [ RunTime:0.003528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910268 ORDER BY `minOrder` ASC [ RunTime:0.011072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910268 ORDER BY `unit` DESC [ RunTime:0.025037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910268 LIMIT 2 [ RunTime:0.014199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910268 ORDER BY `minOrder` ASC [ RunTime:0.005765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17910267 LIMIT 5 [ RunTime:0.023955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910267 ORDER BY `minOrder` ASC [ RunTime:0.002031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17910267 ORDER BY `unit` DESC [ RunTime:0.010821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17910267 LIMIT 2 [ RunTime:0.003243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17910267 ORDER BY `minOrder` ASC [ RunTime:0.000641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17909970 LIMIT 5 [ RunTime:0.001987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17909970 ORDER BY `minOrder` ASC [ RunTime:0.003238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17909970 ORDER BY `unit` DESC [ RunTime:0.000679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17909970 LIMIT 2 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17909970 ORDER BY `minOrder` ASC [ RunTime:0.009985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17909969 LIMIT 5 [ RunTime:0.004768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17909969 ORDER BY `minOrder` ASC [ RunTime:0.001871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17909969 ORDER BY `unit` DESC [ RunTime:0.006753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17909969 LIMIT 2 [ RunTime:0.004508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17909969 ORDER BY `minOrder` ASC [ RunTime:0.000385s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255919 LIMIT 5 [ RunTime:0.000803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255919 ORDER BY `minOrder` ASC [ RunTime:0.009231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255919 ORDER BY `unit` DESC [ RunTime:0.012196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255919 LIMIT 2 [ RunTime:0.013815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255919 ORDER BY `minOrder` ASC [ RunTime:0.004427s ]
select * from pdf where partno='4820-3004-cp' and brandshort='3m electronic solutions division' limit 1 [ RunTime:0.001485s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820-3004-cp' OR `brand` LIKE '3m electronic solutions division%' ) ) LIMIT 1 [ RunTime:0.004083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129006 LIMIT 5 [ RunTime:0.009941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129006 ORDER BY `minOrder` ASC [ RunTime:0.027266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129006 ORDER BY `unit` DESC [ RunTime:0.001722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129006 LIMIT 2 [ RunTime:0.007550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129006 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
select * from pdf where partno='482009514001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001147s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482009514001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.007564s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129006 AND `partno` = '482009514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.015470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982314 [ RunTime:0.026202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129010 LIMIT 5 [ RunTime:0.010444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129010 ORDER BY `minOrder` ASC [ RunTime:0.005849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129010 ORDER BY `unit` DESC [ RunTime:0.014434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129010 LIMIT 2 [ RunTime:0.011964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129010 ORDER BY `minOrder` ASC [ RunTime:0.020798s ]
select * from pdf where partno='482020514001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.003860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482020514001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.013757s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129010 AND `partno` = '482020514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.008827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196307 [ RunTime:0.021626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129011 LIMIT 5 [ RunTime:0.026713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129011 ORDER BY `minOrder` ASC [ RunTime:0.009213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129011 ORDER BY `unit` DESC [ RunTime:0.007644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129011 LIMIT 2 [ RunTime:0.023301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129011 ORDER BY `minOrder` ASC [ RunTime:0.005396s ]
select * from pdf where partno='482024764004' and brandshort='wurth elektronik' limit 1 [ RunTime:0.025365s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482024764004' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.014673s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129011 AND `partno` = '482024764004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.013825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973969 [ RunTime:0.011215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129009 LIMIT 5 [ RunTime:0.011062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129009 ORDER BY `minOrder` ASC [ RunTime:0.041615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129009 ORDER BY `unit` DESC [ RunTime:0.032729s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129009 LIMIT 2 [ RunTime:0.014132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129009 ORDER BY `minOrder` ASC [ RunTime:0.005471s ]
select * from pdf where partno='482016564002' and brandshort='wurth elektronik' limit 1 [ RunTime:0.014176s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482016564002' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.027969s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129009 AND `partno` = '482016564002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.025158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973970 [ RunTime:0.029143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129008 LIMIT 5 [ RunTime:0.021551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129008 ORDER BY `minOrder` ASC [ RunTime:0.052065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129008 ORDER BY `unit` DESC [ RunTime:0.043657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129008 LIMIT 2 [ RunTime:0.045358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129008 ORDER BY `minOrder` ASC [ RunTime:0.021225s ]
select * from pdf where partno='482016514001' and brandshort='wurth elektronik' limit 1 [ RunTime:0.015459s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482016514001' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.034675s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129008 AND `partno` = '482016514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.033357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18977870 [ RunTime:0.051005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51129007 LIMIT 5 [ RunTime:0.005100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129007 ORDER BY `minOrder` ASC [ RunTime:0.025663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51129007 ORDER BY `unit` DESC [ RunTime:0.025658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51129007 LIMIT 2 [ RunTime:0.018392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51129007 ORDER BY `minOrder` ASC [ RunTime:0.024678s ]
select * from pdf where partno='482012714003' and brandshort='wurth elektronik' limit 1 [ RunTime:0.007288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482012714003' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.016022s ]
SELECT `id` FROM `stock` WHERE `id` <> 51129007 AND `partno` = '482012714003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.024994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048833 [ RunTime:0.008710s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32799124 LIMIT 5 [ RunTime:0.023334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32799124 ORDER BY `minOrder` ASC [ RunTime:0.058136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32799124 ORDER BY `unit` DESC [ RunTime:0.027582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32799124 LIMIT 2 [ RunTime:0.044146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32799124 ORDER BY `minOrder` ASC [ RunTime:0.012538s ]
select * from pdf where partno='4820P-1-102LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.018934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820P-1-102LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.031700s ]
SELECT `id` FROM `stock` WHERE `id` <> 32799124 AND `partno` = '4820P-1-102LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.054735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16808142 [ RunTime:0.026707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60974347 LIMIT 5 [ RunTime:0.053669s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974347 ORDER BY `minOrder` ASC [ RunTime:0.031834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60974347 ORDER BY `unit` DESC [ RunTime:0.024876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60974347 LIMIT 2 [ RunTime:0.018973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974347 ORDER BY `minOrder` ASC [ RunTime:0.019169s ]
select * from pdf where partno='4820-3004-CP' and brandshort='3M' limit 1 [ RunTime:0.015043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820-3004-CP' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.004951s ]
SELECT `id` FROM `stock` WHERE `id` <> 60974347 AND `partno` = '4820-3004-CP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.013106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13190919 [ RunTime:0.015698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60974387 LIMIT 5 [ RunTime:0.039144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974387 ORDER BY `minOrder` ASC [ RunTime:0.009157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60974387 ORDER BY `unit` DESC [ RunTime:0.038873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60974387 LIMIT 2 [ RunTime:0.052171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60974387 ORDER BY `minOrder` ASC [ RunTime:0.019942s ]
select * from pdf where partno='4820-3000-CP' and brandshort='3M' limit 1 [ RunTime:0.017352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820-3000-CP' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.030514s ]
SELECT `id` FROM `stock` WHERE `id` <> 60974387 AND `partno` = '4820-3000-CP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.024668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13190920 [ RunTime:0.032478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63390387 LIMIT 5 [ RunTime:0.031838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390387 ORDER BY `minOrder` ASC [ RunTime:0.046946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63390387 ORDER BY `unit` DESC [ RunTime:0.016844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63390387 LIMIT 2 [ RunTime:0.005424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63390387 ORDER BY `minOrder` ASC [ RunTime:0.002525s ]
select * from pdf where partno='4820' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.019106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.004216s ]
SELECT `id` FROM `stock` WHERE `id` <> 63390387 AND `partno` = '4820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.039988s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317597 [ RunTime:0.042498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32802121 LIMIT 5 [ RunTime:0.020668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32802121 ORDER BY `minOrder` ASC [ RunTime:0.012132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32802121 ORDER BY `unit` DESC [ RunTime:0.041859s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32802121 LIMIT 2 [ RunTime:0.015877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32802121 ORDER BY `minOrder` ASC [ RunTime:0.007743s ]
select * from pdf where partno='4820P-2-472LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.021411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820P-2-472LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.012443s ]
SELECT `id` FROM `stock` WHERE `id` <> 32802121 AND `partno` = '4820P-2-472LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.046714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16808984 [ RunTime:0.019700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32802122 LIMIT 5 [ RunTime:0.027977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32802122 ORDER BY `minOrder` ASC [ RunTime:0.012259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32802122 ORDER BY `unit` DESC [ RunTime:0.017935s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32802122 LIMIT 2 [ RunTime:0.030833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32802122 ORDER BY `minOrder` ASC [ RunTime:0.019090s ]
select * from pdf where partno='4820P-1-103LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820P-1-103LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.026782s ]
SELECT `id` FROM `stock` WHERE `id` <> 32802122 AND `partno` = '4820P-1-103LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.055819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17896130 [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32799126 LIMIT 5 [ RunTime:0.012626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32799126 ORDER BY `minOrder` ASC [ RunTime:0.017394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32799126 ORDER BY `unit` DESC [ RunTime:0.023406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32799126 LIMIT 2 [ RunTime:0.016430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32799126 ORDER BY `minOrder` ASC [ RunTime:0.005677s ]
select * from pdf where partno='4820P-2-103LF' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.020764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820P-2-103LF' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.016801s ]
SELECT `id` FROM `stock` WHERE `id` <> 32799126 AND `partno` = '4820P-2-103LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.009750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14078123 [ RunTime:0.029984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191385 LIMIT 5 [ RunTime:0.009572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191385 ORDER BY `minOrder` ASC [ RunTime:0.018369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191385 ORDER BY `unit` DESC [ RunTime:0.005217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191385 LIMIT 2 [ RunTime:0.011449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191385 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='482009514001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482009514001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006919s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191385 AND `partno` = '482009514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.002398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982314 [ RunTime:0.011614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191386 LIMIT 5 [ RunTime:0.046567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191386 ORDER BY `minOrder` ASC [ RunTime:0.024547s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191386 ORDER BY `unit` DESC [ RunTime:0.019849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191386 LIMIT 2 [ RunTime:0.027931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191386 ORDER BY `minOrder` ASC [ RunTime:0.010234s ]
select * from pdf where partno='482016514001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.019163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482016514001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.026473s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191386 AND `partno` = '482016514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.030265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18977870 [ RunTime:0.013945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61948230 LIMIT 5 [ RunTime:0.024605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948230 ORDER BY `minOrder` ASC [ RunTime:0.040258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61948230 ORDER BY `unit` DESC [ RunTime:0.063634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61948230 LIMIT 2 [ RunTime:0.018367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948230 ORDER BY `minOrder` ASC [ RunTime:0.025210s ]
select * from pdf where partno='48203-6062' and brandshort='WEC' limit 1 [ RunTime:0.047800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '48203-6062' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.027750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191932 LIMIT 5 [ RunTime:0.017352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191932 ORDER BY `minOrder` ASC [ RunTime:0.027056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191932 ORDER BY `unit` DESC [ RunTime:0.024972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191932 LIMIT 2 [ RunTime:0.044960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191932 ORDER BY `minOrder` ASC [ RunTime:0.023650s ]
select * from pdf where partno='482020514001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.047991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482020514001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006006s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191932 AND `partno` = '482020514001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.030934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14196307 [ RunTime:0.011775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191972 LIMIT 5 [ RunTime:0.004048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191972 ORDER BY `minOrder` ASC [ RunTime:0.014928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191972 ORDER BY `unit` DESC [ RunTime:0.017700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191972 LIMIT 2 [ RunTime:0.012577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191972 ORDER BY `minOrder` ASC [ RunTime:0.003656s ]
select * from pdf where partno='482016564002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482016564002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011711s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191972 AND `partno` = '482016564002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.024477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973970 [ RunTime:0.022504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191973 LIMIT 5 [ RunTime:0.012418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191973 ORDER BY `minOrder` ASC [ RunTime:0.011217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191973 ORDER BY `unit` DESC [ RunTime:0.011955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191973 LIMIT 2 [ RunTime:0.030527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191973 ORDER BY `minOrder` ASC [ RunTime:0.031232s ]
select * from pdf where partno='482012714003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.015370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482012714003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.024240s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191973 AND `partno` = '482012714003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.056411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17048833 [ RunTime:0.003422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58298476 LIMIT 5 [ RunTime:0.017219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298476 ORDER BY `minOrder` ASC [ RunTime:0.018668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58298476 ORDER BY `unit` DESC [ RunTime:0.033686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58298476 LIMIT 2 [ RunTime:0.123088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58298476 ORDER BY `minOrder` ASC [ RunTime:0.026025s ]
select * from pdf where partno='4820' and brandshort='Pololu' limit 1 [ RunTime:0.009692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.032583s ]
SELECT `id` FROM `stock` WHERE `id` <> 58298476 AND `partno` = '4820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.021419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13466436 [ RunTime:0.010730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63191969 LIMIT 5 [ RunTime:0.048569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191969 ORDER BY `minOrder` ASC [ RunTime:0.050204s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63191969 ORDER BY `unit` DESC [ RunTime:0.070404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63191969 LIMIT 2 [ RunTime:0.056633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63191969 ORDER BY `minOrder` ASC [ RunTime:0.020249s ]
select * from pdf where partno='482024764004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.023325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '482024764004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.029760s ]
SELECT `id` FROM `stock` WHERE `id` <> 63191969 AND `partno` = '482024764004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.027238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18973969 [ RunTime:0.032275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60642359 LIMIT 5 [ RunTime:0.039264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642359 ORDER BY `minOrder` ASC [ RunTime:0.037795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60642359 ORDER BY `unit` DESC [ RunTime:0.015544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60642359 LIMIT 2 [ RunTime:0.025054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60642359 ORDER BY `minOrder` ASC [ RunTime:0.026792s ]
select * from pdf where partno='4820' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.018037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.011608s ]
SELECT `id` FROM `stock` WHERE `id` <> 60642359 AND `partno` = '4820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623540 LIMIT 5 [ RunTime:0.003538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623540 ORDER BY `minOrder` ASC [ RunTime:0.086682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623540 ORDER BY `unit` DESC [ RunTime:0.078119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623540 LIMIT 2 [ RunTime:0.037193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623540 ORDER BY `minOrder` ASC [ RunTime:0.005304s ]
select * from pdf where partno='4820.5' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820.5' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.005506s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623540 AND `partno` = '4820.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.026090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623534 LIMIT 5 [ RunTime:0.059733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623534 ORDER BY `minOrder` ASC [ RunTime:0.032108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623534 ORDER BY `unit` DESC [ RunTime:0.029454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623534 LIMIT 2 [ RunTime:0.033768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623534 ORDER BY `minOrder` ASC [ RunTime:0.005440s ]
select * from pdf where partno='4820.9' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.039750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820.9' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.033031s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623534 AND `partno` = '4820.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.053598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623533 LIMIT 5 [ RunTime:0.021088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623533 ORDER BY `minOrder` ASC [ RunTime:0.057446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623533 ORDER BY `unit` DESC [ RunTime:0.021812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623533 LIMIT 2 [ RunTime:0.011607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623533 ORDER BY `minOrder` ASC [ RunTime:0.001375s ]
select * from pdf where partno='4820.8' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.012702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820.8' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.035305s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623533 AND `partno` = '4820.8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.030973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623532 LIMIT 5 [ RunTime:0.015996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623532 ORDER BY `minOrder` ASC [ RunTime:0.043376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623532 ORDER BY `unit` DESC [ RunTime:0.063564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623532 LIMIT 2 [ RunTime:0.019758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623532 ORDER BY `minOrder` ASC [ RunTime:0.005534s ]
select * from pdf where partno='4820.3' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.020564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4820.3' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.013916s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623532 AND `partno` = '4820.3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.037024s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043509s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030548s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022437s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039548s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005708s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051556s ]
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 '4820%' OR `brand` LIKE '4820%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031561s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '4820%' OR `brand` LIKE '4820%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025419s ]