SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001592s ]
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=SMAJ9.0&search=1' [ RunTime:0.014259s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001377s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.015655s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001619s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001323s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006564s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001708s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMAJ9.0' LIMIT 1 [ RunTime:0.006734s ]
UPDATE `stock_search` SET `count` = 8 , `updatetime` = '2026-08-20 21:30:11' WHERE `partno` = 'SMAJ9.0' [ RunTime:0.010829s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001886s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036724s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16663571 LIMIT 5 [ RunTime:0.017595s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663571 ORDER BY `minOrder` ASC [ RunTime:0.016023s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16663571 ORDER BY `unit` DESC [ RunTime:0.028747s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.027474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16663571 LIMIT 2 [ RunTime:0.050741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16663571 ORDER BY `minOrder` ASC [ RunTime:0.007979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801871 LIMIT 5 [ RunTime:0.036085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801871 ORDER BY `minOrder` ASC [ RunTime:0.032569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801871 ORDER BY `unit` DESC [ RunTime:0.033458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801871 LIMIT 2 [ RunTime:0.003677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801871 ORDER BY `minOrder` ASC [ RunTime:0.010079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666232 LIMIT 5 [ RunTime:0.017831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666232 ORDER BY `minOrder` ASC [ RunTime:0.027838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666232 ORDER BY `unit` DESC [ RunTime:0.022648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666232 LIMIT 2 [ RunTime:0.027030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666232 ORDER BY `minOrder` ASC [ RunTime:0.015732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800912 LIMIT 5 [ RunTime:0.021569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800912 ORDER BY `minOrder` ASC [ RunTime:0.016082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800912 ORDER BY `unit` DESC [ RunTime:0.030037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800912 LIMIT 2 [ RunTime:0.021687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800912 ORDER BY `minOrder` ASC [ RunTime:0.011289s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.027197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802623 LIMIT 5 [ RunTime:0.020117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802623 ORDER BY `minOrder` ASC [ RunTime:0.013543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802623 ORDER BY `unit` DESC [ RunTime:0.006093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802623 LIMIT 2 [ RunTime:0.063730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802623 ORDER BY `minOrder` ASC [ RunTime:0.010425s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.018840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803466 LIMIT 5 [ RunTime:0.015979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803466 ORDER BY `minOrder` ASC [ RunTime:0.006252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803466 ORDER BY `unit` DESC [ RunTime:0.022520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803466 LIMIT 2 [ RunTime:0.022566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803466 ORDER BY `minOrder` ASC [ RunTime:0.013345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13909002 LIMIT 5 [ RunTime:0.011689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909002 ORDER BY `minOrder` ASC [ RunTime:0.035278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13909002 ORDER BY `unit` DESC [ RunTime:0.001928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13909002 LIMIT 2 [ RunTime:0.002359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13909002 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.011973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800588 LIMIT 5 [ RunTime:0.008228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800588 ORDER BY `minOrder` ASC [ RunTime:0.000844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800588 ORDER BY `unit` DESC [ RunTime:0.006771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800588 LIMIT 2 [ RunTime:0.008983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800588 ORDER BY `minOrder` ASC [ RunTime:0.002860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916283 LIMIT 5 [ RunTime:0.002614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916283 ORDER BY `minOrder` ASC [ RunTime:0.003149s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13916283 ORDER BY `unit` DESC [ RunTime:0.015604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13916283 LIMIT 2 [ RunTime:0.072457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13916283 ORDER BY `minOrder` ASC [ RunTime:0.007115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800689 LIMIT 5 [ RunTime:0.007895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800689 ORDER BY `minOrder` ASC [ RunTime:0.018978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800689 ORDER BY `unit` DESC [ RunTime:0.023696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800689 LIMIT 2 [ RunTime:0.017218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800689 ORDER BY `minOrder` ASC [ RunTime:0.017518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800803 LIMIT 5 [ RunTime:0.018676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800803 ORDER BY `minOrder` ASC [ RunTime:0.014976s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14800803 ORDER BY `unit` DESC [ RunTime:0.020112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14800803 LIMIT 2 [ RunTime:0.017088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14800803 ORDER BY `minOrder` ASC [ RunTime:0.005908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825946 LIMIT 5 [ RunTime:0.007447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825946 ORDER BY `minOrder` ASC [ RunTime:0.007598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14825946 ORDER BY `unit` DESC [ RunTime:0.010130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14825946 LIMIT 2 [ RunTime:0.026258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14825946 ORDER BY `minOrder` ASC [ RunTime:0.033199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925165 LIMIT 5 [ RunTime:0.006085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925165 ORDER BY `minOrder` ASC [ RunTime:0.015223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13925165 ORDER BY `unit` DESC [ RunTime:0.015873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13925165 LIMIT 2 [ RunTime:0.018561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13925165 ORDER BY `minOrder` ASC [ RunTime:0.006010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685037 LIMIT 5 [ RunTime:0.011094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685037 ORDER BY `minOrder` ASC [ RunTime:0.009486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16685037 ORDER BY `unit` DESC [ RunTime:0.005983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16685037 LIMIT 2 [ RunTime:0.007075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16685037 ORDER BY `minOrder` ASC [ RunTime:0.006839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802771 LIMIT 5 [ RunTime:0.003523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802771 ORDER BY `minOrder` ASC [ RunTime:0.008287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802771 ORDER BY `unit` DESC [ RunTime:0.009750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802771 LIMIT 2 [ RunTime:0.022638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802771 ORDER BY `minOrder` ASC [ RunTime:0.006060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662362 LIMIT 5 [ RunTime:0.006225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662362 ORDER BY `minOrder` ASC [ RunTime:0.007534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662362 ORDER BY `unit` DESC [ RunTime:0.008169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662362 LIMIT 2 [ RunTime:0.000729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662362 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801118 LIMIT 5 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801118 ORDER BY `minOrder` ASC [ RunTime:0.005915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801118 ORDER BY `unit` DESC [ RunTime:0.003048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801118 LIMIT 2 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801118 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802944 LIMIT 5 [ RunTime:0.001170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802944 ORDER BY `minOrder` ASC [ RunTime:0.000632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14802944 ORDER BY `unit` DESC [ RunTime:0.004499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14802944 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14802944 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803442 LIMIT 5 [ RunTime:0.001147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803442 ORDER BY `minOrder` ASC [ RunTime:0.010621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803442 ORDER BY `unit` DESC [ RunTime:0.001845s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803442 LIMIT 2 [ RunTime:0.008414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803442 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907428 LIMIT 5 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907428 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907428 ORDER BY `unit` DESC [ RunTime:0.001796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907428 LIMIT 2 [ RunTime:0.006972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907428 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001763s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42161000 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161000 ORDER BY `minOrder` ASC [ RunTime:0.000847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42161000 ORDER BY `unit` DESC [ RunTime:0.004275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42161000 LIMIT 2 [ RunTime:0.001957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42161000 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='MDD' limit 1 [ RunTime:0.001290s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.001611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42160989 LIMIT 5 [ RunTime:0.000472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160989 ORDER BY `minOrder` ASC [ RunTime:0.001864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42160989 ORDER BY `unit` DESC [ RunTime:0.001967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42160989 LIMIT 2 [ RunTime:0.000396s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42160989 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='MDD' limit 1 [ RunTime:0.001212s ]
select foldpath,foldpath2,filename from pdf_file where id=1100379 limit 1 [ RunTime:0.001172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A' OR `brand` LIKE 'MDD%' ) ) LIMIT 1 [ RunTime:0.001885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150457 LIMIT 5 [ RunTime:0.000456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150457 ORDER BY `minOrder` ASC [ RunTime:0.001556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150457 ORDER BY `unit` DESC [ RunTime:0.005493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150457 LIMIT 2 [ RunTime:0.003130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150457 ORDER BY `minOrder` ASC [ RunTime:0.005459s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='SMC Diode Solutions' limit 1 [ RunTime:0.005140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A' OR `brand` LIKE 'SMC Diode Solutions%' ) ) LIMIT 1 [ RunTime:0.001341s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150457 AND `partno` = 'SMAJ9.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%smc diode solutions%' ) [ RunTime:0.003744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800912 [ RunTime:0.005072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42101449 LIMIT 5 [ RunTime:0.004933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101449 ORDER BY `minOrder` ASC [ RunTime:0.006979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42101449 ORDER BY `unit` DESC [ RunTime:0.005631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42101449 LIMIT 2 [ RunTime:0.010317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42101449 ORDER BY `minOrder` ASC [ RunTime:0.002358s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.004252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.015354s ]
SELECT `id` FROM `stock` WHERE `id` <> 42101449 AND `partno` = 'SMAJ9.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.008165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666232 [ RunTime:0.008747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42099779 LIMIT 5 [ RunTime:0.001329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099779 ORDER BY `minOrder` ASC [ RunTime:0.008904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42099779 ORDER BY `unit` DESC [ RunTime:0.001504s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42099779 LIMIT 2 [ RunTime:0.002708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42099779 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='SMAJ9.0A-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.011751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.006969s ]
SELECT `id` FROM `stock` WHERE `id` <> 42099779 AND `partno` = 'SMAJ9.0A-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.005034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14800689 [ RunTime:0.007341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42095163 LIMIT 5 [ RunTime:0.002764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095163 ORDER BY `minOrder` ASC [ RunTime:0.004766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42095163 ORDER BY `unit` DESC [ RunTime:0.003380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42095163 LIMIT 2 [ RunTime:0.001639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42095163 ORDER BY `minOrder` ASC [ RunTime:0.002139s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.002325s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.001313s ]
SELECT `id` FROM `stock` WHERE `id` <> 42095163 AND `partno` = 'SMAJ9.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.014377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802623 [ RunTime:0.002891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42151145 LIMIT 5 [ RunTime:0.004559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151145 ORDER BY `minOrder` ASC [ RunTime:0.004564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42151145 ORDER BY `unit` DESC [ RunTime:0.000683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42151145 LIMIT 2 [ RunTime:0.003169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42151145 ORDER BY `minOrder` ASC [ RunTime:0.002262s ]
select * from pdf where partno='SMAJ9.0AH' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.009134s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0AH' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.005505s ]
SELECT `id` FROM `stock` WHERE `id` <> 42151145 AND `partno` = 'SMAJ9.0AH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.012672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112371 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112371 ORDER BY `minOrder` ASC [ RunTime:0.005469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112371 ORDER BY `unit` DESC [ RunTime:0.006080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112371 LIMIT 2 [ RunTime:0.013578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112371 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.005814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.001548s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112371 AND `partno` = 'SMAJ9.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.008135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803466 [ RunTime:0.005672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112936 LIMIT 5 [ RunTime:0.006930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112936 ORDER BY `minOrder` ASC [ RunTime:0.011407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112936 ORDER BY `unit` DESC [ RunTime:0.007584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112936 LIMIT 2 [ RunTime:0.003705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112936 ORDER BY `minOrder` ASC [ RunTime:0.007989s ]
select * from pdf where partno='SMAJ9.0CA-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.005809s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112936 AND `partno` = 'SMAJ9.0CA-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14825946 [ RunTime:0.001234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112385 LIMIT 5 [ RunTime:0.000737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112385 ORDER BY `minOrder` ASC [ RunTime:0.010404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112385 ORDER BY `unit` DESC [ RunTime:0.007393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112385 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112385 ORDER BY `minOrder` ASC [ RunTime:0.000573s ]
select * from pdf where partno='SMAJ9.0A-E3/61' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006753s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A-E3/61' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002524s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112385 AND `partno` = 'SMAJ9.0A-E3/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.011563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13916283 [ RunTime:0.001796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42123968 LIMIT 5 [ RunTime:0.007085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123968 ORDER BY `minOrder` ASC [ RunTime:0.002328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42123968 ORDER BY `unit` DESC [ RunTime:0.009949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42123968 LIMIT 2 [ RunTime:0.002232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42123968 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='SMAJ9.0A-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.010752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.003917s ]
SELECT `id` FROM `stock` WHERE `id` <> 42123968 AND `partno` = 'SMAJ9.0A-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.003542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13925165 [ RunTime:0.002428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42111997 LIMIT 5 [ RunTime:0.008467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111997 ORDER BY `minOrder` ASC [ RunTime:0.008020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42111997 ORDER BY `unit` DESC [ RunTime:0.014886s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42111997 LIMIT 2 [ RunTime:0.003515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42111997 ORDER BY `minOrder` ASC [ RunTime:0.010845s ]
select * from pdf where partno='SMAJ9.0CA-13-F' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.010353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA-13-F' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.002246s ]
SELECT `id` FROM `stock` WHERE `id` <> 42111997 AND `partno` = 'SMAJ9.0CA-13-F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.002033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16685037 [ RunTime:0.007561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42168309 LIMIT 5 [ RunTime:0.004240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168309 ORDER BY `minOrder` ASC [ RunTime:0.009978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42168309 ORDER BY `unit` DESC [ RunTime:0.003165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42168309 LIMIT 2 [ RunTime:0.000960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42168309 ORDER BY `minOrder` ASC [ RunTime:0.007274s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003068s ]
SELECT `id` FROM `stock` WHERE `id` <> 42168309 AND `partno` = 'SMAJ9.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14802771 [ RunTime:0.000927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42146465 LIMIT 5 [ RunTime:0.007542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146465 ORDER BY `minOrder` ASC [ RunTime:0.005025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42146465 ORDER BY `unit` DESC [ RunTime:0.003189s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42146465 LIMIT 2 [ RunTime:0.017432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42146465 ORDER BY `minOrder` ASC [ RunTime:0.001494s ]
select * from pdf where partno='SMAJ9.0CA' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.004571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.024784s ]
SELECT `id` FROM `stock` WHERE `id` <> 42146465 AND `partno` = 'SMAJ9.0CA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.034839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662362 [ RunTime:0.025353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169736 LIMIT 5 [ RunTime:0.037044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169736 ORDER BY `minOrder` ASC [ RunTime:0.016917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169736 ORDER BY `unit` DESC [ RunTime:0.035860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169736 LIMIT 2 [ RunTime:0.030891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169736 ORDER BY `minOrder` ASC [ RunTime:0.017671s ]
select * from pdf where partno='SMAJ9.0A/TR7' and brandshort='YAGEO' limit 1 [ RunTime:0.011452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A/TR7' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.038071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42172562 LIMIT 5 [ RunTime:0.042808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172562 ORDER BY `minOrder` ASC [ RunTime:0.010290s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42172562 ORDER BY `unit` DESC [ RunTime:0.021237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42172562 LIMIT 2 [ RunTime:0.024568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42172562 ORDER BY `minOrder` ASC [ RunTime:0.004271s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.012103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.004568s ]
SELECT `id` FROM `stock` WHERE `id` <> 42172562 AND `partno` = 'SMAJ9.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.005631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803442 [ RunTime:0.017077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42169457 LIMIT 5 [ RunTime:0.010884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169457 ORDER BY `minOrder` ASC [ RunTime:0.014949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42169457 ORDER BY `unit` DESC [ RunTime:0.015331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42169457 LIMIT 2 [ RunTime:0.005192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42169457 ORDER BY `minOrder` ASC [ RunTime:0.003720s ]
select * from pdf where partno='SMAJ9.0A' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.016600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010684s ]
SELECT `id` FROM `stock` WHERE `id` <> 42169457 AND `partno` = 'SMAJ9.0A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907428 [ RunTime:0.014255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42293848 LIMIT 5 [ RunTime:0.012565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293848 ORDER BY `minOrder` ASC [ RunTime:0.017807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42293848 ORDER BY `unit` DESC [ RunTime:0.000591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42293848 LIMIT 2 [ RunTime:0.011346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42293848 ORDER BY `minOrder` ASC [ RunTime:0.021996s ]
select * from pdf where partno='SMAJ9.0A-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.004437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0A-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.006831s ]
SELECT `id` FROM `stock` WHERE `id` <> 42293848 AND `partno` = 'SMAJ9.0A-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.009097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14819246 [ RunTime:0.037318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42289721 LIMIT 5 [ RunTime:0.021494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289721 ORDER BY `minOrder` ASC [ RunTime:0.020409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42289721 ORDER BY `unit` DESC [ RunTime:0.018925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42289721 LIMIT 2 [ RunTime:0.052234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42289721 ORDER BY `minOrder` ASC [ RunTime:0.007776s ]
select * from pdf where partno='SMAJ9.0CAHR3G' and brandshort='Taiwan Semiconductor Corporation' limit 1 [ RunTime:0.030477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CAHR3G' OR `brand` LIKE 'Taiwan Semiconductor Corporation%' ) ) LIMIT 1 [ RunTime:0.014869s ]
SELECT `id` FROM `stock` WHERE `id` <> 42289721 AND `partno` = 'SMAJ9.0CAHR3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%taiwan semiconductor corporation%' ) [ RunTime:0.014897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801118 [ RunTime:0.026484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42256228 LIMIT 5 [ RunTime:0.019466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256228 ORDER BY `minOrder` ASC [ RunTime:0.026767s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42256228 ORDER BY `unit` DESC [ RunTime:0.059643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42256228 LIMIT 2 [ RunTime:0.030428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42256228 ORDER BY `minOrder` ASC [ RunTime:0.008885s ]
select * from pdf where partno='SMAJ9.0CA-13' and brandshort='Diodes Incorporated' limit 1 [ RunTime:0.031978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMAJ9.0CA-13' OR `brand` LIKE 'Diodes Incorporated%' ) ) LIMIT 1 [ RunTime:0.034381s ]
SELECT `id` FROM `stock` WHERE `id` <> 42256228 AND `partno` = 'SMAJ9.0CA-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%diodes incorporated%' ) [ RunTime:0.031278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16673972 [ RunTime:0.039211s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041383s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022560s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011294s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017906s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020981s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064283s ]
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 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.078151s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMAJ9.0%' OR `brand` LIKE 'SMAJ9.0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.074251s ]