SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001219s ]
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=SMCJ300A&search=1' [ RunTime:0.008796s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001266s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006749s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002022s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006233s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001109s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001686s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001141s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMCJ300A' LIMIT 1 [ RunTime:0.032381s ]
UPDATE `stock_search` SET `count` = 18 , `updatetime` = '2026-08-25 23:57:50' WHERE `partno` = 'SMCJ300A' [ RunTime:0.007426s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001297s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013296s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16680973 LIMIT 5 [ RunTime:0.025983s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680973 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16680973 ORDER BY `unit` DESC [ RunTime:0.023910s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16680973 LIMIT 2 [ RunTime:0.045563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16680973 ORDER BY `minOrder` ASC [ RunTime:0.015547s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16679690 LIMIT 5 [ RunTime:0.040803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679690 ORDER BY `minOrder` ASC [ RunTime:0.042870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16679690 ORDER BY `unit` DESC [ RunTime:0.013335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16679690 LIMIT 2 [ RunTime:0.014362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16679690 ORDER BY `minOrder` ASC [ RunTime:0.010108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14809533 LIMIT 5 [ RunTime:0.006329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809533 ORDER BY `minOrder` ASC [ RunTime:0.041880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14809533 ORDER BY `unit` DESC [ RunTime:0.018890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14809533 LIMIT 2 [ RunTime:0.029954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14809533 ORDER BY `minOrder` ASC [ RunTime:0.016967s ]
select * from pdf where partno='SMCJ300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.013481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802105 LIMIT 5 [ RunTime:0.013993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802105 ORDER BY `minOrder` ASC [ RunTime:0.016163s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802105 ORDER BY `unit` DESC [ RunTime:0.023067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802105 LIMIT 2 [ RunTime:0.014042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802105 ORDER BY `minOrder` ASC [ RunTime:0.007118s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16690798 LIMIT 5 [ RunTime:0.025699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690798 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16690798 ORDER BY `unit` DESC [ RunTime:0.025714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16690798 LIMIT 2 [ RunTime:0.011605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16690798 ORDER BY `minOrder` ASC [ RunTime:0.006363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675371 LIMIT 5 [ RunTime:0.001586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675371 ORDER BY `minOrder` ASC [ RunTime:0.007997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16675371 ORDER BY `unit` DESC [ RunTime:0.004256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16675371 LIMIT 2 [ RunTime:0.018144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16675371 ORDER BY `minOrder` ASC [ RunTime:0.005848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673218 LIMIT 5 [ RunTime:0.016899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673218 ORDER BY `minOrder` ASC [ RunTime:0.009525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16673218 ORDER BY `unit` DESC [ RunTime:0.007542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16673218 LIMIT 2 [ RunTime:0.007954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16673218 ORDER BY `minOrder` ASC [ RunTime:0.006060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671284 LIMIT 5 [ RunTime:0.030089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671284 ORDER BY `minOrder` ASC [ RunTime:0.008813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671284 ORDER BY `unit` DESC [ RunTime:0.010153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671284 LIMIT 2 [ RunTime:0.004877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671284 ORDER BY `minOrder` ASC [ RunTime:0.000603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815181 LIMIT 5 [ RunTime:0.008515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815181 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14815181 ORDER BY `unit` DESC [ RunTime:0.010515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14815181 LIMIT 2 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14815181 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921076 LIMIT 5 [ RunTime:0.000800s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921076 ORDER BY `minOrder` ASC [ RunTime:0.023381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13921076 ORDER BY `unit` DESC [ RunTime:0.006688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13921076 LIMIT 2 [ RunTime:0.004546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13921076 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919084 LIMIT 5 [ RunTime:0.003908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919084 ORDER BY `minOrder` ASC [ RunTime:0.009078s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13919084 ORDER BY `unit` DESC [ RunTime:0.046776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13919084 LIMIT 2 [ RunTime:0.028892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13919084 ORDER BY `minOrder` ASC [ RunTime:0.009636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916129 LIMIT 5 [ RunTime:0.032991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916129 ORDER BY `minOrder` ASC [ RunTime:0.013173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916129 ORDER BY `unit` DESC [ RunTime:0.019787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916129 LIMIT 2 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916129 ORDER BY `minOrder` ASC [ RunTime:0.002064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13915305 LIMIT 5 [ RunTime:0.006514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915305 ORDER BY `minOrder` ASC [ RunTime:0.006601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13915305 ORDER BY `unit` DESC [ RunTime:0.014078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13915305 LIMIT 2 [ RunTime:0.014134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13915305 ORDER BY `minOrder` ASC [ RunTime:0.011288s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51141351 LIMIT 5 [ RunTime:0.009315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141351 ORDER BY `minOrder` ASC [ RunTime:0.016130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51141351 ORDER BY `unit` DESC [ RunTime:0.013405s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51141351 LIMIT 2 [ RunTime:0.002255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51141351 ORDER BY `minOrder` ASC [ RunTime:0.008257s ]
select * from pdf where partno='smcj300a' and brandshort='bourns' limit 1 [ RunTime:0.022452s ]
select foldpath,foldpath2,filename from pdf_file where id=1553899 limit 1 [ RunTime:0.007001s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smcj300a' OR `brand` LIKE 'bourns%' ) ) LIMIT 1 [ RunTime:0.031745s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42119774 LIMIT 5 [ RunTime:0.012578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119774 ORDER BY `minOrder` ASC [ RunTime:0.015543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42119774 ORDER BY `unit` DESC [ RunTime:0.010457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42119774 LIMIT 2 [ RunTime:0.022960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42119774 ORDER BY `minOrder` ASC [ RunTime:0.010888s ]
select * from pdf where partno='SMCJ300A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.009028s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.008495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42106753 LIMIT 5 [ RunTime:0.039348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106753 ORDER BY `minOrder` ASC [ RunTime:0.010745s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42106753 ORDER BY `unit` DESC [ RunTime:0.000829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42106753 LIMIT 2 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42106753 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
select * from pdf where partno='SMCJ300A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.003780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.006227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42128987 LIMIT 5 [ RunTime:0.015575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128987 ORDER BY `minOrder` ASC [ RunTime:0.007423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42128987 ORDER BY `unit` DESC [ RunTime:0.008582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42128987 LIMIT 2 [ RunTime:0.011545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42128987 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='SMCJ300A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.011282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.018611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42296397 LIMIT 5 [ RunTime:0.008496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296397 ORDER BY `minOrder` ASC [ RunTime:0.013677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42296397 ORDER BY `unit` DESC [ RunTime:0.004040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42296397 LIMIT 2 [ RunTime:0.021334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42296397 ORDER BY `minOrder` ASC [ RunTime:0.015765s ]
select * from pdf where partno='SMCJ300AE3/TR13' and brandshort='Microchip Technology' limit 1 [ RunTime:0.008999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300AE3/TR13' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002904s ]
SELECT `id` FROM `stock` WHERE `id` <> 42296397 AND `partno` = 'SMCJ300AE3/TR13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.019310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13921076 [ RunTime:0.031305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42283301 LIMIT 5 [ RunTime:0.016544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283301 ORDER BY `minOrder` ASC [ RunTime:0.023585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42283301 ORDER BY `unit` DESC [ RunTime:0.013915s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42283301 LIMIT 2 [ RunTime:0.022988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42283301 ORDER BY `minOrder` ASC [ RunTime:0.003548s ]
select * from pdf where partno='SMCJ300A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010996s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.017904s ]
SELECT `id` FROM `stock` WHERE `id` <> 42283301 AND `partno` = 'SMCJ300A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.024421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13919084 [ RunTime:0.035483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42275137 LIMIT 5 [ RunTime:0.026362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275137 ORDER BY `minOrder` ASC [ RunTime:0.023697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42275137 ORDER BY `unit` DESC [ RunTime:0.018858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42275137 LIMIT 2 [ RunTime:0.009929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42275137 ORDER BY `minOrder` ASC [ RunTime:0.021999s ]
select * from pdf where partno='SMCJ300AH' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.038914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300AH' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.020541s ]
SELECT `id` FROM `stock` WHERE `id` <> 42275137 AND `partno` = 'SMCJ300AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton - electronics division%' ) [ RunTime:0.019936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14815181 [ RunTime:0.010409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42273728 LIMIT 5 [ RunTime:0.060113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273728 ORDER BY `minOrder` ASC [ RunTime:0.018509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42273728 ORDER BY `unit` DESC [ RunTime:0.012300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42273728 LIMIT 2 [ RunTime:0.007262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42273728 ORDER BY `minOrder` ASC [ RunTime:0.016931s ]
select * from pdf where partno='SMCJ300A-HF' and brandshort='Comchip Technology' limit 1 [ RunTime:0.036828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A-HF' OR `brand` LIKE 'Comchip Technology%' ) ) LIMIT 1 [ RunTime:0.044736s ]
SELECT `id` FROM `stock` WHERE `id` <> 42273728 AND `partno` = 'SMCJ300A-HF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%comchip technology%' ) [ RunTime:0.018908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675371 [ RunTime:0.015330s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42259808 LIMIT 5 [ RunTime:0.037935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259808 ORDER BY `minOrder` ASC [ RunTime:0.012427s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42259808 ORDER BY `unit` DESC [ RunTime:0.034733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42259808 LIMIT 2 [ RunTime:0.031839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42259808 ORDER BY `minOrder` ASC [ RunTime:0.007661s ]
select * from pdf where partno='SMCJ300A' and brandshort='Eaton - Electronics Division' limit 1 [ RunTime:0.017494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A' OR `brand` LIKE 'Eaton - Electronics Division%' ) ) LIMIT 1 [ RunTime:0.009145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42230418 LIMIT 5 [ RunTime:0.029720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230418 ORDER BY `minOrder` ASC [ RunTime:0.029997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42230418 ORDER BY `unit` DESC [ RunTime:0.008092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42230418 LIMIT 2 [ RunTime:0.002604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230418 ORDER BY `minOrder` ASC [ RunTime:0.013969s ]
select * from pdf where partno='SMCJ300A-AT/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.028043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A-AT/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.053906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42230371 LIMIT 5 [ RunTime:0.016706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230371 ORDER BY `minOrder` ASC [ RunTime:0.012831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42230371 ORDER BY `unit` DESC [ RunTime:0.022643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42230371 LIMIT 2 [ RunTime:0.026028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42230371 ORDER BY `minOrder` ASC [ RunTime:0.030373s ]
select * from pdf where partno='SMCJ300A-AT/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.033884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A-AT/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.032739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42224041 LIMIT 5 [ RunTime:0.019306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42224041 ORDER BY `minOrder` ASC [ RunTime:0.028013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42224041 ORDER BY `unit` DESC [ RunTime:0.017479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42224041 LIMIT 2 [ RunTime:0.044116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42224041 ORDER BY `minOrder` ASC [ RunTime:0.010275s ]
select * from pdf where partno='SMCJ300A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.001238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMCJ300A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.007094s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020205s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035566s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021763s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010925s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015350s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069337s ]
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 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044556s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMCJ300A%' OR `brand` LIKE 'SMCJ300A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041814s ]