SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001113s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=B6623&search=1' [ RunTime:0.009897s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001377s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000866s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001079s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.001495s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000883s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009088s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.004322s ]
SELECT * FROM `stock_search` WHERE `partno` = 'B6623' LIMIT 1 [ RunTime:0.002270s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 14:49:44' WHERE `partno` = 'B6623' [ RunTime:0.006217s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002673s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024349s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258780 LIMIT 5 [ RunTime:0.016677s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258780 ORDER BY `minOrder` ASC [ RunTime:0.007001s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258780 ORDER BY `unit` DESC [ RunTime:0.016508s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258780 LIMIT 2 [ RunTime:0.006612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258780 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14266142 LIMIT 5 [ RunTime:0.003295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266142 ORDER BY `minOrder` ASC [ RunTime:0.002924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14266142 ORDER BY `unit` DESC [ RunTime:0.000312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14266142 LIMIT 2 [ RunTime:0.008480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14266142 ORDER BY `minOrder` ASC [ RunTime:0.006592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13375763 LIMIT 5 [ RunTime:0.008796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375763 ORDER BY `minOrder` ASC [ RunTime:0.007653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13375763 ORDER BY `unit` DESC [ RunTime:0.020537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13375763 LIMIT 2 [ RunTime:0.015638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375763 ORDER BY `minOrder` ASC [ RunTime:0.013005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13375636 LIMIT 5 [ RunTime:0.017547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375636 ORDER BY `minOrder` ASC [ RunTime:0.011710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13375636 ORDER BY `unit` DESC [ RunTime:0.014617s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13375636 LIMIT 2 [ RunTime:0.018826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375636 ORDER BY `minOrder` ASC [ RunTime:0.021161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260525 LIMIT 5 [ RunTime:0.001581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260525 ORDER BY `minOrder` ASC [ RunTime:0.021863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260525 ORDER BY `unit` DESC [ RunTime:0.011554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260525 LIMIT 2 [ RunTime:0.017579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260525 ORDER BY `minOrder` ASC [ RunTime:0.007963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13379718 LIMIT 5 [ RunTime:0.025010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13379718 ORDER BY `minOrder` ASC [ RunTime:0.030754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13379718 ORDER BY `unit` DESC [ RunTime:0.015386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13379718 LIMIT 2 [ RunTime:0.015068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13379718 ORDER BY `minOrder` ASC [ RunTime:0.012999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263906 LIMIT 5 [ RunTime:0.028085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263906 ORDER BY `minOrder` ASC [ RunTime:0.018947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14263906 ORDER BY `unit` DESC [ RunTime:0.034174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14263906 LIMIT 2 [ RunTime:0.004078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263906 ORDER BY `minOrder` ASC [ RunTime:0.008321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263739 LIMIT 5 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263739 ORDER BY `minOrder` ASC [ RunTime:0.004555s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14263739 ORDER BY `unit` DESC [ RunTime:0.005330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14263739 LIMIT 2 [ RunTime:0.010415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263739 ORDER BY `minOrder` ASC [ RunTime:0.004318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263738 LIMIT 5 [ RunTime:0.016260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263738 ORDER BY `minOrder` ASC [ RunTime:0.004272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14263738 ORDER BY `unit` DESC [ RunTime:0.006795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14263738 LIMIT 2 [ RunTime:0.017086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263738 ORDER BY `minOrder` ASC [ RunTime:0.005484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14259055 LIMIT 5 [ RunTime:0.005031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14259055 ORDER BY `minOrder` ASC [ RunTime:0.025500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14259055 ORDER BY `unit` DESC [ RunTime:0.018779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14259055 LIMIT 2 [ RunTime:0.004108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14259055 ORDER BY `minOrder` ASC [ RunTime:0.003688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258898 LIMIT 5 [ RunTime:0.011409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258898 ORDER BY `minOrder` ASC [ RunTime:0.011466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258898 ORDER BY `unit` DESC [ RunTime:0.043928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258898 LIMIT 2 [ RunTime:0.019020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258898 ORDER BY `minOrder` ASC [ RunTime:0.008567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13378762 LIMIT 5 [ RunTime:0.069903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13378762 ORDER BY `minOrder` ASC [ RunTime:0.057203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13378762 ORDER BY `unit` DESC [ RunTime:0.093542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13378762 LIMIT 2 [ RunTime:0.016541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13378762 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13375908 LIMIT 5 [ RunTime:0.032231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375908 ORDER BY `minOrder` ASC [ RunTime:0.019392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13375908 ORDER BY `unit` DESC [ RunTime:0.056353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13375908 LIMIT 2 [ RunTime:0.019417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375908 ORDER BY `minOrder` ASC [ RunTime:0.026670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13375758 LIMIT 5 [ RunTime:0.030509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375758 ORDER BY `minOrder` ASC [ RunTime:0.015321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13375758 ORDER BY `unit` DESC [ RunTime:0.021399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13375758 LIMIT 2 [ RunTime:0.042227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375758 ORDER BY `minOrder` ASC [ RunTime:0.003421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13375753 LIMIT 5 [ RunTime:0.006432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375753 ORDER BY `minOrder` ASC [ RunTime:0.017742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13375753 ORDER BY `unit` DESC [ RunTime:0.032679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13375753 LIMIT 2 [ RunTime:0.021531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13375753 ORDER BY `minOrder` ASC [ RunTime:0.012307s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51127672 LIMIT 5 [ RunTime:0.009044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127672 ORDER BY `minOrder` ASC [ RunTime:0.014422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51127672 ORDER BY `unit` DESC [ RunTime:0.043897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51127672 LIMIT 2 [ RunTime:0.049354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51127672 ORDER BY `minOrder` ASC [ RunTime:0.008019s ]
select * from pdf where partno='b66230a2010x000' and brandshort='tdk' limit 1 [ RunTime:0.052295s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002656s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'b66230a2010x000' OR `brand` LIKE 'tdk%' ) ) LIMIT 1 [ RunTime:0.013487s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595062 LIMIT 5 [ RunTime:0.016448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595062 ORDER BY `minOrder` ASC [ RunTime:0.039078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595062 ORDER BY `unit` DESC [ RunTime:0.033191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595062 LIMIT 2 [ RunTime:0.029926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595062 ORDER BY `minOrder` ASC [ RunTime:0.013748s ]
select * from pdf where partno='B66232A2010X000' and brandshort='TDK' limit 1 [ RunTime:0.031602s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66232A2010X000' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.060829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595123 LIMIT 5 [ RunTime:0.015385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595123 ORDER BY `minOrder` ASC [ RunTime:0.025030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595123 ORDER BY `unit` DESC [ RunTime:0.024578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595123 LIMIT 2 [ RunTime:0.006557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595123 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
select * from pdf where partno='B66232B1114T001' and brandshort='TDK' limit 1 [ RunTime:0.021455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66232B1114T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.043278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595141 LIMIT 5 [ RunTime:0.017696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595141 ORDER BY `minOrder` ASC [ RunTime:0.048817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595141 ORDER BY `unit` DESC [ RunTime:0.014416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595141 LIMIT 2 [ RunTime:0.017400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595141 ORDER BY `minOrder` ASC [ RunTime:0.003275s ]
select * from pdf where partno='B66230A1114T001' and brandshort='TDK' limit 1 [ RunTime:0.008359s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66230A1114T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.042900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595125 LIMIT 5 [ RunTime:0.021561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595125 ORDER BY `minOrder` ASC [ RunTime:0.021735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595125 ORDER BY `unit` DESC [ RunTime:0.039728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595125 LIMIT 2 [ RunTime:0.051406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595125 ORDER BY `minOrder` ASC [ RunTime:0.048603s ]
select * from pdf where partno='B66232J1112T001' and brandshort='TDK' limit 1 [ RunTime:0.036019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66232J1112T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.042706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57596571 LIMIT 5 [ RunTime:0.004116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57596571 ORDER BY `minOrder` ASC [ RunTime:0.032438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57596571 ORDER BY `unit` DESC [ RunTime:0.006899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57596571 LIMIT 2 [ RunTime:0.009296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57596571 ORDER BY `minOrder` ASC [ RunTime:0.007965s ]
select * from pdf where partno='B66233Q0150K187' and brandshort='TDK' limit 1 [ RunTime:0.012685s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233Q0150K187' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.018512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57596572 LIMIT 5 [ RunTime:0.026088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57596572 ORDER BY `minOrder` ASC [ RunTime:0.021613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57596572 ORDER BY `unit` DESC [ RunTime:0.019707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57596572 LIMIT 2 [ RunTime:0.037650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57596572 ORDER BY `minOrder` ASC [ RunTime:0.004393s ]
select * from pdf where partno='B66233Q0100K187' and brandshort='TDK' limit 1 [ RunTime:0.005840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233Q0100K187' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.019382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595075 LIMIT 5 [ RunTime:0.011246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595075 ORDER BY `minOrder` ASC [ RunTime:0.039496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595075 ORDER BY `unit` DESC [ RunTime:0.009246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595075 LIMIT 2 [ RunTime:0.015808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595075 ORDER BY `minOrder` ASC [ RunTime:0.015517s ]
select * from pdf where partno='B66230A2010X000' and brandshort='TDK' limit 1 [ RunTime:0.026911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66230A2010X000' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.025463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595987 LIMIT 5 [ RunTime:0.048200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595987 ORDER BY `minOrder` ASC [ RunTime:0.034634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595987 ORDER BY `unit` DESC [ RunTime:0.023060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595987 LIMIT 2 [ RunTime:0.025471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595987 ORDER BY `minOrder` ASC [ RunTime:0.005069s ]
select * from pdf where partno='B66233G0000X187' and brandshort='TDK' limit 1 [ RunTime:0.005521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233G0000X187' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.038315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595134 LIMIT 5 [ RunTime:0.007874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595134 ORDER BY `minOrder` ASC [ RunTime:0.025505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595134 ORDER BY `unit` DESC [ RunTime:0.007720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595134 LIMIT 2 [ RunTime:0.011900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595134 ORDER BY `minOrder` ASC [ RunTime:0.031074s ]
select * from pdf where partno='B66230B1114T001' and brandshort='TDK' limit 1 [ RunTime:0.007959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66230B1114T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.034565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57602114 LIMIT 5 [ RunTime:0.030723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57602114 ORDER BY `minOrder` ASC [ RunTime:0.095311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57602114 ORDER BY `unit` DESC [ RunTime:0.025292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57602114 LIMIT 2 [ RunTime:0.073373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57602114 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
select * from pdf where partno='B66233G0000X197' and brandshort='TDK' limit 1 [ RunTime:0.027204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233G0000X197' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.028176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57601699 LIMIT 5 [ RunTime:0.024811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601699 ORDER BY `minOrder` ASC [ RunTime:0.024691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57601699 ORDER BY `unit` DESC [ RunTime:0.029989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57601699 LIMIT 2 [ RunTime:0.005443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601699 ORDER BY `minOrder` ASC [ RunTime:0.003220s ]
select * from pdf where partno='B66233G0250X187' and brandshort='TDK' limit 1 [ RunTime:0.001261s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233G0250X187' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.026800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57601463 LIMIT 5 [ RunTime:0.011721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601463 ORDER BY `minOrder` ASC [ RunTime:0.017951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57601463 ORDER BY `unit` DESC [ RunTime:0.013507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57601463 LIMIT 2 [ RunTime:0.001159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601463 ORDER BY `minOrder` ASC [ RunTime:0.012586s ]
select * from pdf where partno='B66233Q0100K195' and brandshort='TDK' limit 1 [ RunTime:0.002801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233Q0100K195' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.001854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57601462 LIMIT 5 [ RunTime:0.042249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601462 ORDER BY `minOrder` ASC [ RunTime:0.039019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57601462 ORDER BY `unit` DESC [ RunTime:0.017595s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57601462 LIMIT 2 [ RunTime:0.010966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57601462 ORDER BY `minOrder` ASC [ RunTime:0.013157s ]
select * from pdf where partno='B66233Q0150K195' and brandshort='TDK' limit 1 [ RunTime:0.024686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66233Q0150K195' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.022282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595601 LIMIT 5 [ RunTime:0.010298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595601 ORDER BY `minOrder` ASC [ RunTime:0.010499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595601 ORDER BY `unit` DESC [ RunTime:0.002248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595601 LIMIT 2 [ RunTime:0.019552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595601 ORDER BY `minOrder` ASC [ RunTime:0.016051s ]
select * from pdf where partno='B66232Z1112T001' and brandshort='TDK' limit 1 [ RunTime:0.019126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66232Z1112T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.063026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57595599 LIMIT 5 [ RunTime:0.027067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595599 ORDER BY `minOrder` ASC [ RunTime:0.010791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57595599 ORDER BY `unit` DESC [ RunTime:0.020489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57595599 LIMIT 2 [ RunTime:0.015898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57595599 ORDER BY `minOrder` ASC [ RunTime:0.001521s ]
select * from pdf where partno='B66232Z1114T001' and brandshort='TDK' limit 1 [ RunTime:0.004488s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B66232Z1114T001' OR `brand` LIKE 'TDK%' ) ) LIMIT 1 [ RunTime:0.025774s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56681037 LIMIT 5 [ RunTime:0.017561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56681037 ORDER BY `minOrder` ASC [ RunTime:0.018307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56681037 ORDER BY `unit` DESC [ RunTime:0.023591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56681037 LIMIT 2 [ RunTime:0.017256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56681037 ORDER BY `minOrder` ASC [ RunTime:0.018128s ]
select * from pdf where partno='B6623' and brandshort='Botron Company Inc.' limit 1 [ RunTime:0.012422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B6623' OR `brand` LIKE 'Botron Company Inc.%' ) ) LIMIT 1 [ RunTime:0.018541s ]
SELECT `id` FROM `stock` WHERE `id` <> 56681037 AND `partno` = 'B6623' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%botron company inc.%' ) [ RunTime:0.018368s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012318s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029040s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010262s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026157s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021991s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015051s ]
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 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004802s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'B6623%' OR `brand` LIKE 'B6623%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019684s ]