SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002457s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.162' , `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=2039&search=1' [ RunTime:0.003046s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001482s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000818s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002430s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.001399s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001783s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004849s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002260s ]
SELECT * FROM `stock_search` WHERE `partno` = '2039' LIMIT 1 [ RunTime:0.019366s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-18 12:18:50' WHERE `partno` = '2039' [ RunTime:0.016111s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002594s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040722s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481222 LIMIT 5 [ RunTime:0.019822s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481222 ORDER BY `minOrder` ASC [ RunTime:0.007108s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.006296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481222 ORDER BY `unit` DESC [ RunTime:0.008694s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481222 LIMIT 2 [ RunTime:0.021456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481222 ORDER BY `minOrder` ASC [ RunTime:0.005928s ]
select * from pdf where partno='2039510001' and brandshort='Molex' limit 1 [ RunTime:0.013520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12782144 LIMIT 5 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782144 ORDER BY `minOrder` ASC [ RunTime:0.028355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12782144 ORDER BY `unit` DESC [ RunTime:0.032726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12782144 LIMIT 2 [ RunTime:0.014033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12782144 ORDER BY `minOrder` ASC [ RunTime:0.008740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785795 LIMIT 5 [ RunTime:0.029957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785795 ORDER BY `minOrder` ASC [ RunTime:0.054446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12785795 ORDER BY `unit` DESC [ RunTime:0.053676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12785795 LIMIT 2 [ RunTime:0.017066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785795 ORDER BY `minOrder` ASC [ RunTime:0.054073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605341 LIMIT 5 [ RunTime:0.045434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605341 ORDER BY `minOrder` ASC [ RunTime:0.057123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11605341 ORDER BY `unit` DESC [ RunTime:0.100588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11605341 LIMIT 2 [ RunTime:0.076752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605341 ORDER BY `minOrder` ASC [ RunTime:0.010791s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11605344 LIMIT 5 [ RunTime:0.051872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605344 ORDER BY `minOrder` ASC [ RunTime:0.068328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11605344 ORDER BY `unit` DESC [ RunTime:0.139010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11605344 LIMIT 2 [ RunTime:0.044420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11605344 ORDER BY `minOrder` ASC [ RunTime:0.035003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12785785 LIMIT 5 [ RunTime:0.044693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785785 ORDER BY `minOrder` ASC [ RunTime:0.051255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12785785 ORDER BY `unit` DESC [ RunTime:0.059095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12785785 LIMIT 2 [ RunTime:0.070132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12785785 ORDER BY `minOrder` ASC [ RunTime:0.039224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11602595 LIMIT 5 [ RunTime:0.020937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602595 ORDER BY `minOrder` ASC [ RunTime:0.015244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11602595 ORDER BY `unit` DESC [ RunTime:0.044422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11602595 LIMIT 2 [ RunTime:0.051356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11602595 ORDER BY `minOrder` ASC [ RunTime:0.004658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12791071 LIMIT 5 [ RunTime:0.010225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791071 ORDER BY `minOrder` ASC [ RunTime:0.024224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12791071 ORDER BY `unit` DESC [ RunTime:0.022981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12791071 LIMIT 2 [ RunTime:0.034282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12791071 ORDER BY `minOrder` ASC [ RunTime:0.006859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12781605 LIMIT 5 [ RunTime:0.008520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781605 ORDER BY `minOrder` ASC [ RunTime:0.002488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12781605 ORDER BY `unit` DESC [ RunTime:0.020914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12781605 LIMIT 2 [ RunTime:0.009843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12781605 ORDER BY `minOrder` ASC [ RunTime:0.030180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17297089 LIMIT 5 [ RunTime:0.020443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297089 ORDER BY `minOrder` ASC [ RunTime:0.036884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17297089 ORDER BY `unit` DESC [ RunTime:0.019255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17297089 LIMIT 2 [ RunTime:0.046359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17297089 ORDER BY `minOrder` ASC [ RunTime:0.010417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11280059 LIMIT 5 [ RunTime:0.015258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11280059 ORDER BY `minOrder` ASC [ RunTime:0.040090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11280059 ORDER BY `unit` DESC [ RunTime:0.030668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11280059 LIMIT 2 [ RunTime:0.006730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11280059 ORDER BY `minOrder` ASC [ RunTime:0.003964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998215 LIMIT 5 [ RunTime:0.003086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998215 ORDER BY `minOrder` ASC [ RunTime:0.000711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18998215 ORDER BY `unit` DESC [ RunTime:0.036944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18998215 LIMIT 2 [ RunTime:0.027763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18998215 ORDER BY `minOrder` ASC [ RunTime:0.003808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13669544 LIMIT 5 [ RunTime:0.012799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13669544 ORDER BY `minOrder` ASC [ RunTime:0.016321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13669544 ORDER BY `unit` DESC [ RunTime:0.047643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13669544 LIMIT 2 [ RunTime:0.072945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13669544 ORDER BY `minOrder` ASC [ RunTime:0.043902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207408 LIMIT 5 [ RunTime:0.038332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207408 ORDER BY `minOrder` ASC [ RunTime:0.031279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11207408 ORDER BY `unit` DESC [ RunTime:0.041544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11207408 LIMIT 2 [ RunTime:0.062018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11207408 ORDER BY `minOrder` ASC [ RunTime:0.032743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961559 LIMIT 5 [ RunTime:0.041765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961559 ORDER BY `minOrder` ASC [ RunTime:0.028187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18961559 ORDER BY `unit` DESC [ RunTime:0.058585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18961559 LIMIT 2 [ RunTime:0.041446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18961559 ORDER BY `minOrder` ASC [ RunTime:0.020106s ]
select * from pdf where partno='2039' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.033410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14180959 LIMIT 5 [ RunTime:0.085296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180959 ORDER BY `minOrder` ASC [ RunTime:0.052617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14180959 ORDER BY `unit` DESC [ RunTime:0.088461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14180959 LIMIT 2 [ RunTime:0.082290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14180959 ORDER BY `minOrder` ASC [ RunTime:0.003126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12237534 LIMIT 5 [ RunTime:0.033497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237534 ORDER BY `minOrder` ASC [ RunTime:0.026985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12237534 ORDER BY `unit` DESC [ RunTime:0.097448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12237534 LIMIT 2 [ RunTime:0.070266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12237534 ORDER BY `minOrder` ASC [ RunTime:0.054985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573312 LIMIT 5 [ RunTime:0.035754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573312 ORDER BY `minOrder` ASC [ RunTime:0.064062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573312 ORDER BY `unit` DESC [ RunTime:0.016650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573312 LIMIT 2 [ RunTime:0.060555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573312 ORDER BY `minOrder` ASC [ RunTime:0.010069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573298 LIMIT 5 [ RunTime:0.018919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573298 ORDER BY `minOrder` ASC [ RunTime:0.023057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573298 ORDER BY `unit` DESC [ RunTime:0.061658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573298 LIMIT 2 [ RunTime:0.030016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573298 ORDER BY `minOrder` ASC [ RunTime:0.018157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17496736 LIMIT 5 [ RunTime:0.021637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496736 ORDER BY `minOrder` ASC [ RunTime:0.024153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17496736 ORDER BY `unit` DESC [ RunTime:0.013939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17496736 LIMIT 2 [ RunTime:0.021627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496736 ORDER BY `minOrder` ASC [ RunTime:0.002641s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268366 LIMIT 5 [ RunTime:0.008468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268366 ORDER BY `minOrder` ASC [ RunTime:0.011788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268366 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268366 LIMIT 2 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268366 ORDER BY `minOrder` ASC [ RunTime:0.004942s ]
select * from pdf where partno='203956-0603' and brandshort='molex' limit 1 [ RunTime:0.003990s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001811s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203956-0603' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.010815s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344063 LIMIT 5 [ RunTime:0.004148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344063 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344063 ORDER BY `unit` DESC [ RunTime:0.011548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344063 LIMIT 2 [ RunTime:0.001590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344063 ORDER BY `minOrder` ASC [ RunTime:0.000511s ]
select * from pdf where partno='2039510001' and brandshort='Molex' limit 1 [ RunTime:0.004146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039510001' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59356094 LIMIT 5 [ RunTime:0.010095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59356094 ORDER BY `minOrder` ASC [ RunTime:0.011148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59356094 ORDER BY `unit` DESC [ RunTime:0.004222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59356094 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59356094 ORDER BY `minOrder` ASC [ RunTime:0.005296s ]
select * from pdf where partno='2039550503' and brandshort='Molex' limit 1 [ RunTime:0.015391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039550503' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355224 LIMIT 5 [ RunTime:0.006841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355224 ORDER BY `minOrder` ASC [ RunTime:0.017226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355224 ORDER BY `unit` DESC [ RunTime:0.001038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355224 LIMIT 2 [ RunTime:0.008552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355224 ORDER BY `minOrder` ASC [ RunTime:0.002274s ]
select * from pdf where partno='2039550603' and brandshort='Molex' limit 1 [ RunTime:0.006454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039550603' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59357600 LIMIT 5 [ RunTime:0.000607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357600 ORDER BY `minOrder` ASC [ RunTime:0.010153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59357600 ORDER BY `unit` DESC [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59357600 LIMIT 2 [ RunTime:0.000748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59357600 ORDER BY `minOrder` ASC [ RunTime:0.004260s ]
select * from pdf where partno='2039560503' and brandshort='Molex' limit 1 [ RunTime:0.009507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560503' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355154 LIMIT 5 [ RunTime:0.014641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355154 ORDER BY `minOrder` ASC [ RunTime:0.010982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355154 ORDER BY `unit` DESC [ RunTime:0.023934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355154 LIMIT 2 [ RunTime:0.017913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355154 ORDER BY `minOrder` ASC [ RunTime:0.004166s ]
select * from pdf where partno='2039550203' and brandshort='Molex' limit 1 [ RunTime:0.013888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039550203' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.016473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355240 LIMIT 5 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355240 ORDER BY `minOrder` ASC [ RunTime:0.010857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355240 ORDER BY `unit` DESC [ RunTime:0.008173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355240 LIMIT 2 [ RunTime:0.001771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355240 ORDER BY `minOrder` ASC [ RunTime:0.012872s ]
select * from pdf where partno='2039560603' and brandshort='Molex' limit 1 [ RunTime:0.012619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560603' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355180 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355180 ORDER BY `minOrder` ASC [ RunTime:0.001982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355180 ORDER BY `unit` DESC [ RunTime:0.004361s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355180 LIMIT 2 [ RunTime:0.003587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355180 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
select * from pdf where partno='2039560303' and brandshort='Molex' limit 1 [ RunTime:0.001295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560303' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.024191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355175 LIMIT 5 [ RunTime:0.012439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355175 ORDER BY `minOrder` ASC [ RunTime:0.019562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355175 ORDER BY `unit` DESC [ RunTime:0.017468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355175 LIMIT 2 [ RunTime:0.009145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355175 ORDER BY `minOrder` ASC [ RunTime:0.007028s ]
select * from pdf where partno='2039560203' and brandshort='Molex' limit 1 [ RunTime:0.012112s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560203' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355198 LIMIT 5 [ RunTime:0.009750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355198 ORDER BY `minOrder` ASC [ RunTime:0.005771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355198 ORDER BY `unit` DESC [ RunTime:0.015594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355198 LIMIT 2 [ RunTime:0.026091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355198 ORDER BY `minOrder` ASC [ RunTime:0.002919s ]
select * from pdf where partno='2039560403' and brandshort='Molex' limit 1 [ RunTime:0.000941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560403' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.027526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355193 LIMIT 5 [ RunTime:0.020947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355193 ORDER BY `minOrder` ASC [ RunTime:0.023202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355193 ORDER BY `unit` DESC [ RunTime:0.026778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355193 LIMIT 2 [ RunTime:0.016689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355193 ORDER BY `minOrder` ASC [ RunTime:0.015531s ]
select * from pdf where partno='2039550403' and brandshort='Molex' limit 1 [ RunTime:0.008810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039550403' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.017283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59355163 LIMIT 5 [ RunTime:0.016065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355163 ORDER BY `minOrder` ASC [ RunTime:0.014662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59355163 ORDER BY `unit` DESC [ RunTime:0.001050s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59355163 LIMIT 2 [ RunTime:0.013500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59355163 ORDER BY `minOrder` ASC [ RunTime:0.026110s ]
select * from pdf where partno='2039550303' and brandshort='Molex' limit 1 [ RunTime:0.021834s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039550303' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42869626 LIMIT 5 [ RunTime:0.000821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42869626 ORDER BY `minOrder` ASC [ RunTime:0.014452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42869626 ORDER BY `unit` DESC [ RunTime:0.004235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42869626 LIMIT 2 [ RunTime:0.012608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42869626 ORDER BY `minOrder` ASC [ RunTime:0.002648s ]
select * from pdf where partno='203956-MCSO-C 20MHZ E/D J/L' and brandshort='Micro Crystal AG' limit 1 [ RunTime:0.009460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203956-MCSO-C 20MHZ E/D J/L' OR `brand` LIKE 'Micro Crystal AG%' ) ) LIMIT 1 [ RunTime:0.011384s ]
SELECT `id` FROM `stock` WHERE `id` <> 42869626 AND `partno` = '203956-MCSO-C 20MHZ E/D J/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%micro crystal ag%' ) [ RunTime:0.021072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11280059 [ RunTime:0.009473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60943964 LIMIT 5 [ RunTime:0.004828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943964 ORDER BY `minOrder` ASC [ RunTime:0.001337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60943964 ORDER BY `unit` DESC [ RunTime:0.000773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60943964 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60943964 ORDER BY `minOrder` ASC [ RunTime:0.002011s ]
select * from pdf where partno='203956-2' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '203956-2' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.024158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60999112 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60999112 ORDER BY `minOrder` ASC [ RunTime:0.006340s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60999112 ORDER BY `unit` DESC [ RunTime:0.006634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60999112 LIMIT 2 [ RunTime:0.000706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60999112 ORDER BY `minOrder` ASC [ RunTime:0.002333s ]
select * from pdf where partno='2039W' and brandshort='Eaton Wiring Devices' limit 1 [ RunTime:0.001143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039W' OR `brand` LIKE 'Eaton Wiring Devices%' ) ) LIMIT 1 [ RunTime:0.000913s ]
SELECT `id` FROM `stock` WHERE `id` <> 60999112 AND `partno` = '2039W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton wiring devices%' ) [ RunTime:0.001013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63460267 LIMIT 5 [ RunTime:0.000703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460267 ORDER BY `minOrder` ASC [ RunTime:0.002171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63460267 ORDER BY `unit` DESC [ RunTime:0.002668s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63460267 LIMIT 2 [ RunTime:0.001501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63460267 ORDER BY `minOrder` ASC [ RunTime:0.000495s ]
select * from pdf where partno='2039' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002858s ]
SELECT `id` FROM `stock` WHERE `id` <> 63460267 AND `partno` = '2039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.034916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18998215 [ RunTime:0.031814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64811805 LIMIT 5 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811805 ORDER BY `minOrder` ASC [ RunTime:0.013380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64811805 ORDER BY `unit` DESC [ RunTime:0.008067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64811805 LIMIT 2 [ RunTime:0.020950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64811805 ORDER BY `minOrder` ASC [ RunTime:0.010082s ]
select * from pdf where partno='2039248' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.021964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039248' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001056s ]
SELECT `id` FROM `stock` WHERE `id` <> 64811805 AND `partno` = '2039248' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11207408 [ RunTime:0.007036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62447822 LIMIT 5 [ RunTime:0.003091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62447822 ORDER BY `minOrder` ASC [ RunTime:0.013299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62447822 ORDER BY `unit` DESC [ RunTime:0.004388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62447822 LIMIT 2 [ RunTime:0.011493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62447822 ORDER BY `minOrder` ASC [ RunTime:0.004512s ]
select * from pdf where partno='2039' and brandshort='Pololu' limit 1 [ RunTime:0.002648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.010677s ]
SELECT `id` FROM `stock` WHERE `id` <> 62447822 AND `partno` = '2039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13669544 [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915475 LIMIT 5 [ RunTime:0.005439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915475 ORDER BY `minOrder` ASC [ RunTime:0.007313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915475 ORDER BY `unit` DESC [ RunTime:0.029588s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915475 LIMIT 2 [ RunTime:0.012851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915475 ORDER BY `minOrder` ASC [ RunTime:0.004346s ]
select * from pdf where partno='2039296C058' and brandshort='Ease Electronics' limit 1 [ RunTime:0.011785s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039296C058' OR `brand` LIKE 'Ease Electronics%' ) ) LIMIT 1 [ RunTime:0.025930s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915475 AND `partno` = '2039296C058' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ease electronics%' ) [ RunTime:0.025638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212373 LIMIT 5 [ RunTime:0.002061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212373 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212373 ORDER BY `unit` DESC [ RunTime:0.003696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212373 LIMIT 2 [ RunTime:0.001555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212373 ORDER BY `minOrder` ASC [ RunTime:0.004773s ]
select * from pdf where partno='2039303' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.006018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039303' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004291s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212373 AND `partno` = '2039303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58163250 LIMIT 5 [ RunTime:0.008388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58163250 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58163250 ORDER BY `unit` DESC [ RunTime:0.006796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58163250 LIMIT 2 [ RunTime:0.006445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58163250 ORDER BY `minOrder` ASC [ RunTime:0.001591s ]
select * from pdf where partno='2039' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000396s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.001314s ]
SELECT `id` FROM `stock` WHERE `id` <> 58163250 AND `partno` = '2039' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.000871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18961559 [ RunTime:0.004338s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001752s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003410s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003644s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020426s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005625s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001563s ]
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 '2039%' OR `brand` LIKE '2039%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019610 LIMIT 5 [ RunTime:0.002307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019610 ORDER BY `minOrder` ASC [ RunTime:0.012314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019610 ORDER BY `unit` DESC [ RunTime:0.003907s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019610 LIMIT 2 [ RunTime:0.012273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019610 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
select * from pdf where partno='2039560203' and brandshort='MOLEX' limit 1 [ RunTime:0.001102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2039560203' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.013752s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2039%' OR `brand` LIKE '2039%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007997s ]