SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002241s ]
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=15KPA70C&search=1' [ RunTime:0.005946s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002294s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015855s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002564s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.162' ) [ RunTime:0.012651s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.004522s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007512s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001733s ]
SELECT * FROM `stock_search` WHERE `partno` = '15KPA70C' LIMIT 1 [ RunTime:0.014036s ]
UPDATE `stock_search` SET `count` = 13 , `updatetime` = '2026-08-18 12:16:31' WHERE `partno` = '15KPA70C' [ RunTime:0.024099s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002317s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.070526s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906400 LIMIT 5 [ RunTime:0.049385s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906400 ORDER BY `minOrder` ASC [ RunTime:0.011925s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13906400 ORDER BY `unit` DESC [ RunTime:0.003516s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13906400 LIMIT 2 [ RunTime:0.000894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13906400 ORDER BY `minOrder` ASC [ RunTime:0.015535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830875 LIMIT 5 [ RunTime:0.013067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830875 ORDER BY `minOrder` ASC [ RunTime:0.009436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14830875 ORDER BY `unit` DESC [ RunTime:0.010391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14830875 LIMIT 2 [ RunTime:0.010160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14830875 ORDER BY `minOrder` ASC [ RunTime:0.010462s ]
select * from pdf where partno='15KPA70CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800402 LIMIT 5 [ RunTime:0.010967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800402 ORDER BY `minOrder` ASC [ RunTime:0.010609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800402 ORDER BY `unit` DESC [ RunTime:0.010059s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800402 LIMIT 2 [ RunTime:0.020789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800402 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684396 LIMIT 5 [ RunTime:0.023748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684396 ORDER BY `minOrder` ASC [ RunTime:0.026602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16684396 ORDER BY `unit` DESC [ RunTime:0.021303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16684396 LIMIT 2 [ RunTime:0.042735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16684396 ORDER BY `minOrder` ASC [ RunTime:0.006747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683352 LIMIT 5 [ RunTime:0.011509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683352 ORDER BY `minOrder` ASC [ RunTime:0.009550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16683352 ORDER BY `unit` DESC [ RunTime:0.014652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16683352 LIMIT 2 [ RunTime:0.012456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16683352 ORDER BY `minOrder` ASC [ RunTime:0.003035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681954 LIMIT 5 [ RunTime:0.021712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681954 ORDER BY `minOrder` ASC [ RunTime:0.018764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16681954 ORDER BY `unit` DESC [ RunTime:0.004582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16681954 LIMIT 2 [ RunTime:0.019320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16681954 ORDER BY `minOrder` ASC [ RunTime:0.012026s ]
select * from pdf where partno='15KPA70CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.017437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680348 LIMIT 5 [ RunTime:0.018556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680348 ORDER BY `minOrder` ASC [ RunTime:0.015487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680348 ORDER BY `unit` DESC [ RunTime:0.010440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680348 LIMIT 2 [ RunTime:0.008521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680348 ORDER BY `minOrder` ASC [ RunTime:0.017491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13931033 LIMIT 5 [ RunTime:0.068417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931033 ORDER BY `minOrder` ASC [ RunTime:0.030777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13931033 ORDER BY `unit` DESC [ RunTime:0.007605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13931033 LIMIT 2 [ RunTime:0.013236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13931033 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13928610 LIMIT 5 [ RunTime:0.004436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928610 ORDER BY `minOrder` ASC [ RunTime:0.006450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13928610 ORDER BY `unit` DESC [ RunTime:0.001645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13928610 LIMIT 2 [ RunTime:0.003956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13928610 ORDER BY `minOrder` ASC [ RunTime:0.001286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925435 LIMIT 5 [ RunTime:0.038984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925435 ORDER BY `minOrder` ASC [ RunTime:0.031087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925435 ORDER BY `unit` DESC [ RunTime:0.023738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925435 LIMIT 2 [ RunTime:0.002494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925435 ORDER BY `minOrder` ASC [ RunTime:0.024456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924705 LIMIT 5 [ RunTime:0.029733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924705 ORDER BY `minOrder` ASC [ RunTime:0.012600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13924705 ORDER BY `unit` DESC [ RunTime:0.011776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13924705 LIMIT 2 [ RunTime:0.003282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13924705 ORDER BY `minOrder` ASC [ RunTime:0.003734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13923266 LIMIT 5 [ RunTime:0.014684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13923266 ORDER BY `minOrder` ASC [ RunTime:0.015127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13923266 ORDER BY `unit` DESC [ RunTime:0.001337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13923266 LIMIT 2 [ RunTime:0.000647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13923266 ORDER BY `minOrder` ASC [ RunTime:0.011038s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022082s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42158087 LIMIT 5 [ RunTime:0.011396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158087 ORDER BY `minOrder` ASC [ RunTime:0.024397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42158087 ORDER BY `unit` DESC [ RunTime:0.019621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42158087 LIMIT 2 [ RunTime:0.032682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42158087 ORDER BY `minOrder` ASC [ RunTime:0.010759s ]
select * from pdf where partno='15KPA70CA' and brandshort='MDE Semiconductor Inc' limit 1 [ RunTime:0.022890s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'MDE Semiconductor Inc%' ) ) LIMIT 1 [ RunTime:0.011460s ]
SELECT `id` FROM `stock` WHERE `id` <> 42158087 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mde semiconductor inc%' ) [ RunTime:0.011615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13906400 [ RunTime:0.000364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42109292 LIMIT 5 [ RunTime:0.001233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109292 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42109292 ORDER BY `unit` DESC [ RunTime:0.007984s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42109292 LIMIT 2 [ RunTime:0.004541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42109292 ORDER BY `minOrder` ASC [ RunTime:0.002531s ]
select * from pdf where partno='15KPA70CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.010576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.028019s ]
SELECT `id` FROM `stock` WHERE `id` <> 42109292 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.024812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14830875 [ RunTime:0.020170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42145098 LIMIT 5 [ RunTime:0.015324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145098 ORDER BY `minOrder` ASC [ RunTime:0.031578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42145098 ORDER BY `unit` DESC [ RunTime:0.051072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42145098 LIMIT 2 [ RunTime:0.003816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42145098 ORDER BY `minOrder` ASC [ RunTime:0.012791s ]
select * from pdf where partno='15KPA70CA/B' and brandshort='YAGEO' limit 1 [ RunTime:0.037588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA/B' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42418214 LIMIT 5 [ RunTime:0.005766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418214 ORDER BY `minOrder` ASC [ RunTime:0.010436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42418214 ORDER BY `unit` DESC [ RunTime:0.029656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42418214 LIMIT 2 [ RunTime:0.010136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42418214 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
select * from pdf where partno='15KPA70CA-HR' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-HR' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001957s ]
SELECT `id` FROM `stock` WHERE `id` <> 42418214 AND `partno` = '15KPA70CA-HR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.003766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16684396 [ RunTime:0.005878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42417661 LIMIT 5 [ RunTime:0.004587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417661 ORDER BY `minOrder` ASC [ RunTime:0.019139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42417661 ORDER BY `unit` DESC [ RunTime:0.015212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42417661 LIMIT 2 [ RunTime:0.021484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42417661 ORDER BY `minOrder` ASC [ RunTime:0.008462s ]
select * from pdf where partno='15KPA70CA-HRA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.015548s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-HRA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.005885s ]
SELECT `id` FROM `stock` WHERE `id` <> 42417661 AND `partno` = '15KPA70CA-HRA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.011329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925435 [ RunTime:0.019368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402400 LIMIT 5 [ RunTime:0.013158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402400 ORDER BY `minOrder` ASC [ RunTime:0.014693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402400 ORDER BY `unit` DESC [ RunTime:0.002300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402400 LIMIT 2 [ RunTime:0.005857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402400 ORDER BY `minOrder` ASC [ RunTime:0.000368s ]
select * from pdf where partno='15KPA70CE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.000846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.006631s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402400 AND `partno` = '15KPA70CE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.006379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13924705 [ RunTime:0.015372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42402399 LIMIT 5 [ RunTime:0.000931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402399 ORDER BY `minOrder` ASC [ RunTime:0.014436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42402399 ORDER BY `unit` DESC [ RunTime:0.009931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42402399 LIMIT 2 [ RunTime:0.002550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42402399 ORDER BY `minOrder` ASC [ RunTime:0.005670s ]
select * from pdf where partno='15KPA70CAE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.010001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CAE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.011878s ]
SELECT `id` FROM `stock` WHERE `id` <> 42402399 AND `partno` = '15KPA70CAE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.006323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16683352 [ RunTime:0.001845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42333090 LIMIT 5 [ RunTime:0.002102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333090 ORDER BY `minOrder` ASC [ RunTime:0.004229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42333090 ORDER BY `unit` DESC [ RunTime:0.012258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42333090 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42333090 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
select * from pdf where partno='15KPA70CA-B' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA-B' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.000694s ]
SELECT `id` FROM `stock` WHERE `id` <> 42333090 AND `partno` = '15KPA70CA-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.008811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16681954 [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42327522 LIMIT 5 [ RunTime:0.005836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327522 ORDER BY `minOrder` ASC [ RunTime:0.007243s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42327522 ORDER BY `unit` DESC [ RunTime:0.015237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42327522 LIMIT 2 [ RunTime:0.014368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42327522 ORDER BY `minOrder` ASC [ RunTime:0.003064s ]
select * from pdf where partno='15KPA70CA/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.001447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.010893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42313314 LIMIT 5 [ RunTime:0.001281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42313314 ORDER BY `minOrder` ASC [ RunTime:0.006309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42313314 ORDER BY `unit` DESC [ RunTime:0.011277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42313314 LIMIT 2 [ RunTime:0.010095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42313314 ORDER BY `minOrder` ASC [ RunTime:0.009464s ]
select * from pdf where partno='15KPA70CA' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.013862s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15KPA70CA' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.002496s ]
SELECT `id` FROM `stock` WHERE `id` <> 42313314 AND `partno` = '15KPA70CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.002691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680348 [ RunTime:0.016507s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015258s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008390s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003104s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001646s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003759s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003117s ]
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 '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002844s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15KPA70C%' OR `brand` LIKE '15KPA70C%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004664s ]