SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001302s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=P6SMB47A&search=1' [ RunTime:0.009151s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001978s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003117s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001895s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001312s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001756s ]
SELECT * FROM `stock_search` WHERE `partno` = 'P6SMB47A' LIMIT 1 [ RunTime:0.058919s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-16 17:28:57' WHERE `partno` = 'P6SMB47A' [ RunTime:0.013032s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001533s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050750s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801685 LIMIT 5 [ RunTime:0.025944s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801685 ORDER BY `minOrder` ASC [ RunTime:0.011126s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14801685 ORDER BY `unit` DESC [ RunTime:0.022411s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.027485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14801685 LIMIT 2 [ RunTime:0.043496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14801685 ORDER BY `minOrder` ASC [ RunTime:0.000399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662490 LIMIT 5 [ RunTime:0.049863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662490 ORDER BY `minOrder` ASC [ RunTime:0.054162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16662490 ORDER BY `unit` DESC [ RunTime:0.027901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16662490 LIMIT 2 [ RunTime:0.037284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16662490 ORDER BY `minOrder` ASC [ RunTime:0.034847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813540 LIMIT 5 [ RunTime:0.031955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813540 ORDER BY `minOrder` ASC [ RunTime:0.055133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14813540 ORDER BY `unit` DESC [ RunTime:0.013659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14813540 LIMIT 2 [ RunTime:0.032286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14813540 ORDER BY `minOrder` ASC [ RunTime:0.031588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818041 LIMIT 5 [ RunTime:0.032226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818041 ORDER BY `minOrder` ASC [ RunTime:0.088946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818041 ORDER BY `unit` DESC [ RunTime:0.030039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818041 LIMIT 2 [ RunTime:0.030580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818041 ORDER BY `minOrder` ASC [ RunTime:0.046094s ]
select * from pdf where partno='P6SMB47A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.029462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13905680 LIMIT 5 [ RunTime:0.017008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905680 ORDER BY `minOrder` ASC [ RunTime:0.015009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13905680 ORDER BY `unit` DESC [ RunTime:0.028547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13905680 LIMIT 2 [ RunTime:0.023869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13905680 ORDER BY `minOrder` ASC [ RunTime:0.002340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803609 LIMIT 5 [ RunTime:0.009981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803609 ORDER BY `minOrder` ASC [ RunTime:0.012798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14803609 ORDER BY `unit` DESC [ RunTime:0.012870s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14803609 LIMIT 2 [ RunTime:0.016250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14803609 ORDER BY `minOrder` ASC [ RunTime:0.011630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907450 LIMIT 5 [ RunTime:0.012459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907450 ORDER BY `minOrder` ASC [ RunTime:0.018670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13907450 ORDER BY `unit` DESC [ RunTime:0.012662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13907450 LIMIT 2 [ RunTime:0.003975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13907450 ORDER BY `minOrder` ASC [ RunTime:0.003173s ]
select * from pdf where partno='P6SMB47A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.001542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671517 LIMIT 5 [ RunTime:0.002300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671517 ORDER BY `minOrder` ASC [ RunTime:0.007978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671517 ORDER BY `unit` DESC [ RunTime:0.009040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671517 LIMIT 2 [ RunTime:0.028312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671517 ORDER BY `minOrder` ASC [ RunTime:0.016053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671516 LIMIT 5 [ RunTime:0.015895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671516 ORDER BY `minOrder` ASC [ RunTime:0.010449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16671516 ORDER BY `unit` DESC [ RunTime:0.002227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16671516 LIMIT 2 [ RunTime:0.014416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16671516 ORDER BY `minOrder` ASC [ RunTime:0.010348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670425 LIMIT 5 [ RunTime:0.023124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670425 ORDER BY `minOrder` ASC [ RunTime:0.018299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16670425 ORDER BY `unit` DESC [ RunTime:0.019769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16670425 LIMIT 2 [ RunTime:0.007939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16670425 ORDER BY `minOrder` ASC [ RunTime:0.000933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16666700 LIMIT 5 [ RunTime:0.001215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666700 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16666700 ORDER BY `unit` DESC [ RunTime:0.006381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16666700 LIMIT 2 [ RunTime:0.026733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16666700 ORDER BY `minOrder` ASC [ RunTime:0.002371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14829561 LIMIT 5 [ RunTime:0.003970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829561 ORDER BY `minOrder` ASC [ RunTime:0.007809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14829561 ORDER BY `unit` DESC [ RunTime:0.011388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14829561 LIMIT 2 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14829561 ORDER BY `minOrder` ASC [ RunTime:0.011191s ]
select * from pdf where partno='P6SMB47AHE3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.023322s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14828950 LIMIT 5 [ RunTime:0.001872s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828950 ORDER BY `minOrder` ASC [ RunTime:0.001685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14828950 ORDER BY `unit` DESC [ RunTime:0.000932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14828950 LIMIT 2 [ RunTime:0.002397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14828950 ORDER BY `minOrder` ASC [ RunTime:0.000746s ]
select * from pdf where partno='P6SMB47AHE3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.018196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818100 LIMIT 5 [ RunTime:0.018004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818100 ORDER BY `minOrder` ASC [ RunTime:0.008459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14818100 ORDER BY `unit` DESC [ RunTime:0.003660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14818100 LIMIT 2 [ RunTime:0.000618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14818100 ORDER BY `minOrder` ASC [ RunTime:0.000428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811702 LIMIT 5 [ RunTime:0.014162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811702 ORDER BY `minOrder` ASC [ RunTime:0.033700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811702 ORDER BY `unit` DESC [ RunTime:0.017647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811702 LIMIT 2 [ RunTime:0.003843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811702 ORDER BY `minOrder` ASC [ RunTime:0.008851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811343 LIMIT 5 [ RunTime:0.015256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811343 ORDER BY `minOrder` ASC [ RunTime:0.009938s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811343 ORDER BY `unit` DESC [ RunTime:0.010362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811343 LIMIT 2 [ RunTime:0.003668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811343 ORDER BY `minOrder` ASC [ RunTime:0.007764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811270 LIMIT 5 [ RunTime:0.004471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811270 ORDER BY `minOrder` ASC [ RunTime:0.022267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14811270 ORDER BY `unit` DESC [ RunTime:0.015209s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14811270 LIMIT 2 [ RunTime:0.013236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14811270 ORDER BY `minOrder` ASC [ RunTime:0.008193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810903 LIMIT 5 [ RunTime:0.021793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810903 ORDER BY `minOrder` ASC [ RunTime:0.007693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810903 ORDER BY `unit` DESC [ RunTime:0.026942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810903 LIMIT 2 [ RunTime:0.019086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810903 ORDER BY `minOrder` ASC [ RunTime:0.011576s ]
select * from pdf where partno='P6SMB47A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.008453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810784 LIMIT 5 [ RunTime:0.002892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810784 ORDER BY `minOrder` ASC [ RunTime:0.010022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810784 ORDER BY `unit` DESC [ RunTime:0.004341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810784 LIMIT 2 [ RunTime:0.002805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810784 ORDER BY `minOrder` ASC [ RunTime:0.005478s ]
select * from pdf where partno='P6SMB47A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.025777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810363 LIMIT 5 [ RunTime:0.021646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810363 ORDER BY `minOrder` ASC [ RunTime:0.020407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14810363 ORDER BY `unit` DESC [ RunTime:0.013412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14810363 LIMIT 2 [ RunTime:0.022141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14810363 ORDER BY `minOrder` ASC [ RunTime:0.016977s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015109s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42159971 LIMIT 5 [ RunTime:0.004757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159971 ORDER BY `minOrder` ASC [ RunTime:0.025213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42159971 ORDER BY `unit` DESC [ RunTime:0.033067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42159971 LIMIT 2 [ RunTime:0.019632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42159971 ORDER BY `minOrder` ASC [ RunTime:0.002080s ]
select * from pdf where partno='P6SMB47A' and brandshort='NextGen Components' limit 1 [ RunTime:0.032982s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A' OR `brand` LIKE 'NextGen Components%' ) ) LIMIT 1 [ RunTime:0.014276s ]
SELECT `id` FROM `stock` WHERE `id` <> 42159971 AND `partno` = 'P6SMB47A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nextgen components%' ) [ RunTime:0.025010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14801685 [ RunTime:0.007375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42162186 LIMIT 5 [ RunTime:0.012658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162186 ORDER BY `minOrder` ASC [ RunTime:0.022500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42162186 ORDER BY `unit` DESC [ RunTime:0.066878s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42162186 LIMIT 2 [ RunTime:0.044815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42162186 ORDER BY `minOrder` ASC [ RunTime:0.005110s ]
select * from pdf where partno='P6SMB47AL0S47A' and brandshort='LGE Diodes' limit 1 [ RunTime:0.010391s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AL0S47A' OR `brand` LIKE 'LGE Diodes%' ) ) LIMIT 1 [ RunTime:0.029251s ]
SELECT `id` FROM `stock` WHERE `id` <> 42162186 AND `partno` = 'P6SMB47AL0S47A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lge diodes%' ) [ RunTime:0.030519s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112587 LIMIT 5 [ RunTime:0.068172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112587 ORDER BY `minOrder` ASC [ RunTime:0.036254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112587 ORDER BY `unit` DESC [ RunTime:0.035971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112587 LIMIT 2 [ RunTime:0.000756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112587 ORDER BY `minOrder` ASC [ RunTime:0.037119s ]
select * from pdf where partno='P6SMB47A' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.021199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.022988s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112587 AND `partno` = 'P6SMB47A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.028240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14813540 [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42150171 LIMIT 5 [ RunTime:0.035860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150171 ORDER BY `minOrder` ASC [ RunTime:0.069580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42150171 ORDER BY `unit` DESC [ RunTime:0.020414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42150171 LIMIT 2 [ RunTime:0.126060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42150171 ORDER BY `minOrder` ASC [ RunTime:0.012310s ]
select * from pdf where partno='P6SMB47AT3G' and brandshort='onsemi' limit 1 [ RunTime:0.012141s ]
select foldpath,foldpath2,filename from pdf_file where id=1109182 limit 1 [ RunTime:0.052324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AT3G' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028289s ]
SELECT `id` FROM `stock` WHERE `id` <> 42150171 AND `partno` = 'P6SMB47AT3G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.026997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16662490 [ RunTime:0.032733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42112599 LIMIT 5 [ RunTime:0.020275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112599 ORDER BY `minOrder` ASC [ RunTime:0.007360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42112599 ORDER BY `unit` DESC [ RunTime:0.026607s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42112599 LIMIT 2 [ RunTime:0.020638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42112599 ORDER BY `minOrder` ASC [ RunTime:0.008901s ]
select * from pdf where partno='P6SMB47A' and brandshort='Littelfuse Inc.' limit 1 [ RunTime:0.008366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A' OR `brand` LIKE 'Littelfuse Inc.%' ) ) LIMIT 1 [ RunTime:0.004606s ]
SELECT `id` FROM `stock` WHERE `id` <> 42112599 AND `partno` = 'P6SMB47A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%littelfuse inc.%' ) [ RunTime:0.019961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14818041 [ RunTime:0.008275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42147711 LIMIT 5 [ RunTime:0.005024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147711 ORDER BY `minOrder` ASC [ RunTime:0.007038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42147711 ORDER BY `unit` DESC [ RunTime:0.001011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42147711 LIMIT 2 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42147711 ORDER BY `minOrder` ASC [ RunTime:0.004978s ]
select * from pdf where partno='P6SMB47A/TR13' and brandshort='YAGEO' limit 1 [ RunTime:0.013247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A/TR13' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.014982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42173431 LIMIT 5 [ RunTime:0.019117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173431 ORDER BY `minOrder` ASC [ RunTime:0.022468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42173431 ORDER BY `unit` DESC [ RunTime:0.040794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42173431 LIMIT 2 [ RunTime:0.009810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42173431 ORDER BY `minOrder` ASC [ RunTime:0.001910s ]
select * from pdf where partno='P6SMB47A_R1_00001' and brandshort='Panjit International Inc.' limit 1 [ RunTime:0.013250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A_R1_00001' OR `brand` LIKE 'Panjit International Inc.%' ) ) LIMIT 1 [ RunTime:0.008938s ]
SELECT `id` FROM `stock` WHERE `id` <> 42173431 AND `partno` = 'P6SMB47A_R1_00001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%panjit international inc.%' ) [ RunTime:0.009037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14803609 [ RunTime:0.013755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42170059 LIMIT 5 [ RunTime:0.008431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170059 ORDER BY `minOrder` ASC [ RunTime:0.010394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42170059 ORDER BY `unit` DESC [ RunTime:0.011040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42170059 LIMIT 2 [ RunTime:0.020207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42170059 ORDER BY `minOrder` ASC [ RunTime:0.010597s ]
select * from pdf where partno='P6SMB47A-E3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.002986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A-E3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.023570s ]
SELECT `id` FROM `stock` WHERE `id` <> 42170059 AND `partno` = 'P6SMB47A-E3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13907450 [ RunTime:0.022418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240856 LIMIT 5 [ RunTime:0.018967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240856 ORDER BY `minOrder` ASC [ RunTime:0.007468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240856 ORDER BY `unit` DESC [ RunTime:0.000958s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240856 LIMIT 2 [ RunTime:0.006605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240856 ORDER BY `minOrder` ASC [ RunTime:0.003999s ]
select * from pdf where partno='P6SMB47AHM3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.006731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHM3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.019017s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240856 AND `partno` = 'P6SMB47AHM3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.006833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914337 [ RunTime:0.005775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42240853 LIMIT 5 [ RunTime:0.018895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240853 ORDER BY `minOrder` ASC [ RunTime:0.029715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42240853 ORDER BY `unit` DESC [ RunTime:0.008044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42240853 LIMIT 2 [ RunTime:0.003206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42240853 ORDER BY `minOrder` ASC [ RunTime:0.001355s ]
select * from pdf where partno='P6SMB47AHM3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.009885s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHM3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.037637s ]
SELECT `id` FROM `stock` WHERE `id` <> 42240853 AND `partno` = 'P6SMB47AHM3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.024879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671516 [ RunTime:0.055132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237047 LIMIT 5 [ RunTime:0.055200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237047 ORDER BY `minOrder` ASC [ RunTime:0.039465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237047 ORDER BY `unit` DESC [ RunTime:0.078300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237047 LIMIT 2 [ RunTime:0.041857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237047 ORDER BY `minOrder` ASC [ RunTime:0.009604s ]
select * from pdf where partno='P6SMB47AHE3_B/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.125143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHE3_B/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.054358s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237047 AND `partno` = 'P6SMB47AHE3_B/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.025908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16671517 [ RunTime:0.118484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42237046 LIMIT 5 [ RunTime:0.070075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237046 ORDER BY `minOrder` ASC [ RunTime:0.102254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42237046 ORDER BY `unit` DESC [ RunTime:0.045040s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42237046 LIMIT 2 [ RunTime:0.144146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42237046 ORDER BY `minOrder` ASC [ RunTime:0.034275s ]
select * from pdf where partno='P6SMB47AHE3_B/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.049643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHE3_B/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.045340s ]
SELECT `id` FROM `stock` WHERE `id` <> 42237046 AND `partno` = 'P6SMB47AHE3_B/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.055245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811343 [ RunTime:0.008798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42232904 LIMIT 5 [ RunTime:0.014813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232904 ORDER BY `minOrder` ASC [ RunTime:0.010030s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42232904 ORDER BY `unit` DESC [ RunTime:0.026734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42232904 LIMIT 2 [ RunTime:0.013703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42232904 ORDER BY `minOrder` ASC [ RunTime:0.004287s ]
select * from pdf where partno='P6SMB47A TR13 PBFREE' and brandshort='Central Semiconductor Corp' limit 1 [ RunTime:0.001234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A TR13 PBFREE' OR `brand` LIKE 'Central Semiconductor Corp%' ) ) LIMIT 1 [ RunTime:0.014293s ]
SELECT `id` FROM `stock` WHERE `id` <> 42232904 AND `partno` = 'P6SMB47A TR13 PBFREE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%central semiconductor corp%' ) [ RunTime:0.009667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811702 [ RunTime:0.006145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42227400 LIMIT 5 [ RunTime:0.013319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227400 ORDER BY `minOrder` ASC [ RunTime:0.019908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42227400 ORDER BY `unit` DESC [ RunTime:0.004261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42227400 LIMIT 2 [ RunTime:0.003298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42227400 ORDER BY `minOrder` ASC [ RunTime:0.000812s ]
select * from pdf where partno='P6SMB47AHM3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHM3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002467s ]
SELECT `id` FROM `stock` WHERE `id` <> 42227400 AND `partno` = 'P6SMB47AHM3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.012625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14811270 [ RunTime:0.002590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42225558 LIMIT 5 [ RunTime:0.001722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225558 ORDER BY `minOrder` ASC [ RunTime:0.005515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42225558 ORDER BY `unit` DESC [ RunTime:0.008109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42225558 LIMIT 2 [ RunTime:0.010410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42225558 ORDER BY `minOrder` ASC [ RunTime:0.015142s ]
select * from pdf where partno='P6SMB47AHM3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHM3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 42225558 AND `partno` = 'P6SMB47AHM3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.007827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13914055 [ RunTime:0.007533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42222469 LIMIT 5 [ RunTime:0.009374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222469 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42222469 ORDER BY `unit` DESC [ RunTime:0.033404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42222469 LIMIT 2 [ RunTime:0.020693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42222469 ORDER BY `minOrder` ASC [ RunTime:0.003057s ]
select * from pdf where partno='P6SMB47AHE3_A/H' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.005839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHE3_A/H' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 42222469 AND `partno` = 'P6SMB47AHE3_A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.001102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16670425 [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221859 LIMIT 5 [ RunTime:0.009848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221859 ORDER BY `minOrder` ASC [ RunTime:0.006464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221859 ORDER BY `unit` DESC [ RunTime:0.003207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221859 LIMIT 2 [ RunTime:0.013823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221859 ORDER BY `minOrder` ASC [ RunTime:0.007830s ]
select * from pdf where partno='P6SMB47AHE3_A/I' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.016027s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47AHE3_A/I' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.002553s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221859 AND `partno` = 'P6SMB47AHE3_A/I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.031454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810363 [ RunTime:0.001629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42221469 LIMIT 5 [ RunTime:0.004529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221469 ORDER BY `minOrder` ASC [ RunTime:0.014498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42221469 ORDER BY `unit` DESC [ RunTime:0.000681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42221469 LIMIT 2 [ RunTime:0.001105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42221469 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='P6SMB47A-M3/52' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A-M3/52' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000842s ]
SELECT `id` FROM `stock` WHERE `id` <> 42221469 AND `partno` = 'P6SMB47A-M3/52' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.010366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810903 [ RunTime:0.008594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42218110 LIMIT 5 [ RunTime:0.016197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218110 ORDER BY `minOrder` ASC [ RunTime:0.014778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42218110 ORDER BY `unit` DESC [ RunTime:0.005173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42218110 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218110 ORDER BY `minOrder` ASC [ RunTime:0.000185s ]
select * from pdf where partno='P6SMB47A-M3/5B' and brandshort='Vishay General Semiconductor - Diodes Division' limit 1 [ RunTime:0.000399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A-M3/5B' OR `brand` LIKE 'Vishay General Semiconductor - Diodes Division%' ) ) LIMIT 1 [ RunTime:0.000372s ]
SELECT `id` FROM `stock` WHERE `id` <> 42218110 AND `partno` = 'P6SMB47A-M3/5B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay general semiconductor - diodes division%' ) [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14810784 [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42218080 LIMIT 5 [ RunTime:0.000935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218080 ORDER BY `minOrder` ASC [ RunTime:0.000285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42218080 ORDER BY `unit` DESC [ RunTime:0.000834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42218080 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42218080 ORDER BY `minOrder` ASC [ RunTime:0.000166s ]
select * from pdf where partno='P6SMB47A-Q' and brandshort='Bourns Inc.' limit 1 [ RunTime:0.003833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'P6SMB47A-Q' OR `brand` LIKE 'Bourns Inc.%' ) ) LIMIT 1 [ RunTime:0.004059s ]
SELECT `id` FROM `stock` WHERE `id` <> 42218080 AND `partno` = 'P6SMB47A-Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bourns inc.%' ) [ RunTime:0.003959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13912738 [ RunTime:0.004058s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003597s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001360s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012636s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009951s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001483s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012692s ]
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 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008756s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'P6SMB47A%' OR `brand` LIKE 'P6SMB47A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005170s ]