SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002044s ]
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=L12&search=1' [ RunTime:0.002192s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001127s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002124s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002531s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.004706s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003310s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005098s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002607s ]
SELECT * FROM `stock_search` WHERE `partno` = 'L12' LIMIT 1 [ RunTime:0.007197s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-23 06:29:15' WHERE `partno` = 'L12' [ RunTime:0.026238s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003195s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047797s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18883892 LIMIT 5 [ RunTime:0.043945s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18883892 ORDER BY `minOrder` ASC [ RunTime:0.010608s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18883892 ORDER BY `unit` DESC [ RunTime:0.008769s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18883892 LIMIT 2 [ RunTime:0.004931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18883892 ORDER BY `minOrder` ASC [ RunTime:0.000809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18870784 LIMIT 5 [ RunTime:0.006425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18870784 ORDER BY `minOrder` ASC [ RunTime:0.026683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18870784 ORDER BY `unit` DESC [ RunTime:0.002818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18870784 LIMIT 2 [ RunTime:0.012960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18870784 ORDER BY `minOrder` ASC [ RunTime:0.007670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18867943 LIMIT 5 [ RunTime:0.019042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867943 ORDER BY `minOrder` ASC [ RunTime:0.002273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18867943 ORDER BY `unit` DESC [ RunTime:0.004278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18867943 LIMIT 2 [ RunTime:0.003444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18867943 ORDER BY `minOrder` ASC [ RunTime:0.000994s ]
select * from pdf where partno='L128-MM00CA3500000' and brandshort='Lumileds' limit 1 [ RunTime:0.001812s ]
select foldpath,foldpath2,filename from pdf_file where id=1657475 limit 1 [ RunTime:0.006010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18894758 LIMIT 5 [ RunTime:0.005655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18894758 ORDER BY `minOrder` ASC [ RunTime:0.010249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18894758 ORDER BY `unit` DESC [ RunTime:0.029266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18894758 LIMIT 2 [ RunTime:0.053322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18894758 ORDER BY `minOrder` ASC [ RunTime:0.013204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18892066 LIMIT 5 [ RunTime:0.016765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18892066 ORDER BY `minOrder` ASC [ RunTime:0.017483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18892066 ORDER BY `unit` DESC [ RunTime:0.026375s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18892066 LIMIT 2 [ RunTime:0.023121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18892066 ORDER BY `minOrder` ASC [ RunTime:0.009836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014918 LIMIT 5 [ RunTime:0.009973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014918 ORDER BY `minOrder` ASC [ RunTime:0.009609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16014918 ORDER BY `unit` DESC [ RunTime:0.007753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16014918 LIMIT 2 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16014918 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18892044 LIMIT 5 [ RunTime:0.001009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18892044 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18892044 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18892044 LIMIT 2 [ RunTime:0.001218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18892044 ORDER BY `minOrder` ASC [ RunTime:0.005442s ]
select * from pdf where partno='L128-3080CA3500001' and brandshort='Lumileds' limit 1 [ RunTime:0.008718s ]
select foldpath,foldpath2,filename from pdf_file where id=1979791 limit 1 [ RunTime:0.002968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243794 LIMIT 5 [ RunTime:0.006790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243794 ORDER BY `minOrder` ASC [ RunTime:0.004685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243794 ORDER BY `unit` DESC [ RunTime:0.008974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243794 LIMIT 2 [ RunTime:0.002327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243794 ORDER BY `minOrder` ASC [ RunTime:0.001153s ]
select * from pdf where partno='L128-4080CA3500001' and brandshort='Lumileds' limit 1 [ RunTime:0.000939s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18872201 LIMIT 5 [ RunTime:0.001051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18872201 ORDER BY `minOrder` ASC [ RunTime:0.000710s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18872201 ORDER BY `unit` DESC [ RunTime:0.001739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18872201 LIMIT 2 [ RunTime:0.006153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18872201 ORDER BY `minOrder` ASC [ RunTime:0.001406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18871528 LIMIT 5 [ RunTime:0.001004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18871528 ORDER BY `minOrder` ASC [ RunTime:0.000614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18871528 ORDER BY `unit` DESC [ RunTime:0.001111s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18871528 LIMIT 2 [ RunTime:0.007692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18871528 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18871529 LIMIT 5 [ RunTime:0.000771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18871529 ORDER BY `minOrder` ASC [ RunTime:0.000549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18871529 ORDER BY `unit` DESC [ RunTime:0.001545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18871529 LIMIT 2 [ RunTime:0.007896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18871529 ORDER BY `minOrder` ASC [ RunTime:0.001659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243110 LIMIT 5 [ RunTime:0.001000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243110 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243110 ORDER BY `unit` DESC [ RunTime:0.003626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243110 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243110 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18872202 LIMIT 5 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18872202 ORDER BY `minOrder` ASC [ RunTime:0.007296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18872202 ORDER BY `unit` DESC [ RunTime:0.007566s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18872202 LIMIT 2 [ RunTime:0.003654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18872202 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243111 LIMIT 5 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243111 ORDER BY `minOrder` ASC [ RunTime:0.000715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243111 ORDER BY `unit` DESC [ RunTime:0.002580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243111 LIMIT 2 [ RunTime:0.003367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243111 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243112 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243112 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243112 ORDER BY `unit` DESC [ RunTime:0.003430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243112 LIMIT 2 [ RunTime:0.009870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243112 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14188121 LIMIT 5 [ RunTime:0.002284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14188121 ORDER BY `minOrder` ASC [ RunTime:0.000611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14188121 ORDER BY `unit` DESC [ RunTime:0.000557s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14188121 LIMIT 2 [ RunTime:0.004035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14188121 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243113 LIMIT 5 [ RunTime:0.000561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243113 ORDER BY `minOrder` ASC [ RunTime:0.010632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243113 ORDER BY `unit` DESC [ RunTime:0.005394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243113 LIMIT 2 [ RunTime:0.005869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243113 ORDER BY `minOrder` ASC [ RunTime:0.005660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15243114 LIMIT 5 [ RunTime:0.002283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243114 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15243114 ORDER BY `unit` DESC [ RunTime:0.002389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15243114 LIMIT 2 [ RunTime:0.000809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15243114 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17028157 LIMIT 5 [ RunTime:0.006467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17028157 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17028157 ORDER BY `unit` DESC [ RunTime:0.008046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17028157 LIMIT 2 [ RunTime:0.005147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17028157 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17028158 LIMIT 5 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17028158 ORDER BY `minOrder` ASC [ RunTime:0.001474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17028158 ORDER BY `unit` DESC [ RunTime:0.003748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17028158 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17028158 ORDER BY `minOrder` ASC [ RunTime:0.000952s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51064462 LIMIT 5 [ RunTime:0.001385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064462 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51064462 ORDER BY `unit` DESC [ RunTime:0.000356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51064462 LIMIT 2 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064462 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='l128-4080sa35a00g1' and brandshort='lumileds' limit 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-4080sa35a00g1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.000382s ]
SELECT `id` FROM `stock` WHERE `id` <> 51064462 AND `partno` = 'l128-4080sa35a00g1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16014425 [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51064461 LIMIT 5 [ RunTime:0.002429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064461 ORDER BY `minOrder` ASC [ RunTime:0.003286s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51064461 ORDER BY `unit` DESC [ RunTime:0.000503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51064461 LIMIT 2 [ RunTime:0.000340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064461 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='l128-3580sa35a00g1' and brandshort='lumileds' limit 1 [ RunTime:0.000432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-3580sa35a00g1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.000430s ]
SELECT `id` FROM `stock` WHERE `id` <> 51064461 AND `partno` = 'l128-3580sa35a00g1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.000392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18870834 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065485 LIMIT 5 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065485 ORDER BY `minOrder` ASC [ RunTime:0.003791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065485 ORDER BY `unit` DESC [ RunTime:0.002421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065485 LIMIT 2 [ RunTime:0.002690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065485 ORDER BY `minOrder` ASC [ RunTime:0.000666s ]
select * from pdf where partno='l128-4080sa35a00a1' and brandshort='lumileds' limit 1 [ RunTime:0.000839s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-4080sa35a00a1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.002685s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065485 AND `partno` = 'l128-4080sa35a00a1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.009358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17031946 [ RunTime:0.010781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065044 LIMIT 5 [ RunTime:0.004096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065044 ORDER BY `minOrder` ASC [ RunTime:0.006906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065044 ORDER BY `unit` DESC [ RunTime:0.001681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065044 LIMIT 2 [ RunTime:0.000644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065044 ORDER BY `minOrder` ASC [ RunTime:0.000447s ]
select * from pdf where partno='l128-50hgca3500000' and brandshort='lumileds' limit 1 [ RunTime:0.002665s ]
select foldpath,foldpath2,filename from pdf_file where id=1922911 limit 1 [ RunTime:0.003715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-50hgca3500000' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.006188s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065044 AND `partno` = 'l128-50hgca3500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.005343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18892066 [ RunTime:0.000794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51064537 LIMIT 5 [ RunTime:0.001289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064537 ORDER BY `minOrder` ASC [ RunTime:0.001224s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51064537 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51064537 LIMIT 2 [ RunTime:0.001434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064537 ORDER BY `minOrder` ASC [ RunTime:0.001796s ]
select * from pdf where partno='l128-3080ha35000h1' and brandshort='lumileds' limit 1 [ RunTime:0.007484s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-3080ha35000h1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.011159s ]
SELECT `id` FROM `stock` WHERE `id` <> 51064537 AND `partno` = 'l128-3080ha35000h1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.002466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41509274 [ RunTime:0.015407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227290 LIMIT 5 [ RunTime:0.008831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227290 ORDER BY `minOrder` ASC [ RunTime:0.014092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227290 ORDER BY `unit` DESC [ RunTime:0.005397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227290 LIMIT 2 [ RunTime:0.002105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227290 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='l128-6580ca3500001' and brandshort='lumileds' limit 1 [ RunTime:0.003524s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.000583s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-6580ca3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.007813s ]
SELECT `id` FROM `stock` WHERE `id` <> 32227290 AND `partno` = 'l128-6580ca3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.010172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14190870 [ RunTime:0.006908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32226048 LIMIT 5 [ RunTime:0.006866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226048 ORDER BY `minOrder` ASC [ RunTime:0.003606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32226048 ORDER BY `unit` DESC [ RunTime:0.004272s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32226048 LIMIT 2 [ RunTime:0.000471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226048 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
select * from pdf where partno='l128-6580ca3500001' and brandshort='lumileds' limit 1 [ RunTime:0.001900s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.006887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-6580ca3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.019385s ]
SELECT `id` FROM `stock` WHERE `id` <> 32226048 AND `partno` = 'l128-6580ca3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.001130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14190870 [ RunTime:0.003416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224881 LIMIT 5 [ RunTime:0.028718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224881 ORDER BY `minOrder` ASC [ RunTime:0.005199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224881 ORDER BY `unit` DESC [ RunTime:0.010179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224881 LIMIT 2 [ RunTime:0.005012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224881 ORDER BY `minOrder` ASC [ RunTime:0.004062s ]
select * from pdf where partno='l128-6580ca3500001' and brandshort='lumileds' limit 1 [ RunTime:0.006417s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.001617s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-6580ca3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.002916s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224881 AND `partno` = 'l128-6580ca3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.003813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14190870 [ RunTime:0.000443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32157967 LIMIT 5 [ RunTime:0.004046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32157967 ORDER BY `minOrder` ASC [ RunTime:0.001941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32157967 ORDER BY `unit` DESC [ RunTime:0.012944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32157967 LIMIT 2 [ RunTime:0.015137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32157967 ORDER BY `minOrder` ASC [ RunTime:0.002642s ]
select * from pdf where partno='l128-6580ca3500001' and brandshort='lumileds' limit 1 [ RunTime:0.009043s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.000442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-6580ca3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.000391s ]
SELECT `id` FROM `stock` WHERE `id` <> 32157967 AND `partno` = 'l128-6580ca3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.003446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14190870 [ RunTime:0.004139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32227242 LIMIT 5 [ RunTime:0.010260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227242 ORDER BY `minOrder` ASC [ RunTime:0.006689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32227242 ORDER BY `unit` DESC [ RunTime:0.006142s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32227242 LIMIT 2 [ RunTime:0.004243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32227242 ORDER BY `minOrder` ASC [ RunTime:0.001222s ]
select * from pdf where partno='l128-1890ha35000b1' and brandshort='lumileds' limit 1 [ RunTime:0.010663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-1890ha35000b1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.010553s ]
SELECT `id` FROM `stock` WHERE `id` <> 32227242 AND `partno` = 'l128-1890ha35000b1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.011397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191064 [ RunTime:0.001210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32226007 LIMIT 5 [ RunTime:0.009269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226007 ORDER BY `minOrder` ASC [ RunTime:0.005000s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32226007 ORDER BY `unit` DESC [ RunTime:0.021121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32226007 LIMIT 2 [ RunTime:0.013695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32226007 ORDER BY `minOrder` ASC [ RunTime:0.004032s ]
select * from pdf where partno='l128-1890ha35000b1' and brandshort='lumileds' limit 1 [ RunTime:0.002419s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-1890ha35000b1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.001315s ]
SELECT `id` FROM `stock` WHERE `id` <> 32226007 AND `partno` = 'l128-1890ha35000b1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.011023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191064 [ RunTime:0.005432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224842 LIMIT 5 [ RunTime:0.014383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224842 ORDER BY `minOrder` ASC [ RunTime:0.033113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224842 ORDER BY `unit` DESC [ RunTime:0.017630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224842 LIMIT 2 [ RunTime:0.018148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224842 ORDER BY `minOrder` ASC [ RunTime:0.010167s ]
select * from pdf where partno='l128-1890ha35000b1' and brandshort='lumileds' limit 1 [ RunTime:0.011531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-1890ha35000b1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.004758s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224842 AND `partno` = 'l128-1890ha35000b1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.029871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191064 [ RunTime:0.032236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32157928 LIMIT 5 [ RunTime:0.033023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32157928 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32157928 ORDER BY `unit` DESC [ RunTime:0.025264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32157928 LIMIT 2 [ RunTime:0.012303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32157928 ORDER BY `minOrder` ASC [ RunTime:0.001919s ]
select * from pdf where partno='l128-1890ha35000b1' and brandshort='lumileds' limit 1 [ RunTime:0.007623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-1890ha35000b1' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.030480s ]
SELECT `id` FROM `stock` WHERE `id` <> 32157928 AND `partno` = 'l128-1890ha35000b1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.017955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191064 [ RunTime:0.004895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065136 LIMIT 5 [ RunTime:0.004757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065136 ORDER BY `minOrder` ASC [ RunTime:0.014199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065136 ORDER BY `unit` DESC [ RunTime:0.023640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065136 LIMIT 2 [ RunTime:0.011881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065136 ORDER BY `minOrder` ASC [ RunTime:0.018130s ]
select * from pdf where partno='l128-4080cb3500001' and brandshort='lumileds' limit 1 [ RunTime:0.011523s ]
select foldpath,foldpath2,filename from pdf_file where id=1919992 limit 1 [ RunTime:0.036495s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-4080cb3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.017979s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065136 AND `partno` = 'l128-4080cb3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.009888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17030299 [ RunTime:0.011628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51064793 LIMIT 5 [ RunTime:0.000494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064793 ORDER BY `minOrder` ASC [ RunTime:0.018987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51064793 ORDER BY `unit` DESC [ RunTime:0.015842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51064793 LIMIT 2 [ RunTime:0.011902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064793 ORDER BY `minOrder` ASC [ RunTime:0.010637s ]
select * from pdf where partno='l128-3090na3500001' and brandshort='lumileds' limit 1 [ RunTime:0.008967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-3090na3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.001150s ]
SELECT `id` FROM `stock` WHERE `id` <> 51064793 AND `partno` = 'l128-3090na3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.004037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14190892 [ RunTime:0.006174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51064900 LIMIT 5 [ RunTime:0.010959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064900 ORDER BY `minOrder` ASC [ RunTime:0.008359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51064900 ORDER BY `unit` DESC [ RunTime:0.007341s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51064900 LIMIT 2 [ RunTime:0.003524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51064900 ORDER BY `minOrder` ASC [ RunTime:0.005473s ]
select * from pdf where partno='l128-3590ec3500001' and brandshort='lumileds' limit 1 [ RunTime:0.018245s ]
select foldpath,foldpath2,filename from pdf_file where id=1979793 limit 1 [ RunTime:0.001950s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-3590ec3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.006397s ]
SELECT `id` FROM `stock` WHERE `id` <> 51064900 AND `partno` = 'l128-3590ec3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.002734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18875071 [ RunTime:0.014268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51022562 LIMIT 5 [ RunTime:0.008687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51022562 ORDER BY `minOrder` ASC [ RunTime:0.002793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51022562 ORDER BY `unit` DESC [ RunTime:0.005765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51022562 LIMIT 2 [ RunTime:0.011588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51022562 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
select * from pdf where partno='l128-2290na3500001' and brandshort='lumileds' limit 1 [ RunTime:0.003939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-2290na3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.008472s ]
SELECT `id` FROM `stock` WHERE `id` <> 51022562 AND `partno` = 'l128-2290na3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.004444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18875075 [ RunTime:0.002346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065137 LIMIT 5 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065137 ORDER BY `minOrder` ASC [ RunTime:0.001718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065137 ORDER BY `unit` DESC [ RunTime:0.009605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065137 LIMIT 2 [ RunTime:0.006959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065137 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='l128-3080cb3500001' and brandshort='lumileds' limit 1 [ RunTime:0.004553s ]
select foldpath,foldpath2,filename from pdf_file where id=1979791 limit 1 [ RunTime:0.004070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-3080cb3500001' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.001865s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065137 AND `partno` = 'l128-3080cb3500001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.015397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14191071 [ RunTime:0.005940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065330 LIMIT 5 [ RunTime:0.007394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065330 ORDER BY `minOrder` ASC [ RunTime:0.007629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065330 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065330 LIMIT 2 [ RunTime:0.007154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065330 ORDER BY `minOrder` ASC [ RunTime:0.003254s ]
select * from pdf where partno='l128-1890ha35000b5' and brandshort='lumileds' limit 1 [ RunTime:0.005635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-1890ha35000b5' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.022085s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065330 AND `partno` = 'l128-1890ha35000b5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.005768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15247946 [ RunTime:0.013431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51065045 LIMIT 5 [ RunTime:0.006566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065045 ORDER BY `minOrder` ASC [ RunTime:0.010810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51065045 ORDER BY `unit` DESC [ RunTime:0.003963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51065045 LIMIT 2 [ RunTime:0.002671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51065045 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
select * from pdf where partno='l128-pco1003500000' and brandshort='lumileds' limit 1 [ RunTime:0.015070s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'l128-pco1003500000' OR `brand` LIKE 'lumileds%' ) ) LIMIT 1 [ RunTime:0.005442s ]
SELECT `id` FROM `stock` WHERE `id` <> 51065045 AND `partno` = 'l128-pco1003500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.005383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18898717 [ RunTime:0.026109s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41499138 LIMIT 5 [ RunTime:0.004229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41499138 ORDER BY `minOrder` ASC [ RunTime:0.002924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41499138 ORDER BY `unit` DESC [ RunTime:0.001670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41499138 LIMIT 2 [ RunTime:0.001456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41499138 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='L128-5780SA35A00G1' and brandshort='Lumileds' limit 1 [ RunTime:0.000556s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-5780SA35A00G1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.002629s ]
SELECT `id` FROM `stock` WHERE `id` <> 41499138 AND `partno` = 'L128-5780SA35A00G1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.006719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18883892 [ RunTime:0.004022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501548 LIMIT 5 [ RunTime:0.000827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501548 ORDER BY `minOrder` ASC [ RunTime:0.007951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501548 ORDER BY `unit` DESC [ RunTime:0.006027s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501548 LIMIT 2 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501548 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
select * from pdf where partno='L128-5790HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.000532s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-5790HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.001928s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501548 AND `partno` = 'L128-5790HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.002484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501547 LIMIT 5 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501547 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501547 ORDER BY `unit` DESC [ RunTime:0.003813s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501547 LIMIT 2 [ RunTime:0.003757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501547 ORDER BY `minOrder` ASC [ RunTime:0.005764s ]
select * from pdf where partno='L128-3590HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-3590HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.003145s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501547 AND `partno` = 'L128-3590HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.001279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501549 LIMIT 5 [ RunTime:0.000376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501549 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501549 ORDER BY `unit` DESC [ RunTime:0.002228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501549 LIMIT 2 [ RunTime:0.007776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501549 ORDER BY `minOrder` ASC [ RunTime:0.003754s ]
select * from pdf where partno='L128-2790HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.000536s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-2790HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.001414s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501549 AND `partno` = 'L128-2790HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.005164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501324 LIMIT 5 [ RunTime:0.006149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501324 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501324 ORDER BY `unit` DESC [ RunTime:0.005488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501324 LIMIT 2 [ RunTime:0.003259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501324 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
select * from pdf where partno='L128-4090SA35A0DF1' and brandshort='Lumileds' limit 1 [ RunTime:0.003886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4090SA35A0DF1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501324 AND `partno` = 'L128-4090SA35A0DF1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.000390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501325 LIMIT 5 [ RunTime:0.000328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501325 ORDER BY `minOrder` ASC [ RunTime:0.004097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501325 ORDER BY `unit` DESC [ RunTime:0.006747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501325 LIMIT 2 [ RunTime:0.002109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501325 ORDER BY `minOrder` ASC [ RunTime:0.001697s ]
select * from pdf where partno='L128-4090HA35000H1' and brandshort='Lumileds' limit 1 [ RunTime:0.000518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4090HA35000H1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.002735s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501325 AND `partno` = 'L128-4090HA35000H1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.005267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501317 LIMIT 5 [ RunTime:0.012089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501317 ORDER BY `minOrder` ASC [ RunTime:0.006135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501317 ORDER BY `unit` DESC [ RunTime:0.011332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501317 LIMIT 2 [ RunTime:0.018991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501317 ORDER BY `minOrder` ASC [ RunTime:0.012571s ]
select * from pdf where partno='L128-4070SA35A0DF1' and brandshort='Lumileds' limit 1 [ RunTime:0.004214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4070SA35A0DF1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.015679s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501317 AND `partno` = 'L128-4070SA35A0DF1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.020293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501318 LIMIT 5 [ RunTime:0.008417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501318 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501318 ORDER BY `unit` DESC [ RunTime:0.007472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501318 LIMIT 2 [ RunTime:0.021842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501318 ORDER BY `minOrder` ASC [ RunTime:0.010153s ]
select * from pdf where partno='L128-4080SA35A0DF1' and brandshort='Lumileds' limit 1 [ RunTime:0.001669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4080SA35A0DF1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.022362s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501318 AND `partno` = 'L128-4080SA35A0DF1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.026333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501319 LIMIT 5 [ RunTime:0.015784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501319 ORDER BY `minOrder` ASC [ RunTime:0.015763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501319 ORDER BY `unit` DESC [ RunTime:0.022735s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501319 LIMIT 2 [ RunTime:0.030594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501319 ORDER BY `minOrder` ASC [ RunTime:0.005931s ]
select * from pdf where partno='L128-4070HA35000H1' and brandshort='Lumileds' limit 1 [ RunTime:0.027850s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4070HA35000H1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.013352s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501319 AND `partno` = 'L128-4070HA35000H1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.011181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501550 LIMIT 5 [ RunTime:0.008749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501550 ORDER BY `minOrder` ASC [ RunTime:0.009070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501550 ORDER BY `unit` DESC [ RunTime:0.021085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501550 LIMIT 2 [ RunTime:0.022750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501550 ORDER BY `minOrder` ASC [ RunTime:0.017266s ]
select * from pdf where partno='L128-5090HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.020864s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-5090HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.009226s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501550 AND `partno` = 'L128-5090HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.016691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501285 LIMIT 5 [ RunTime:0.005746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501285 ORDER BY `minOrder` ASC [ RunTime:0.010862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501285 ORDER BY `unit` DESC [ RunTime:0.011400s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501285 LIMIT 2 [ RunTime:0.012610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501285 ORDER BY `minOrder` ASC [ RunTime:0.004473s ]
select * from pdf where partno='L128-4080SA35A00E1' and brandshort='Lumileds' limit 1 [ RunTime:0.012456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4080SA35A00E1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.015231s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501285 AND `partno` = 'L128-4080SA35A00E1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.013946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501312 LIMIT 5 [ RunTime:0.014421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501312 ORDER BY `minOrder` ASC [ RunTime:0.010595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501312 ORDER BY `unit` DESC [ RunTime:0.007385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501312 LIMIT 2 [ RunTime:0.024352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501312 ORDER BY `minOrder` ASC [ RunTime:0.012247s ]
select * from pdf where partno='L128-4080HA35000H1' and brandshort='Lumileds' limit 1 [ RunTime:0.005720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4080HA35000H1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.013734s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501312 AND `partno` = 'L128-4080HA35000H1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.022673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501320 LIMIT 5 [ RunTime:0.034780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501320 ORDER BY `minOrder` ASC [ RunTime:0.027978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501320 ORDER BY `unit` DESC [ RunTime:0.009890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501320 LIMIT 2 [ RunTime:0.008561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501320 ORDER BY `minOrder` ASC [ RunTime:0.005074s ]
select * from pdf where partno='L128-6580SA35A0DF1' and brandshort='Lumileds' limit 1 [ RunTime:0.017426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-6580SA35A0DF1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.024326s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501320 AND `partno` = 'L128-6580SA35A0DF1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.009137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501321 LIMIT 5 [ RunTime:0.019897s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501321 ORDER BY `minOrder` ASC [ RunTime:0.020885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501321 ORDER BY `unit` DESC [ RunTime:0.021642s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501321 LIMIT 2 [ RunTime:0.012804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501321 ORDER BY `minOrder` ASC [ RunTime:0.030227s ]
select * from pdf where partno='L128-2780SA35A0DF1' and brandshort='Lumileds' limit 1 [ RunTime:0.011676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-2780SA35A0DF1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.015814s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501321 AND `partno` = 'L128-2780SA35A0DF1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.041034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501304 LIMIT 5 [ RunTime:0.011777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501304 ORDER BY `minOrder` ASC [ RunTime:0.020529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501304 ORDER BY `unit` DESC [ RunTime:0.039307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501304 LIMIT 2 [ RunTime:0.053490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501304 ORDER BY `minOrder` ASC [ RunTime:0.007029s ]
select * from pdf where partno='L128-4080SA35A00F1' and brandshort='Lumileds' limit 1 [ RunTime:0.023828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4080SA35A00F1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.009652s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501304 AND `partno` = 'L128-4080SA35A00F1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.013199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501326 LIMIT 5 [ RunTime:0.029470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501326 ORDER BY `minOrder` ASC [ RunTime:0.043989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501326 ORDER BY `unit` DESC [ RunTime:0.015148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501326 LIMIT 2 [ RunTime:0.024561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501326 ORDER BY `minOrder` ASC [ RunTime:0.010255s ]
select * from pdf where partno='L128-5790HA35000H1' and brandshort='Lumileds' limit 1 [ RunTime:0.037509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-5790HA35000H1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.022151s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501326 AND `partno` = 'L128-5790HA35000H1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.008611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501551 LIMIT 5 [ RunTime:0.018666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501551 ORDER BY `minOrder` ASC [ RunTime:0.006229s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501551 ORDER BY `unit` DESC [ RunTime:0.010379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501551 LIMIT 2 [ RunTime:0.050403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501551 ORDER BY `minOrder` ASC [ RunTime:0.012582s ]
select * from pdf where partno='L128-4090HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.043610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-4090HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.032303s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501551 AND `partno` = 'L128-4090HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.013531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41499799 LIMIT 5 [ RunTime:0.024501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41499799 ORDER BY `minOrder` ASC [ RunTime:0.034356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41499799 ORDER BY `unit` DESC [ RunTime:0.028230s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41499799 LIMIT 2 [ RunTime:0.029086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41499799 ORDER BY `minOrder` ASC [ RunTime:0.023028s ]
select * from pdf where partno='L128-27HGCA3500000' and brandshort='Lumileds' limit 1 [ RunTime:0.027248s ]
select foldpath,foldpath2,filename from pdf_file where id=1922911 limit 1 [ RunTime:0.013079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-27HGCA3500000' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.057014s ]
SELECT `id` FROM `stock` WHERE `id` <> 41499799 AND `partno` = 'L128-27HGCA3500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.052851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18894758 [ RunTime:0.013930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501552 LIMIT 5 [ RunTime:0.056069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501552 ORDER BY `minOrder` ASC [ RunTime:0.016484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501552 ORDER BY `unit` DESC [ RunTime:0.019923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501552 LIMIT 2 [ RunTime:0.008310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501552 ORDER BY `minOrder` ASC [ RunTime:0.013337s ]
select * from pdf where partno='L128-3090HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.015678s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-3090HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.010972s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501552 AND `partno` = 'L128-3090HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.032656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 41501553 LIMIT 5 [ RunTime:0.014884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501553 ORDER BY `minOrder` ASC [ RunTime:0.014197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 41501553 ORDER BY `unit` DESC [ RunTime:0.028844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 41501553 LIMIT 2 [ RunTime:0.035977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 41501553 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='L128-6590HA35000K1' and brandshort='Lumileds' limit 1 [ RunTime:0.012736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L128-6590HA35000K1' OR `brand` LIKE 'Lumileds%' ) ) LIMIT 1 [ RunTime:0.008407s ]
SELECT `id` FROM `stock` WHERE `id` <> 41501553 AND `partno` = 'L128-6590HA35000K1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumileds%' ) [ RunTime:0.010240s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.054496s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015097s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019698s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034796s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016291s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023468s ]
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 'L12%' OR `brand` LIKE 'L12%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035832s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'L12%' OR `brand` LIKE 'L12%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.031982s ]