SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.004207s ]
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=SMDJ5.0C&search=1' [ RunTime:0.004636s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001281s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.011225s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001265s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006642s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002305s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009695s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001691s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMDJ5.0C' LIMIT 1 [ RunTime:0.013380s ]
UPDATE `stock_search` SET `count` = 16 , `updatetime` = '2026-08-27 20:30:39' WHERE `partno` = 'SMDJ5.0C' [ RunTime:0.004947s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001475s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079941s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663814 LIMIT 5 [ RunTime:0.008117s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663814 ORDER BY `minOrder` ASC [ RunTime:0.043079s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663814 ORDER BY `unit` DESC [ RunTime:0.022879s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663814 LIMIT 2 [ RunTime:0.038070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663814 ORDER BY `minOrder` ASC [ RunTime:0.034727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16661618 LIMIT 5 [ RunTime:0.038814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661618 ORDER BY `minOrder` ASC [ RunTime:0.024919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16661618 ORDER BY `unit` DESC [ RunTime:0.008300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16661618 LIMIT 2 [ RunTime:0.009736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16661618 ORDER BY `minOrder` ASC [ RunTime:0.021905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802681 LIMIT 5 [ RunTime:0.024241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802681 ORDER BY `minOrder` ASC [ RunTime:0.012789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802681 ORDER BY `unit` DESC [ RunTime:0.029045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802681 LIMIT 2 [ RunTime:0.010930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802681 ORDER BY `minOrder` ASC [ RunTime:0.022189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907661 LIMIT 5 [ RunTime:0.045966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907661 ORDER BY `minOrder` ASC [ RunTime:0.014836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907661 ORDER BY `unit` DESC [ RunTime:0.014488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907661 LIMIT 2 [ RunTime:0.014807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907661 ORDER BY `minOrder` ASC [ RunTime:0.038203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146812 LIMIT 5 [ RunTime:0.035766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146812 ORDER BY `minOrder` ASC [ RunTime:0.014405s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146812 ORDER BY `unit` DESC [ RunTime:0.035973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146812 LIMIT 2 [ RunTime:0.016140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146812 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
select * from pdf where partno='SMDJ5.0CA' and brandshort='UMW' limit 1 [ RunTime:0.016683s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.022929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16688008 LIMIT 5 [ RunTime:0.041151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688008 ORDER BY `minOrder` ASC [ RunTime:0.054854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16688008 ORDER BY `unit` DESC [ RunTime:0.082255s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16688008 LIMIT 2 [ RunTime:0.052776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16688008 ORDER BY `minOrder` ASC [ RunTime:0.063541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684011 LIMIT 5 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684011 ORDER BY `minOrder` ASC [ RunTime:0.027693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684011 ORDER BY `unit` DESC [ RunTime:0.026038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684011 LIMIT 2 [ RunTime:0.017263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684011 ORDER BY `minOrder` ASC [ RunTime:0.012160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665314 LIMIT 5 [ RunTime:0.011919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665314 ORDER BY `minOrder` ASC [ RunTime:0.005377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16665314 ORDER BY `unit` DESC [ RunTime:0.005519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16665314 LIMIT 2 [ RunTime:0.002881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16665314 ORDER BY `minOrder` ASC [ RunTime:0.010921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824615 LIMIT 5 [ RunTime:0.003241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824615 ORDER BY `minOrder` ASC [ RunTime:0.006104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14824615 ORDER BY `unit` DESC [ RunTime:0.014966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14824615 LIMIT 2 [ RunTime:0.007391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14824615 ORDER BY `minOrder` ASC [ RunTime:0.007673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815278 LIMIT 5 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815278 ORDER BY `minOrder` ASC [ RunTime:0.022595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815278 ORDER BY `unit` DESC [ RunTime:0.014856s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815278 LIMIT 2 [ RunTime:0.010015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815278 ORDER BY `minOrder` ASC [ RunTime:0.020868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925287 LIMIT 5 [ RunTime:0.009290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925287 ORDER BY `minOrder` ASC [ RunTime:0.017322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925287 ORDER BY `unit` DESC [ RunTime:0.021389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925287 LIMIT 2 [ RunTime:0.016185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925287 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13918328 LIMIT 5 [ RunTime:0.001564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918328 ORDER BY `minOrder` ASC [ RunTime:0.007375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13918328 ORDER BY `unit` DESC [ RunTime:0.003914s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13918328 LIMIT 2 [ RunTime:0.010585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13918328 ORDER BY `minOrder` ASC [ RunTime:0.015506s ]
select * from pdf where partno='SMDJ5.0CA' and brandshort='UMW' limit 1 [ RunTime:0.006507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13917730 LIMIT 5 [ RunTime:0.001182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917730 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13917730 ORDER BY `unit` DESC [ RunTime:0.010137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13917730 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13917730 ORDER BY `minOrder` ASC [ RunTime:0.005073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916571 LIMIT 5 [ RunTime:0.003196s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916571 ORDER BY `minOrder` ASC [ RunTime:0.014659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916571 ORDER BY `unit` DESC [ RunTime:0.000624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916571 LIMIT 2 [ RunTime:0.017332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916571 ORDER BY `minOrder` ASC [ RunTime:0.003905s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141188 LIMIT 5 [ RunTime:0.005045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141188 ORDER BY `minOrder` ASC [ RunTime:0.002743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141188 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141188 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141188 ORDER BY `minOrder` ASC [ RunTime:0.003345s ]
select * from pdf where partno='smdj5.0ca-hr' and brandshort='littelfuse' limit 1 [ RunTime:0.005241s ]
select foldpath,foldpath2,filename from pdf_file where id=1084026 limit 1 [ RunTime:0.005072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smdj5.0ca-hr' OR `brand` LIKE 'littelfuse%' ) ) LIMIT 1 [ RunTime:0.000386s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42163004 LIMIT 5 [ RunTime:0.007161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42163004 ORDER BY `minOrder` ASC [ RunTime:0.002072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42163004 ORDER BY `unit` DESC [ RunTime:0.000442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42163004 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42163004 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
select * from pdf where partno='SMDJ5.0CA' and brandshort='NextGen Components' limit 1 [ RunTime:0.001245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145110 LIMIT 5 [ RunTime:0.002010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145110 ORDER BY `minOrder` ASC [ RunTime:0.001440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145110 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145110 LIMIT 2 [ RunTime:0.000398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145110 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='SMDJ5.0CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000434s ]
SELECT `id` FROM `stock` WHERE `id` <> 42145110 AND `partno` = 'SMDJ5.0CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684011 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42127102 LIMIT 5 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127102 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42127102 ORDER BY `unit` DESC [ RunTime:0.000421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42127102 LIMIT 2 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42127102 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='SMDJ5.0CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42144289 LIMIT 5 [ RunTime:0.000395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42144289 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42144289 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42144289 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42144289 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
select * from pdf where partno='SMDJ5.0CA-E' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-E' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT `id` FROM `stock` WHERE `id` <> 42144289 AND `partno` = 'SMDJ5.0CA-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16665314 [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170731 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170731 ORDER BY `minOrder` ASC [ RunTime:0.004053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170731 ORDER BY `unit` DESC [ RunTime:0.000499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170731 LIMIT 2 [ RunTime:0.000405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170731 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='SMDJ5.0CA-T7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-T7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170731 AND `partno` = 'SMDJ5.0CA-T7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907661 [ RunTime:0.000406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42425964 LIMIT 5 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42425964 ORDER BY `minOrder` ASC [ RunTime:0.000413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42425964 ORDER BY `unit` DESC [ RunTime:0.000664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42425964 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42425964 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='SMDJ5.0CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000437s ]
SELECT `id` FROM `stock` WHERE `id` <> 42425964 AND `partno` = 'SMDJ5.0CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14824615 [ RunTime:0.000402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42416258 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42416258 ORDER BY `minOrder` ASC [ RunTime:0.000355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42416258 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42416258 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42416258 ORDER BY `minOrder` ASC [ RunTime:0.000404s ]
select * from pdf where partno='SMDJ5.0CA-HRAT7' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-HRAT7' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000415s ]
SELECT `id` FROM `stock` WHERE `id` <> 42416258 AND `partno` = 'SMDJ5.0CA-HRAT7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.000466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925287 [ RunTime:0.000400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42279010 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279010 ORDER BY `minOrder` ASC [ RunTime:0.000409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42279010 ORDER BY `unit` DESC [ RunTime:0.000399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42279010 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42279010 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='SMDJ5.0CA' and brandshort='Alpha & Omega Semiconductor Inc.' limit 1 [ RunTime:0.000609s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA' OR `brand` LIKE 'Alpha & Omega Semiconductor Inc.%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259013 LIMIT 5 [ RunTime:0.000408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259013 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259013 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259013 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259013 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='SMDJ5.0CA/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.000606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258346 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258346 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258346 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258346 LIMIT 2 [ RunTime:0.007008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258346 ORDER BY `minOrder` ASC [ RunTime:0.000471s ]
select * from pdf where partno='SMDJ5.0CA-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.000577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42258343 LIMIT 5 [ RunTime:0.000418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258343 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42258343 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42258343 LIMIT 2 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42258343 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='SMDJ5.0CA-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.000620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42175467 LIMIT 5 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175467 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42175467 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42175467 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42175467 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
select * from pdf where partno='SMDJ5.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003876s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMDJ5.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000433s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004422s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001381s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001093s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010043s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013455s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005288s ]
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 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004658s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMDJ5.0C%' OR `brand` LIKE 'SMDJ5.0C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.003435s ]