SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001475s ]
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=15429&search=1' [ RunTime:0.003900s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002042s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002003s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001647s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.010867s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001787s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.003328s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001834s ]
SELECT * FROM `stock_search` WHERE `partno` = '15429' LIMIT 1 [ RunTime:0.022036s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-24 18:43:29' WHERE `partno` = '15429' [ RunTime:0.007605s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001622s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082457s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.013206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10899136 LIMIT 5 [ RunTime:0.060500s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.018205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899136 ORDER BY `minOrder` ASC [ RunTime:0.016359s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10899136 ORDER BY `unit` DESC [ RunTime:0.041567s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10899136 LIMIT 2 [ RunTime:0.034458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899136 ORDER BY `minOrder` ASC [ RunTime:0.017412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10899135 LIMIT 5 [ RunTime:0.060492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899135 ORDER BY `minOrder` ASC [ RunTime:0.120570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10899135 ORDER BY `unit` DESC [ RunTime:0.079422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10899135 LIMIT 2 [ RunTime:0.119964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10899135 ORDER BY `minOrder` ASC [ RunTime:0.009612s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10820947 LIMIT 5 [ RunTime:0.027477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10820947 ORDER BY `minOrder` ASC [ RunTime:0.044597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10820947 ORDER BY `unit` DESC [ RunTime:0.086192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10820947 LIMIT 2 [ RunTime:0.070290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10820947 ORDER BY `minOrder` ASC [ RunTime:0.094069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647353 LIMIT 5 [ RunTime:0.031488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647353 ORDER BY `minOrder` ASC [ RunTime:0.038714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647353 ORDER BY `unit` DESC [ RunTime:0.019155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647353 LIMIT 2 [ RunTime:0.016701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647353 ORDER BY `minOrder` ASC [ RunTime:0.015162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637518 LIMIT 5 [ RunTime:0.042776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637518 ORDER BY `minOrder` ASC [ RunTime:0.056867s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637518 ORDER BY `unit` DESC [ RunTime:0.038258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637518 LIMIT 2 [ RunTime:0.027258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637518 ORDER BY `minOrder` ASC [ RunTime:0.011417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309331 LIMIT 5 [ RunTime:0.038951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309331 ORDER BY `minOrder` ASC [ RunTime:0.025706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17309331 ORDER BY `unit` DESC [ RunTime:0.010392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17309331 LIMIT 2 [ RunTime:0.010737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17309331 ORDER BY `minOrder` ASC [ RunTime:0.015165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15450456 LIMIT 5 [ RunTime:0.035465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450456 ORDER BY `minOrder` ASC [ RunTime:0.028229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15450456 ORDER BY `unit` DESC [ RunTime:0.015649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15450456 LIMIT 2 [ RunTime:0.005886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15450456 ORDER BY `minOrder` ASC [ RunTime:0.006041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13811627 LIMIT 5 [ RunTime:0.013118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13811627 ORDER BY `minOrder` ASC [ RunTime:0.008080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13811627 ORDER BY `unit` DESC [ RunTime:0.011497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13811627 LIMIT 2 [ RunTime:0.001440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13811627 ORDER BY `minOrder` ASC [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504525 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504525 ORDER BY `minOrder` ASC [ RunTime:0.001575s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504525 ORDER BY `unit` DESC [ RunTime:0.003302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504525 LIMIT 2 [ RunTime:0.003258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504525 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504523 LIMIT 5 [ RunTime:0.000543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504523 ORDER BY `minOrder` ASC [ RunTime:0.020235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12504523 ORDER BY `unit` DESC [ RunTime:0.001733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12504523 LIMIT 2 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12504523 ORDER BY `minOrder` ASC [ RunTime:0.004382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028517 LIMIT 5 [ RunTime:0.007228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028517 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028517 ORDER BY `unit` DESC [ RunTime:0.003434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028517 LIMIT 2 [ RunTime:0.001118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028517 ORDER BY `minOrder` ASC [ RunTime:0.004340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11440181 LIMIT 5 [ RunTime:0.019124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11440181 ORDER BY `minOrder` ASC [ RunTime:0.015544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11440181 ORDER BY `unit` DESC [ RunTime:0.012797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11440181 LIMIT 2 [ RunTime:0.031016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11440181 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439678 LIMIT 5 [ RunTime:0.000832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439678 ORDER BY `minOrder` ASC [ RunTime:0.004018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11439678 ORDER BY `unit` DESC [ RunTime:0.006455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11439678 LIMIT 2 [ RunTime:0.002717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11439678 ORDER BY `minOrder` ASC [ RunTime:0.014742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409314 LIMIT 5 [ RunTime:0.004523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409314 ORDER BY `minOrder` ASC [ RunTime:0.019638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11409314 ORDER BY `unit` DESC [ RunTime:0.022590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11409314 LIMIT 2 [ RunTime:0.001948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11409314 ORDER BY `minOrder` ASC [ RunTime:0.010865s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003447s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 34465018 LIMIT 5 [ RunTime:0.000455s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34465018 ORDER BY `minOrder` ASC [ RunTime:0.001063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 34465018 ORDER BY `unit` DESC [ RunTime:0.000419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 34465018 LIMIT 2 [ RunTime:0.009452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 34465018 ORDER BY `minOrder` ASC [ RunTime:0.004524s ]
select * from pdf where partno='1542994' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013222s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542994' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64105074 LIMIT 5 [ RunTime:0.001125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64105074 ORDER BY `minOrder` ASC [ RunTime:0.006534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64105074 ORDER BY `unit` DESC [ RunTime:0.021535s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64105074 LIMIT 2 [ RunTime:0.001859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64105074 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='1542953' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542953' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013892s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62451499 LIMIT 5 [ RunTime:0.007048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62451499 ORDER BY `minOrder` ASC [ RunTime:0.013652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62451499 ORDER BY `unit` DESC [ RunTime:0.010160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62451499 LIMIT 2 [ RunTime:0.008613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62451499 ORDER BY `minOrder` ASC [ RunTime:0.007819s ]
select * from pdf where partno='15429' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.006575s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15429' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.005884s ]
SELECT `id` FROM `stock` WHERE `id` <> 62451499 AND `partno` = '15429' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13811627 [ RunTime:0.000606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61203633 LIMIT 5 [ RunTime:0.017297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61203633 ORDER BY `minOrder` ASC [ RunTime:0.009012s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61203633 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61203633 LIMIT 2 [ RunTime:0.015372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61203633 ORDER BY `minOrder` ASC [ RunTime:0.000547s ]
select * from pdf where partno='1542978' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.004446s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542978' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61201986 LIMIT 5 [ RunTime:0.008204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61201986 ORDER BY `minOrder` ASC [ RunTime:0.008933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61201986 ORDER BY `unit` DESC [ RunTime:0.014905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61201986 LIMIT 2 [ RunTime:0.017034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61201986 ORDER BY `minOrder` ASC [ RunTime:0.009958s ]
select * from pdf where partno='1542981' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.018573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542981' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61192109 LIMIT 5 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192109 ORDER BY `minOrder` ASC [ RunTime:0.028349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61192109 ORDER BY `unit` DESC [ RunTime:0.000537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61192109 LIMIT 2 [ RunTime:0.005215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61192109 ORDER BY `minOrder` ASC [ RunTime:0.006390s ]
select * from pdf where partno='1542907' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542907' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.040116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61190446 LIMIT 5 [ RunTime:0.051927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61190446 ORDER BY `minOrder` ASC [ RunTime:0.039033s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61190446 ORDER BY `unit` DESC [ RunTime:0.000777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61190446 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61190446 ORDER BY `minOrder` ASC [ RunTime:0.000392s ]
select * from pdf where partno='1542910' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542910' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60589712 LIMIT 5 [ RunTime:0.013283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60589712 ORDER BY `minOrder` ASC [ RunTime:0.006118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60589712 ORDER BY `unit` DESC [ RunTime:0.037545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60589712 LIMIT 2 [ RunTime:0.065138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60589712 ORDER BY `minOrder` ASC [ RunTime:0.038397s ]
select * from pdf where partno='1542950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.044627s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031769s ]
SELECT `id` FROM `stock` WHERE `id` <> 60589712 AND `partno` = '1542950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11440181 [ RunTime:0.016622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60588314 LIMIT 5 [ RunTime:0.028369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60588314 ORDER BY `minOrder` ASC [ RunTime:0.027085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60588314 ORDER BY `unit` DESC [ RunTime:0.061260s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60588314 LIMIT 2 [ RunTime:0.038913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60588314 ORDER BY `minOrder` ASC [ RunTime:0.021236s ]
select * from pdf where partno='1542910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007842s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.052763s ]
SELECT `id` FROM `stock` WHERE `id` <> 60588314 AND `partno` = '1542910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.075479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11439678 [ RunTime:0.077020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60544118 LIMIT 5 [ RunTime:0.035606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60544118 ORDER BY `minOrder` ASC [ RunTime:0.023739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60544118 ORDER BY `unit` DESC [ RunTime:0.057748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60544118 LIMIT 2 [ RunTime:0.106636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60544118 ORDER BY `minOrder` ASC [ RunTime:0.013109s ]
select * from pdf where partno='1542990000' and brandshort='Weidmüller' limit 1 [ RunTime:0.040158s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542990000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.073542s ]
SELECT `id` FROM `stock` WHERE `id` <> 60544118 AND `partno` = '1542990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.050287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647353 [ RunTime:0.048700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60538901 LIMIT 5 [ RunTime:0.032947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60538901 ORDER BY `minOrder` ASC [ RunTime:0.068169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60538901 ORDER BY `unit` DESC [ RunTime:0.142454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60538901 LIMIT 2 [ RunTime:0.101453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60538901 ORDER BY `minOrder` ASC [ RunTime:0.060430s ]
select * from pdf where partno='1542980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.173680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.073326s ]
SELECT `id` FROM `stock` WHERE `id` <> 60538901 AND `partno` = '1542980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.130310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15450456 [ RunTime:0.061191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60538900 LIMIT 5 [ RunTime:0.031192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60538900 ORDER BY `minOrder` ASC [ RunTime:0.021037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60538900 ORDER BY `unit` DESC [ RunTime:0.033294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60538900 LIMIT 2 [ RunTime:0.060007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60538900 ORDER BY `minOrder` ASC [ RunTime:0.011386s ]
select * from pdf where partno='1542970000' and brandshort='Weidmüller' limit 1 [ RunTime:0.037858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542970000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.053281s ]
SELECT `id` FROM `stock` WHERE `id` <> 60538900 AND `partno` = '1542970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.051441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17309331 [ RunTime:0.012059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60530796 LIMIT 5 [ RunTime:0.051525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60530796 ORDER BY `minOrder` ASC [ RunTime:0.057387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60530796 ORDER BY `unit` DESC [ RunTime:0.021968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60530796 LIMIT 2 [ RunTime:0.042106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60530796 ORDER BY `minOrder` ASC [ RunTime:0.012123s ]
select * from pdf where partno='1542960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.030461s ]
SELECT `id` FROM `stock` WHERE `id` <> 60530796 AND `partno` = '1542960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637518 [ RunTime:0.027693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374557 LIMIT 5 [ RunTime:0.025814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374557 ORDER BY `minOrder` ASC [ RunTime:0.024492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374557 ORDER BY `unit` DESC [ RunTime:0.019088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374557 LIMIT 2 [ RunTime:0.004620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374557 ORDER BY `minOrder` ASC [ RunTime:0.008232s ]
select * from pdf where partno='1542924-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.046314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542924-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.033922s ]
SELECT `id` FROM `stock` WHERE `id` <> 60374557 AND `partno` = '1542924-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.031498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504525 [ RunTime:0.051471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374551 LIMIT 5 [ RunTime:0.058674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374551 ORDER BY `minOrder` ASC [ RunTime:0.102916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374551 ORDER BY `unit` DESC [ RunTime:0.046762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374551 LIMIT 2 [ RunTime:0.025656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374551 ORDER BY `minOrder` ASC [ RunTime:0.044156s ]
select * from pdf where partno='1542993-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.022319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542993-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.042237s ]
SELECT `id` FROM `stock` WHERE `id` <> 60374551 AND `partno` = '1542993-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.026379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11409314 [ RunTime:0.063384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60374550 LIMIT 5 [ RunTime:0.062375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374550 ORDER BY `minOrder` ASC [ RunTime:0.066953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60374550 ORDER BY `unit` DESC [ RunTime:0.091435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60374550 LIMIT 2 [ RunTime:0.112968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60374550 ORDER BY `minOrder` ASC [ RunTime:0.207343s ]
select * from pdf where partno='1542992-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.062990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1542992-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.043338s ]
SELECT `id` FROM `stock` WHERE `id` <> 60374550 AND `partno` = '1542992-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.133267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12504523 [ RunTime:0.060042s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031361s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.065578s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040681s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010870s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054526s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050046s ]
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 '15429%' OR `brand` LIKE '15429%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042687s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15429%' OR `brand` LIKE '15429%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013198s ]