SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002505s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.195' , `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=BC817&search=1' [ RunTime:0.009359s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002348s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.014168s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002766s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.195' ) [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003523s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000903s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002817s ]
SELECT * FROM `stock_search` WHERE `partno` = 'BC817' LIMIT 1 [ RunTime:0.039715s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-29 09:08:00' WHERE `partno` = 'BC817' [ RunTime:0.012225s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003300s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005704s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20146455 LIMIT 5 [ RunTime:0.022014s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146455 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20146455 ORDER BY `unit` DESC [ RunTime:0.016521s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20146455 LIMIT 2 [ RunTime:0.002668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20146455 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
select * from pdf where partno='BC817-40' and brandshort='UMW' limit 1 [ RunTime:0.001516s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40' OR `brand` LIKE 'UMW(友台半导体)%' ) ) LIMIT 1 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 304 LIMIT 5 [ RunTime:0.027128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 304 ORDER BY `minOrder` ASC [ RunTime:0.040245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 304 ORDER BY `unit` DESC [ RunTime:0.047653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 304 LIMIT 2 [ RunTime:0.083242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 304 ORDER BY `minOrder` ASC [ RunTime:0.021571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.041367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 303 LIMIT 5 [ RunTime:0.047082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 303 ORDER BY `minOrder` ASC [ RunTime:0.009140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 303 ORDER BY `unit` DESC [ RunTime:0.033858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 303 LIMIT 2 [ RunTime:0.054041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 303 ORDER BY `minOrder` ASC [ RunTime:0.031825s ]
select * from pdf where partno='BC817,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.077865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.029031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14519 LIMIT 5 [ RunTime:0.008835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14519 ORDER BY `minOrder` ASC [ RunTime:0.030777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14519 ORDER BY `unit` DESC [ RunTime:0.020927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14519 LIMIT 2 [ RunTime:0.019719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14519 ORDER BY `minOrder` ASC [ RunTime:0.025665s ]
select * from pdf where partno='BC817-25LT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.034763s ]
select foldpath,foldpath2,filename from pdf_file where id=291321 limit 1 [ RunTime:0.069018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.067814s ]
SELECT `id` FROM `stock` WHERE `id` <> 14519 AND `partno` = 'BC817-25LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58606451 [ RunTime:0.050427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2097 LIMIT 5 [ RunTime:0.051906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2097 ORDER BY `minOrder` ASC [ RunTime:0.086739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2097 ORDER BY `unit` DESC [ RunTime:0.044548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2097 LIMIT 2 [ RunTime:0.028056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2097 ORDER BY `minOrder` ASC [ RunTime:0.005592s ]
select * from pdf where partno='BC817-16LT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.016247s ]
select foldpath,foldpath2,filename from pdf_file where id=317494 limit 1 [ RunTime:0.001324s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.023065s ]
SELECT `id` FROM `stock` WHERE `id` <> 2097 AND `partno` = 'BC817-16LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.025117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599210 [ RunTime:0.023910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13900 LIMIT 5 [ RunTime:0.011068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900 ORDER BY `minOrder` ASC [ RunTime:0.031590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13900 ORDER BY `unit` DESC [ RunTime:0.002357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13900 LIMIT 2 [ RunTime:0.006948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13900 ORDER BY `minOrder` ASC [ RunTime:0.000662s ]
select * from pdf where partno='BC817-16,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.002181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.025157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 6354 LIMIT 5 [ RunTime:0.012957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6354 ORDER BY `minOrder` ASC [ RunTime:0.011743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 6354 ORDER BY `unit` DESC [ RunTime:0.001444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 6354 LIMIT 2 [ RunTime:0.024737s ]
SELECT * FROM `stock_price` WHERE `stockid` = 6354 ORDER BY `minOrder` ASC [ RunTime:0.010439s ]
select * from pdf where partno='BC817-40LT1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.032187s ]
select foldpath,foldpath2,filename from pdf_file where id=382026 limit 1 [ RunTime:0.023724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40LT1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.038373s ]
SELECT `id` FROM `stock` WHERE `id` <> 6354 AND `partno` = 'BC817-40LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.024846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58606450 [ RunTime:0.011166s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4177 LIMIT 5 [ RunTime:0.016428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4177 ORDER BY `minOrder` ASC [ RunTime:0.033067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4177 ORDER BY `unit` DESC [ RunTime:0.031021s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4177 LIMIT 2 [ RunTime:0.027566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4177 ORDER BY `minOrder` ASC [ RunTime:0.005309s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.022436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17141 LIMIT 5 [ RunTime:0.024990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17141 ORDER BY `minOrder` ASC [ RunTime:0.018193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17141 ORDER BY `unit` DESC [ RunTime:0.018722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17141 LIMIT 2 [ RunTime:0.006048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17141 ORDER BY `minOrder` ASC [ RunTime:0.011434s ]
select * from pdf where partno='BC817-16,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.005132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.010097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17128 LIMIT 5 [ RunTime:0.006756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17128 ORDER BY `minOrder` ASC [ RunTime:0.017814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17128 ORDER BY `unit` DESC [ RunTime:0.007598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17128 LIMIT 2 [ RunTime:0.015389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17128 ORDER BY `minOrder` ASC [ RunTime:0.007259s ]
select * from pdf where partno='BC817,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.009497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.010568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16123 LIMIT 5 [ RunTime:0.001650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16123 ORDER BY `minOrder` ASC [ RunTime:0.031388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16123 ORDER BY `unit` DESC [ RunTime:0.020966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16123 LIMIT 2 [ RunTime:0.030164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16123 ORDER BY `minOrder` ASC [ RunTime:0.006596s ]
select * from pdf where partno='BC817-16,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.012168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.008365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16110 LIMIT 5 [ RunTime:0.015959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16110 ORDER BY `minOrder` ASC [ RunTime:0.012327s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16110 ORDER BY `unit` DESC [ RunTime:0.006839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16110 LIMIT 2 [ RunTime:0.005813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16110 ORDER BY `minOrder` ASC [ RunTime:0.006140s ]
select * from pdf where partno='BC817,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.005607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.007157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 24671 LIMIT 5 [ RunTime:0.005555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24671 ORDER BY `minOrder` ASC [ RunTime:0.009378s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 24671 ORDER BY `unit` DESC [ RunTime:0.024227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 24671 LIMIT 2 [ RunTime:0.017969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 24671 ORDER BY `minOrder` ASC [ RunTime:0.017765s ]
select * from pdf where partno='BC817-25' and brandshort='NA' limit 1 [ RunTime:0.038752s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25' OR `brand` LIKE 'NA%' ) ) LIMIT 1 [ RunTime:0.023984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 22887 LIMIT 5 [ RunTime:0.030241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22887 ORDER BY `minOrder` ASC [ RunTime:0.035989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 22887 ORDER BY `unit` DESC [ RunTime:0.032064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 22887 LIMIT 2 [ RunTime:0.026799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 22887 ORDER BY `minOrder` ASC [ RunTime:0.014696s ]
select * from pdf where partno='BC817-16LT1G' and brandshort='ON' limit 1 [ RunTime:0.051592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16LT1G' OR `brand` LIKE 'ON%' ) ) LIMIT 1 [ RunTime:0.020103s ]
SELECT `id` FROM `stock` WHERE `id` <> 22887 AND `partno` = 'BC817-16LT1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%on%' ) [ RunTime:0.036782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2097 [ RunTime:0.010943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599210 [ RunTime:0.006278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 21232 LIMIT 5 [ RunTime:0.017380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21232 ORDER BY `minOrder` ASC [ RunTime:0.015328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 21232 ORDER BY `unit` DESC [ RunTime:0.033512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 21232 LIMIT 2 [ RunTime:0.055035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 21232 ORDER BY `minOrder` ASC [ RunTime:0.017268s ]
select * from pdf where partno='BC817,215' and brandshort='NXP' limit 1 [ RunTime:0.031411s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,215' OR `brand` LIKE 'NXP%' ) ) LIMIT 1 [ RunTime:0.026840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 4178 LIMIT 5 [ RunTime:0.053577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4178 ORDER BY `minOrder` ASC [ RunTime:0.013815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 4178 ORDER BY `unit` DESC [ RunTime:0.045625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 4178 LIMIT 2 [ RunTime:0.051442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 4178 ORDER BY `minOrder` ASC [ RunTime:0.037988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.051889s ]
SELECT `id` FROM `stock` WHERE `id` <> 4178 AND `partno` = 'BC817-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.037021s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086920s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601861 LIMIT 5 [ RunTime:0.055873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601861 ORDER BY `minOrder` ASC [ RunTime:0.078568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601861 ORDER BY `unit` DESC [ RunTime:0.073073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601861 LIMIT 2 [ RunTime:0.071600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601861 ORDER BY `minOrder` ASC [ RunTime:0.014899s ]
select * from pdf where partno='BC817-40LT1' and brandshort='onsemi' limit 1 [ RunTime:0.095360s ]
select foldpath,foldpath2,filename from pdf_file where id=382026 limit 1 [ RunTime:0.063448s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40LT1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.076578s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601861 AND `partno` = 'BC817-40LT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.173730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599140 LIMIT 5 [ RunTime:0.037355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599140 ORDER BY `minOrder` ASC [ RunTime:0.054431s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58599140 ORDER BY `unit` DESC [ RunTime:0.060986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58599140 LIMIT 2 [ RunTime:0.025919s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599140 ORDER BY `minOrder` ASC [ RunTime:0.041848s ]
select * from pdf where partno='BC817-40-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.033370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.028165s ]
SELECT `id` FROM `stock` WHERE `id` <> 58599140 AND `partno` = 'BC817-40-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.087451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601579 LIMIT 5 [ RunTime:0.019150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601579 ORDER BY `minOrder` ASC [ RunTime:0.063241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601579 ORDER BY `unit` DESC [ RunTime:0.030895s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601579 LIMIT 2 [ RunTime:0.045090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601579 ORDER BY `minOrder` ASC [ RunTime:0.010144s ]
select * from pdf where partno='BC817-25LT1' and brandshort='onsemi' limit 1 [ RunTime:0.010282s ]
select foldpath,foldpath2,filename from pdf_file where id=291321 limit 1 [ RunTime:0.009308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25LT1' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.013873s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601579 AND `partno` = 'BC817-25LT1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.034598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601502 LIMIT 5 [ RunTime:0.029011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601502 ORDER BY `minOrder` ASC [ RunTime:0.025806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601502 ORDER BY `unit` DESC [ RunTime:0.029089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601502 LIMIT 2 [ RunTime:0.030096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601502 ORDER BY `minOrder` ASC [ RunTime:0.045329s ]
select * from pdf where partno='BC817-16W' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.027357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16W' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.016003s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601502 AND `partno` = 'BC817-16W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.017455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601503 LIMIT 5 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601503 ORDER BY `minOrder` ASC [ RunTime:0.010573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601503 ORDER BY `unit` DESC [ RunTime:0.010833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601503 LIMIT 2 [ RunTime:0.013383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601503 ORDER BY `minOrder` ASC [ RunTime:0.008186s ]
select * from pdf where partno='BC817-16B5000' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.023610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16B5000' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.021621s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601503 AND `partno` = 'BC817-16B5000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.013061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58598902 LIMIT 5 [ RunTime:0.009725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598902 ORDER BY `minOrder` ASC [ RunTime:0.005791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58598902 ORDER BY `unit` DESC [ RunTime:0.004788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58598902 LIMIT 2 [ RunTime:0.000946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58598902 ORDER BY `minOrder` ASC [ RunTime:0.006408s ]
select * from pdf where partno='BC817-40' and brandshort='Diotec Semiconductor' limit 1 [ RunTime:0.009559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-40' OR `brand` LIKE 'Diotec Semiconductor%' ) ) LIMIT 1 [ RunTime:0.011866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44700568 LIMIT 5 [ RunTime:0.013924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44700568 ORDER BY `minOrder` ASC [ RunTime:0.010673s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44700568 ORDER BY `unit` DESC [ RunTime:0.029253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44700568 LIMIT 2 [ RunTime:0.022198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44700568 ORDER BY `minOrder` ASC [ RunTime:0.007132s ]
select * from pdf where partno='BC817-25LT3' and brandshort='onsemi' limit 1 [ RunTime:0.007858s ]
select foldpath,foldpath2,filename from pdf_file where id=291321 limit 1 [ RunTime:0.027816s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25LT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.046583s ]
SELECT `id` FROM `stock` WHERE `id` <> 44700568 AND `partno` = 'BC817-25LT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33188270 [ RunTime:0.042310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33188270 LIMIT 5 [ RunTime:0.030126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33188270 ORDER BY `minOrder` ASC [ RunTime:0.048346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33188270 ORDER BY `unit` DESC [ RunTime:0.050910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33188270 LIMIT 2 [ RunTime:0.072674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33188270 ORDER BY `minOrder` ASC [ RunTime:0.018727s ]
select * from pdf where partno='BC817-25LT3' and brandshort='onsemi' limit 1 [ RunTime:0.017820s ]
select foldpath,foldpath2,filename from pdf_file where id=291321 limit 1 [ RunTime:0.028964s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25LT3' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.002110s ]
SELECT `id` FROM `stock` WHERE `id` <> 33188270 AND `partno` = 'BC817-25LT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.017750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44700568 [ RunTime:0.066695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58616038 LIMIT 5 [ RunTime:0.043749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58616038 ORDER BY `minOrder` ASC [ RunTime:0.030208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58616038 ORDER BY `unit` DESC [ RunTime:0.030626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58616038 LIMIT 2 [ RunTime:0.019459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58616038 ORDER BY `minOrder` ASC [ RunTime:0.003428s ]
select * from pdf where partno='BC817UPNE6327HTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.019035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817UPNE6327HTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.046230s ]
SELECT `id` FROM `stock` WHERE `id` <> 58616038 AND `partno` = 'BC817UPNE6327HTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.023836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58602139 LIMIT 5 [ RunTime:0.038626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602139 ORDER BY `minOrder` ASC [ RunTime:0.036710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58602139 ORDER BY `unit` DESC [ RunTime:0.011757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58602139 LIMIT 2 [ RunTime:0.060415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602139 ORDER BY `minOrder` ASC [ RunTime:0.004409s ]
select * from pdf where partno='BC817-25' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.055839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.042943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599142 LIMIT 5 [ RunTime:0.006484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599142 ORDER BY `minOrder` ASC [ RunTime:0.127116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58599142 ORDER BY `unit` DESC [ RunTime:0.076517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58599142 LIMIT 2 [ RunTime:0.047554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599142 ORDER BY `minOrder` ASC [ RunTime:0.017932s ]
select * from pdf where partno='BC817-25-TP' and brandshort='MCC Micro Commercial Components' limit 1 [ RunTime:0.089099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25-TP' OR `brand` LIKE 'MCC (Micro Commercial Components)%' ) ) LIMIT 1 [ RunTime:0.033071s ]
SELECT `id` FROM `stock` WHERE `id` <> 58599142 AND `partno` = 'BC817-25-TP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mcc%' ) [ RunTime:0.024634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58604245 LIMIT 5 [ RunTime:0.047094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58604245 ORDER BY `minOrder` ASC [ RunTime:0.009493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58604245 ORDER BY `unit` DESC [ RunTime:0.023124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58604245 LIMIT 2 [ RunTime:0.059309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58604245 ORDER BY `minOrder` ASC [ RunTime:0.031736s ]
select * from pdf where partno='BC817K16E6327HTSA1' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.026991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817K16E6327HTSA1' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.049356s ]
SELECT `id` FROM `stock` WHERE `id` <> 58604245 AND `partno` = 'BC817K16E6327HTSA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.016479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58602150 LIMIT 5 [ RunTime:0.077271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602150 ORDER BY `minOrder` ASC [ RunTime:0.068617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58602150 ORDER BY `unit` DESC [ RunTime:0.049557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58602150 LIMIT 2 [ RunTime:0.156221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602150 ORDER BY `minOrder` ASC [ RunTime:0.055624s ]
select * from pdf where partno='BC817-25LT3H' and brandshort='onsemi' limit 1 [ RunTime:0.034300s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25LT3H' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.079927s ]
SELECT `id` FROM `stock` WHERE `id` <> 58602150 AND `partno` = 'BC817-25LT3H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.081634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601790 LIMIT 5 [ RunTime:0.060284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601790 ORDER BY `minOrder` ASC [ RunTime:0.002298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601790 ORDER BY `unit` DESC [ RunTime:0.021599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601790 LIMIT 2 [ RunTime:0.016053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601790 ORDER BY `minOrder` ASC [ RunTime:0.042485s ]
select * from pdf where partno='BC81716MTF' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.004610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC81716MTF' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.014657s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601790 AND `partno` = 'BC81716MTF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.029063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599121 LIMIT 5 [ RunTime:0.023366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599121 ORDER BY `minOrder` ASC [ RunTime:0.009972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58599121 ORDER BY `unit` DESC [ RunTime:0.031696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58599121 LIMIT 2 [ RunTime:0.007044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599121 ORDER BY `minOrder` ASC [ RunTime:0.001382s ]
select * from pdf where partno='BC817-16,235' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.005930s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16,235' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.001961s ]
SELECT `id` FROM `stock` WHERE `id` <> 58599121 AND `partno` = 'BC817-16,235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.002921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58602375 LIMIT 5 [ RunTime:0.006275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602375 ORDER BY `minOrder` ASC [ RunTime:0.017283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58602375 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58602375 LIMIT 2 [ RunTime:0.000897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58602375 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
select * from pdf where partno='BC817-25W' and brandshort='Shenzhen Slkormicro Semicon Co., Ltd.' limit 1 [ RunTime:0.020509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-25W' OR `brand` LIKE 'Shenzhen Slkormicro Semicon Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.010686s ]
SELECT `id` FROM `stock` WHERE `id` <> 58602375 AND `partno` = 'BC817-25W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%shenzhen slkormicro semicon co., ltd.%' ) [ RunTime:0.010222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601526 LIMIT 5 [ RunTime:0.002729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601526 ORDER BY `minOrder` ASC [ RunTime:0.004413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601526 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601526 LIMIT 2 [ RunTime:0.002621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601526 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='BC817-16B5003' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.007868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16B5003' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.005807s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601526 AND `partno` = 'BC817-16B5003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.010483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601287 LIMIT 5 [ RunTime:0.005905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601287 ORDER BY `minOrder` ASC [ RunTime:0.014608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601287 ORDER BY `unit` DESC [ RunTime:0.006065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601287 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601287 ORDER BY `minOrder` ASC [ RunTime:0.008871s ]
select * from pdf where partno='BC817-16QBH-QZ' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.019939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16QBH-QZ' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.018763s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601287 AND `partno` = 'BC817-16QBH-QZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.011912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58601533 LIMIT 5 [ RunTime:0.008413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601533 ORDER BY `minOrder` ASC [ RunTime:0.008364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58601533 ORDER BY `unit` DESC [ RunTime:0.008226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58601533 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58601533 ORDER BY `minOrder` ASC [ RunTime:0.001980s ]
select * from pdf where partno='BC817-16' and brandshort='Infineon Technologies' limit 1 [ RunTime:0.008317s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16' OR `brand` LIKE 'Infineon Technologies%' ) ) LIMIT 1 [ RunTime:0.009592s ]
SELECT `id` FROM `stock` WHERE `id` <> 58601533 AND `partno` = 'BC817-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%infineon technologies%' ) [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58599125 LIMIT 5 [ RunTime:0.010999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599125 ORDER BY `minOrder` ASC [ RunTime:0.019444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58599125 ORDER BY `unit` DESC [ RunTime:0.045756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58599125 LIMIT 2 [ RunTime:0.009559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58599125 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
select * from pdf where partno='BC817,235' and brandshort='Nexperia USA Inc.' limit 1 [ RunTime:0.001827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,235' OR `brand` LIKE 'Nexperia USA Inc.%' ) ) LIMIT 1 [ RunTime:0.008672s ]
SELECT `id` FROM `stock` WHERE `id` <> 58599125 AND `partno` = 'BC817,235' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nexperia usa inc.%' ) [ RunTime:0.016612s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015403s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032405s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004389s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001580s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001864s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013203s ]
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 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017109s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'BC817%' OR `brand` LIKE 'BC817%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.020935s ]