SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001110s ]
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=SS24&search=1' [ RunTime:0.003275s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001402s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002347s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001155s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002226s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001047s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000242s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001714s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SS24' LIMIT 1 [ RunTime:0.001421s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 12:22:59' WHERE `partno` = 'SS24' [ RunTime:0.003105s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.000993s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007819s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9515 LIMIT 5 [ RunTime:0.002912s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9515 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9515 ORDER BY `unit` DESC [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9515 LIMIT 2 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9515 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24FL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.008775s ]
SELECT `id` FROM `stock` WHERE `id` <> 9515 AND `partno` = 'SS24FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579 [ RunTime:0.001880s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16599 [ RunTime:0.003451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079342 [ RunTime:0.000379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12886243 LIMIT 5 [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886243 ORDER BY `minOrder` ASC [ RunTime:0.000395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12886243 ORDER BY `unit` DESC [ RunTime:0.000375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12886243 LIMIT 2 [ RunTime:0.000352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12886243 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
select * from pdf where partno='SS24W2T' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.002334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885120 LIMIT 5 [ RunTime:0.010762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885120 ORDER BY `minOrder` ASC [ RunTime:0.014573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12885120 ORDER BY `unit` DESC [ RunTime:0.015727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12885120 LIMIT 2 [ RunTime:0.005235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885120 ORDER BY `minOrder` ASC [ RunTime:0.002021s ]
select * from pdf where partno='SS24M2F' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.003040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12885110 LIMIT 5 [ RunTime:0.001927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885110 ORDER BY `minOrder` ASC [ RunTime:0.000727s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12885110 ORDER BY `unit` DESC [ RunTime:0.014708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12885110 LIMIT 2 [ RunTime:0.014072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12885110 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='SS24W2F' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9949 LIMIT 5 [ RunTime:0.006108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9949 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 9949 ORDER BY `unit` DESC [ RunTime:0.003927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 9949 LIMIT 2 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 9949 ORDER BY `minOrder` ASC [ RunTime:0.002109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24S-E3/61T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.020393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14347136 LIMIT 5 [ RunTime:0.014826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347136 ORDER BY `minOrder` ASC [ RunTime:0.001609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14347136 ORDER BY `unit` DESC [ RunTime:0.000626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14347136 LIMIT 2 [ RunTime:0.000606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347136 ORDER BY `minOrder` ASC [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204217 LIMIT 5 [ RunTime:0.003366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204217 ORDER BY `minOrder` ASC [ RunTime:0.001156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13204217 ORDER BY `unit` DESC [ RunTime:0.003811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13204217 LIMIT 2 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13204217 ORDER BY `minOrder` ASC [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16599 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16599 ORDER BY `minOrder` ASC [ RunTime:0.002871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16599 ORDER BY `unit` DESC [ RunTime:0.002969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16599 LIMIT 2 [ RunTime:0.000890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16599 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='SS24FL' and brandshort='ONSEMI' limit 1 [ RunTime:0.002951s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24FL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000507s ]
SELECT `id` FROM `stock` WHERE `id` <> 16599 AND `partno` = 'SS24FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9515 [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579 [ RunTime:0.000367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079342 [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579 LIMIT 5 [ RunTime:0.000568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15579 ORDER BY `minOrder` ASC [ RunTime:0.001395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15579 ORDER BY `unit` DESC [ RunTime:0.002623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15579 LIMIT 2 [ RunTime:0.006080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15579 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
select * from pdf where partno='SS24FL' and brandshort='ONSEMI' limit 1 [ RunTime:0.001783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24FL' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.000428s ]
SELECT `id` FROM `stock` WHERE `id` <> 15579 AND `partno` = 'SS24FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9515 [ RunTime:0.000385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16599 [ RunTime:0.000412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079342 [ RunTime:0.000370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13355966 LIMIT 5 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355966 ORDER BY `minOrder` ASC [ RunTime:0.004264s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13355966 ORDER BY `unit` DESC [ RunTime:0.017514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13355966 LIMIT 2 [ RunTime:0.019851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13355966 ORDER BY `minOrder` ASC [ RunTime:0.002942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14347157 LIMIT 5 [ RunTime:0.002387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347157 ORDER BY `minOrder` ASC [ RunTime:0.002189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14347157 ORDER BY `unit` DESC [ RunTime:0.000672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14347157 LIMIT 2 [ RunTime:0.000604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14347157 ORDER BY `minOrder` ASC [ RunTime:0.003866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6532 LIMIT 5 [ RunTime:0.006470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6532 ORDER BY `minOrder` ASC [ RunTime:0.017876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6532 ORDER BY `unit` DESC [ RunTime:0.003686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6532 LIMIT 2 [ RunTime:0.001884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6532 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='SS24-E3/52T' and brandshort='VISHAY' limit 1 [ RunTime:0.003159s ]
select foldpath,foldpath2,filename from pdf_file where id=785972 limit 1 [ RunTime:0.023997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24-E3/52T' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.011309s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13465110 LIMIT 5 [ RunTime:0.001802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465110 ORDER BY `minOrder` ASC [ RunTime:0.019238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13465110 ORDER BY `unit` DESC [ RunTime:0.020944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13465110 LIMIT 2 [ RunTime:0.001285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465110 ORDER BY `minOrder` ASC [ RunTime:0.001773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13465107 LIMIT 5 [ RunTime:0.000952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465107 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13465107 ORDER BY `unit` DESC [ RunTime:0.000590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13465107 LIMIT 2 [ RunTime:0.008833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465107 ORDER BY `minOrder` ASC [ RunTime:0.001455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173001 LIMIT 5 [ RunTime:0.003448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173001 ORDER BY `minOrder` ASC [ RunTime:0.001943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19173001 ORDER BY `unit` DESC [ RunTime:0.000581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19173001 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173001 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
select * from pdf where partno='SS24-0B00-02' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.001125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19173000 LIMIT 5 [ RunTime:0.006054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173000 ORDER BY `minOrder` ASC [ RunTime:0.002002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19173000 ORDER BY `unit` DESC [ RunTime:0.005823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19173000 LIMIT 2 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19173000 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='SS24-0B00-03' and brandshort='Broadcom Limited' limit 1 [ RunTime:0.014240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17393007 LIMIT 5 [ RunTime:0.009948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393007 ORDER BY `minOrder` ASC [ RunTime:0.002314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17393007 ORDER BY `unit` DESC [ RunTime:0.001453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17393007 LIMIT 2 [ RunTime:0.007565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17393007 ORDER BY `minOrder` ASC [ RunTime:0.002859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13465124 LIMIT 5 [ RunTime:0.003466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465124 ORDER BY `minOrder` ASC [ RunTime:0.004552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13465124 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13465124 LIMIT 2 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13465124 ORDER BY `minOrder` ASC [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13206679 LIMIT 5 [ RunTime:0.001855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13206679 ORDER BY `minOrder` ASC [ RunTime:0.014707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13206679 ORDER BY `unit` DESC [ RunTime:0.005585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13206679 LIMIT 2 [ RunTime:0.017006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13206679 ORDER BY `minOrder` ASC [ RunTime:0.005474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13205753 LIMIT 5 [ RunTime:0.008691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205753 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13205753 ORDER BY `unit` DESC [ RunTime:0.002514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13205753 LIMIT 2 [ RunTime:0.028474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13205753 ORDER BY `minOrder` ASC [ RunTime:0.013492s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32273197 LIMIT 5 [ RunTime:0.005721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273197 ORDER BY `minOrder` ASC [ RunTime:0.010376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32273197 ORDER BY `unit` DESC [ RunTime:0.008081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32273197 LIMIT 2 [ RunTime:0.002029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32273197 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
select * from pdf where partno='ss24w2g10' and brandshort='amphenol sine systems' limit 1 [ RunTime:0.002185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ss24w2g10' OR `brand` LIKE 'amphenol sine systems%' ) ) LIMIT 1 [ RunTime:0.001770s ]
SELECT `id` FROM `stock` WHERE `id` <> 32273197 AND `partno` = 'ss24w2g10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems%' ) [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884913 [ RunTime:0.003820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51073248 LIMIT 5 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51073248 ORDER BY `minOrder` ASC [ RunTime:0.002890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51073248 ORDER BY `unit` DESC [ RunTime:0.005709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51073248 LIMIT 2 [ RunTime:0.017181s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51073248 ORDER BY `minOrder` ASC [ RunTime:0.002263s ]
select * from pdf where partno='ss2422-5041' and brandshort='sanmotion' limit 1 [ RunTime:0.001285s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ss2422-5041' OR `brand` LIKE 'sanmotion%' ) ) LIMIT 1 [ RunTime:0.010943s ]
SELECT `id` FROM `stock` WHERE `id` <> 51073248 AND `partno` = 'ss2422-5041' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sanmotion%' ) [ RunTime:0.021250s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079342 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079342 ORDER BY `minOrder` ASC [ RunTime:0.005025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079342 ORDER BY `unit` DESC [ RunTime:0.005175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079342 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079342 ORDER BY `minOrder` ASC [ RunTime:0.006327s ]
select * from pdf where partno='SS24FL' and brandshort='onsemi' limit 1 [ RunTime:0.004295s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24FL' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.012963s ]
SELECT `id` FROM `stock` WHERE `id` <> 44079342 AND `partno` = 'SS24FL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.001420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9515 [ RunTime:0.003026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15579 [ RunTime:0.000263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16599 [ RunTime:0.000238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090575 LIMIT 5 [ RunTime:0.008091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090575 ORDER BY `minOrder` ASC [ RunTime:0.011881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090575 ORDER BY `unit` DESC [ RunTime:0.004171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090575 LIMIT 2 [ RunTime:0.004830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090575 ORDER BY `minOrder` ASC [ RunTime:0.007246s ]
select * from pdf where partno='SS24B' and brandshort='MDD' limit 1 [ RunTime:0.020026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24B' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.008771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080888 LIMIT 5 [ RunTime:0.000722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080888 ORDER BY `minOrder` ASC [ RunTime:0.013559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080888 ORDER BY `unit` DESC [ RunTime:0.003229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080888 LIMIT 2 [ RunTime:0.001333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080888 ORDER BY `minOrder` ASC [ RunTime:0.002687s ]
select * from pdf where partno='SS24M' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.026826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24M' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.007003s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080888 AND `partno` = 'SS24M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.002532s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44079589 LIMIT 5 [ RunTime:0.003641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079589 ORDER BY `minOrder` ASC [ RunTime:0.014295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44079589 ORDER BY `unit` DESC [ RunTime:0.014990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44079589 LIMIT 2 [ RunTime:0.004275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44079589 ORDER BY `minOrder` ASC [ RunTime:0.022134s ]
select * from pdf where partno='SS24-E3/52T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.011192s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24-E3/52T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.008049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080801 LIMIT 5 [ RunTime:0.009731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080801 ORDER BY `minOrder` ASC [ RunTime:0.022995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080801 ORDER BY `unit` DESC [ RunTime:0.003663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080801 LIMIT 2 [ RunTime:0.017784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080801 ORDER BY `minOrder` ASC [ RunTime:0.009516s ]
select * from pdf where partno='SS24-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.006265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.009501s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080801 AND `partno` = 'SS24-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081530 LIMIT 5 [ RunTime:0.021403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081530 ORDER BY `minOrder` ASC [ RunTime:0.042719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081530 ORDER BY `unit` DESC [ RunTime:0.012344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081530 LIMIT 2 [ RunTime:0.006988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081530 ORDER BY `minOrder` ASC [ RunTime:0.005219s ]
select * from pdf where partno='SS24S-M3/5AT' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006894s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24S-M3/5AT' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.015189s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081530 AND `partno` = 'SS24S-M3/5AT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090593 LIMIT 5 [ RunTime:0.002478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090593 ORDER BY `minOrder` ASC [ RunTime:0.001185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090593 ORDER BY `unit` DESC [ RunTime:0.004977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090593 LIMIT 2 [ RunTime:0.001850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090593 ORDER BY `minOrder` ASC [ RunTime:0.004244s ]
select * from pdf where partno='SS24' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.002292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.008318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081148 LIMIT 5 [ RunTime:0.004030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081148 ORDER BY `minOrder` ASC [ RunTime:0.013270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081148 ORDER BY `unit` DESC [ RunTime:0.002385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081148 LIMIT 2 [ RunTime:0.000342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081148 ORDER BY `minOrder` ASC [ RunTime:0.002775s ]
select * from pdf where partno='SS24S-E3/61T' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.014646s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24S-E3/61T' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.010294s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081148 AND `partno` = 'SS24S-E3/61T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.009042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44080386 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080386 ORDER BY `minOrder` ASC [ RunTime:0.001343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44080386 ORDER BY `unit` DESC [ RunTime:0.000511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44080386 LIMIT 2 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44080386 ORDER BY `minOrder` ASC [ RunTime:0.002453s ]
select * from pdf where partno='SS24-LTP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.001360s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24-LTP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003241s ]
SELECT `id` FROM `stock` WHERE `id` <> 44080386 AND `partno` = 'SS24-LTP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.006824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081385 LIMIT 5 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081385 ORDER BY `minOrder` ASC [ RunTime:0.000765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081385 ORDER BY `unit` DESC [ RunTime:0.002039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081385 LIMIT 2 [ RunTime:0.010678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081385 ORDER BY `minOrder` ASC [ RunTime:0.005115s ]
select * from pdf where partno='SS24SHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24SHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.001321s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081385 AND `partno` = 'SS24SHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.003723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081421 LIMIT 5 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081421 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081421 ORDER BY `unit` DESC [ RunTime:0.000677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081421 LIMIT 2 [ RunTime:0.000359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081421 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
select * from pdf where partno='SS24T3G' and brandshort='onsemi' limit 1 [ RunTime:0.001018s ]
select foldpath,foldpath2,filename from pdf_file where id=547739 limit 1 [ RunTime:0.008680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24T3G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.007443s ]
SELECT `id` FROM `stock` WHERE `id` <> 44081421 AND `partno` = 'SS24T3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086734 LIMIT 5 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086734 ORDER BY `minOrder` ASC [ RunTime:0.002651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086734 ORDER BY `unit` DESC [ RunTime:0.001719s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086734 LIMIT 2 [ RunTime:0.009767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086734 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
select * from pdf where partno='SS24FSH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.002125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24FSH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.001186s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086734 AND `partno` = 'SS24FSH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000923s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44083778 LIMIT 5 [ RunTime:0.000467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083778 ORDER BY `minOrder` ASC [ RunTime:0.001894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44083778 ORDER BY `unit` DESC [ RunTime:0.000779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44083778 LIMIT 2 [ RunTime:0.008522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44083778 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
select * from pdf where partno='SS24MH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.001686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24MH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.000673s ]
SELECT `id` FROM `stock` WHERE `id` <> 44083778 AND `partno` = 'SS24MH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44084335 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084335 ORDER BY `minOrder` ASC [ RunTime:0.007501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44084335 ORDER BY `unit` DESC [ RunTime:0.001883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44084335 LIMIT 2 [ RunTime:0.005413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44084335 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='SS24LH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24LH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.002574s ]
SELECT `id` FROM `stock` WHERE `id` <> 44084335 AND `partno` = 'SS24LH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.005550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090528 LIMIT 5 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090528 ORDER BY `minOrder` ASC [ RunTime:0.002805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090528 ORDER BY `unit` DESC [ RunTime:0.006035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090528 LIMIT 2 [ RunTime:0.002471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090528 ORDER BY `minOrder` ASC [ RunTime:0.005456s ]
select * from pdf where partno='SS24T3' and brandshort='onsemi' limit 1 [ RunTime:0.002893s ]
select foldpath,foldpath2,filename from pdf_file where id=547739 limit 1 [ RunTime:0.000341s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24T3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.008967s ]
SELECT `id` FROM `stock` WHERE `id` <> 44090528 AND `partno` = 'SS24T3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.000754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44086936 LIMIT 5 [ RunTime:0.003445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086936 ORDER BY `minOrder` ASC [ RunTime:0.003865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44086936 ORDER BY `unit` DESC [ RunTime:0.004123s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44086936 LIMIT 2 [ RunTime:0.003611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44086936 ORDER BY `minOrder` ASC [ RunTime:0.001682s ]
select * from pdf where partno='SS24SHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.007544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24SHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.003462s ]
SELECT `id` FROM `stock` WHERE `id` <> 44086936 AND `partno` = 'SS24SHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44081111 LIMIT 5 [ RunTime:0.005685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081111 ORDER BY `minOrder` ASC [ RunTime:0.012444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44081111 ORDER BY `unit` DESC [ RunTime:0.001815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44081111 LIMIT 2 [ RunTime:0.000736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44081111 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='SS24' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.000889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44093397 LIMIT 5 [ RunTime:0.020126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093397 ORDER BY `minOrder` ASC [ RunTime:0.005627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44093397 ORDER BY `unit` DESC [ RunTime:0.001569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44093397 LIMIT 2 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44093397 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='SS24F' and brandshort='MDD' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24F' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.006896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44090699 LIMIT 5 [ RunTime:0.002159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090699 ORDER BY `minOrder` ASC [ RunTime:0.001324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44090699 ORDER BY `unit` DESC [ RunTime:0.002335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44090699 LIMIT 2 [ RunTime:0.025921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44090699 ORDER BY `minOrder` ASC [ RunTime:0.001830s ]
select * from pdf where partno='SS24B' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.012847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24B' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.013285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60339129 LIMIT 5 [ RunTime:0.003540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339129 ORDER BY `minOrder` ASC [ RunTime:0.010318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60339129 ORDER BY `unit` DESC [ RunTime:0.003626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60339129 LIMIT 2 [ RunTime:0.008618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60339129 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
select * from pdf where partno='SS24W2T' and brandshort='Amphenol Sine Systems Corp' limit 1 [ RunTime:0.000471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SS24W2T' OR `brand` LIKE 'Amphenol Sine Systems Corp%' ) ) LIMIT 1 [ RunTime:0.000849s ]
SELECT `id` FROM `stock` WHERE `id` <> 60339129 AND `partno` = 'SS24W2T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sine systems corp%' ) [ RunTime:0.012593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12886243 [ RunTime:0.003139s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013907s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002942s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001633s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001125s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009993s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001965s ]
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 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003861s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SS24%' OR `brand` LIKE 'SS24%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001894s ]