SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001303s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=hcpl-3700&search=1' [ RunTime:0.014100s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001615s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.010372s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001688s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.035731s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001805s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001262s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001632s ]
SELECT * FROM `stock_search` WHERE `partno` = 'hcpl-3700' LIMIT 1 [ RunTime:0.031953s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-19 02:31:57' WHERE `partno` = 'hcpl-3700' [ RunTime:0.032453s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002980s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037862s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170877 LIMIT 5 [ RunTime:0.060427s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170877 ORDER BY `minOrder` ASC [ RunTime:0.034329s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170877 ORDER BY `unit` DESC [ RunTime:0.020899s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170877 LIMIT 2 [ RunTime:0.016397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170877 ORDER BY `minOrder` ASC [ RunTime:0.035746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690710 LIMIT 5 [ RunTime:0.056677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690710 ORDER BY `minOrder` ASC [ RunTime:0.066382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690710 ORDER BY `unit` DESC [ RunTime:0.070189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690710 LIMIT 2 [ RunTime:0.033671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690710 ORDER BY `minOrder` ASC [ RunTime:0.019793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690712 LIMIT 5 [ RunTime:0.035734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690712 ORDER BY `minOrder` ASC [ RunTime:0.054414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690712 ORDER BY `unit` DESC [ RunTime:0.038135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690712 LIMIT 2 [ RunTime:0.046211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690712 ORDER BY `minOrder` ASC [ RunTime:0.025840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694594 LIMIT 5 [ RunTime:0.057125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694594 ORDER BY `minOrder` ASC [ RunTime:0.059315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694594 ORDER BY `unit` DESC [ RunTime:0.021888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694594 LIMIT 2 [ RunTime:0.045435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694594 ORDER BY `minOrder` ASC [ RunTime:0.030489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694593 LIMIT 5 [ RunTime:0.019194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694593 ORDER BY `minOrder` ASC [ RunTime:0.055292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694593 ORDER BY `unit` DESC [ RunTime:0.052565s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694593 LIMIT 2 [ RunTime:0.009434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694593 ORDER BY `minOrder` ASC [ RunTime:0.014124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694546 LIMIT 5 [ RunTime:0.003164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694546 ORDER BY `minOrder` ASC [ RunTime:0.013833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694546 ORDER BY `unit` DESC [ RunTime:0.005826s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694546 LIMIT 2 [ RunTime:0.001580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694546 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694545 LIMIT 5 [ RunTime:0.000470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694545 ORDER BY `minOrder` ASC [ RunTime:0.013957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694545 ORDER BY `unit` DESC [ RunTime:0.006545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694545 LIMIT 2 [ RunTime:0.004430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694545 ORDER BY `minOrder` ASC [ RunTime:0.002191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694544 LIMIT 5 [ RunTime:0.000860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694544 ORDER BY `minOrder` ASC [ RunTime:0.001931s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694544 ORDER BY `unit` DESC [ RunTime:0.000793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694544 LIMIT 2 [ RunTime:0.000786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694544 ORDER BY `minOrder` ASC [ RunTime:0.002590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691378 LIMIT 5 [ RunTime:0.005127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691378 ORDER BY `minOrder` ASC [ RunTime:0.001483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18691378 ORDER BY `unit` DESC [ RunTime:0.005982s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18691378 LIMIT 2 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18691378 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18688459 LIMIT 5 [ RunTime:0.001287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18688459 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18688459 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18688459 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18688459 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18688435 LIMIT 5 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18688435 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18688435 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18688435 LIMIT 2 [ RunTime:0.007409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18688435 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204690 LIMIT 5 [ RunTime:0.000853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204690 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204690 ORDER BY `unit` DESC [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204690 LIMIT 2 [ RunTime:0.004526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204690 ORDER BY `minOrder` ASC [ RunTime:0.003413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204689 LIMIT 5 [ RunTime:0.010371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204689 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204689 ORDER BY `unit` DESC [ RunTime:0.002485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204689 LIMIT 2 [ RunTime:0.000623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204689 ORDER BY `minOrder` ASC [ RunTime:0.002372s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050359 LIMIT 5 [ RunTime:0.007394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050359 ORDER BY `minOrder` ASC [ RunTime:0.009154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050359 ORDER BY `unit` DESC [ RunTime:0.003702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050359 LIMIT 2 [ RunTime:0.003775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050359 ORDER BY `minOrder` ASC [ RunTime:0.003298s ]
select * from pdf where partno='hcpl-3700-300e' and brandshort='broadcom / avago' limit 1 [ RunTime:0.011215s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003141s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hcpl-3700-300e' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.020322s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050359 AND `partno` = 'hcpl-3700-300e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom / avago%' ) [ RunTime:0.020706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050752 LIMIT 5 [ RunTime:0.010990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050752 ORDER BY `minOrder` ASC [ RunTime:0.004732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050752 ORDER BY `unit` DESC [ RunTime:0.001618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050752 LIMIT 2 [ RunTime:0.009940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050752 ORDER BY `minOrder` ASC [ RunTime:0.005485s ]
select * from pdf where partno='hcpl-3700' and brandshort='broadcom / avago' limit 1 [ RunTime:0.019972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'hcpl-3700' OR `brand` LIKE 'broadcom / avago%' ) ) LIMIT 1 [ RunTime:0.012843s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050752 AND `partno` = 'hcpl-3700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom / avago%' ) [ RunTime:0.002045s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260538 LIMIT 5 [ RunTime:0.004142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260538 ORDER BY `minOrder` ASC [ RunTime:0.001220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260538 ORDER BY `unit` DESC [ RunTime:0.012384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260538 LIMIT 2 [ RunTime:0.012228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260538 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
select * from pdf where partno='HCPL-3700-300E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.011843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-300E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.018170s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260538 AND `partno` = 'HCPL-3700-300E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.006131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690712 [ RunTime:0.022347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64259856 LIMIT 5 [ RunTime:0.016215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259856 ORDER BY `minOrder` ASC [ RunTime:0.014394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64259856 ORDER BY `unit` DESC [ RunTime:0.019239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64259856 LIMIT 2 [ RunTime:0.020698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259856 ORDER BY `minOrder` ASC [ RunTime:0.010497s ]
select * from pdf where partno='HCPL-3700-500E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.013834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-500E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.030587s ]
SELECT `id` FROM `stock` WHERE `id` <> 64259856 AND `partno` = 'HCPL-3700-500E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.022930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18691378 [ RunTime:0.020755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64259859 LIMIT 5 [ RunTime:0.024672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259859 ORDER BY `minOrder` ASC [ RunTime:0.009284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64259859 ORDER BY `unit` DESC [ RunTime:0.036870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64259859 LIMIT 2 [ RunTime:0.010413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64259859 ORDER BY `minOrder` ASC [ RunTime:0.011724s ]
select * from pdf where partno='HCPL-3700-000E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.012921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-000E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.011220s ]
SELECT `id` FROM `stock` WHERE `id` <> 64259859 AND `partno` = 'HCPL-3700-000E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.024803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690710 [ RunTime:0.011072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262406 LIMIT 5 [ RunTime:0.009589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262406 ORDER BY `minOrder` ASC [ RunTime:0.008630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262406 ORDER BY `unit` DESC [ RunTime:0.019274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262406 LIMIT 2 [ RunTime:0.025962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262406 ORDER BY `minOrder` ASC [ RunTime:0.003864s ]
select * from pdf where partno='HCPL-3700-000ME' and brandshort='Flip Electronics' limit 1 [ RunTime:0.015362s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-000ME' OR `brand` LIKE 'Flip Electronics%' ) ) LIMIT 1 [ RunTime:0.019561s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262406 AND `partno` = 'HCPL-3700-000ME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flip electronics%' ) [ RunTime:0.032207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170877 [ RunTime:0.039333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270280 LIMIT 5 [ RunTime:0.033224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270280 ORDER BY `minOrder` ASC [ RunTime:0.032273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270280 ORDER BY `unit` DESC [ RunTime:0.022161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270280 LIMIT 2 [ RunTime:0.028631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270280 ORDER BY `minOrder` ASC [ RunTime:0.023376s ]
select * from pdf where partno='HCPL-3700#300' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.014341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700#300' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.015703s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270280 AND `partno` = 'HCPL-3700#300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.048804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694594 [ RunTime:0.040599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270278 LIMIT 5 [ RunTime:0.012952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270278 ORDER BY `minOrder` ASC [ RunTime:0.010468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270278 ORDER BY `unit` DESC [ RunTime:0.026588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270278 LIMIT 2 [ RunTime:0.021070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270278 ORDER BY `minOrder` ASC [ RunTime:0.022130s ]
select * from pdf where partno='HCPL-3700' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.005870s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.019210s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270278 AND `partno` = 'HCPL-3700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.004215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694593 [ RunTime:0.035290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270162 LIMIT 5 [ RunTime:0.017903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270162 ORDER BY `minOrder` ASC [ RunTime:0.016870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270162 ORDER BY `unit` DESC [ RunTime:0.021077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270162 LIMIT 2 [ RunTime:0.015747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270162 ORDER BY `minOrder` ASC [ RunTime:0.012132s ]
select * from pdf where partno='HCPL-3700-560E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.017075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-560E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.020146s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270162 AND `partno` = 'HCPL-3700-560E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.028924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694545 [ RunTime:0.033229s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270161 LIMIT 5 [ RunTime:0.036526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270161 ORDER BY `minOrder` ASC [ RunTime:0.037671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270161 ORDER BY `unit` DESC [ RunTime:0.004609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270161 LIMIT 2 [ RunTime:0.020909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270161 ORDER BY `minOrder` ASC [ RunTime:0.005563s ]
select * from pdf where partno='HCPL-3700-360E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.004072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-360E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.036298s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270161 AND `partno` = 'HCPL-3700-360E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.007753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204690 [ RunTime:0.006868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270160 LIMIT 5 [ RunTime:0.023029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270160 ORDER BY `minOrder` ASC [ RunTime:0.005926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270160 ORDER BY `unit` DESC [ RunTime:0.014118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270160 LIMIT 2 [ RunTime:0.016170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270160 ORDER BY `minOrder` ASC [ RunTime:0.001238s ]
select * from pdf where partno='HCPL-3700-320E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.013586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-320E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.018522s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270160 AND `partno` = 'HCPL-3700-320E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.027113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204689 [ RunTime:0.028093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270159 LIMIT 5 [ RunTime:0.045770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270159 ORDER BY `minOrder` ASC [ RunTime:0.026593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270159 ORDER BY `unit` DESC [ RunTime:0.106504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270159 LIMIT 2 [ RunTime:0.030434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270159 ORDER BY `minOrder` ASC [ RunTime:0.018770s ]
select * from pdf where partno='HCPL-3700-520E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.043299s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-520E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.055372s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270159 AND `partno` = 'HCPL-3700-520E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.029335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694544 [ RunTime:0.018186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64270155 LIMIT 5 [ RunTime:0.021466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270155 ORDER BY `minOrder` ASC [ RunTime:0.042443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64270155 ORDER BY `unit` DESC [ RunTime:0.044382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64270155 LIMIT 2 [ RunTime:0.023796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64270155 ORDER BY `minOrder` ASC [ RunTime:0.016888s ]
select * from pdf where partno='HCPL-3700-020E' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.022038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCPL-3700-020E' OR `brand` LIKE 'Broadcom Limited%' ) ) LIMIT 1 [ RunTime:0.036202s ]
SELECT `id` FROM `stock` WHERE `id` <> 64270155 AND `partno` = 'HCPL-3700-020E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%broadcom limited%' ) [ RunTime:0.030115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694546 [ RunTime:0.036205s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066763s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070483s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023587s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028244s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045328s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061044s ]
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 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021074s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'hcpl-3700%' OR `brand` LIKE 'hcpl-3700%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.024331s ]