SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001337s ]
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=UCR03EVPFL&search=1' [ RunTime:0.018989s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001103s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.006410s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003302s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.022953s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002046s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002170s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001789s ]
SELECT * FROM `stock_search` WHERE `partno` = 'UCR03EVPFL' LIMIT 1 [ RunTime:0.052550s ]
UPDATE `stock_search` SET `count` = 5 , `updatetime` = '2026-08-26 21:37:45' WHERE `partno` = 'UCR03EVPFL' [ RunTime:0.011232s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002523s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075131s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18051663 LIMIT 5 [ RunTime:0.060233s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.026893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051663 ORDER BY `minOrder` ASC [ RunTime:0.020920s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.056778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18051663 ORDER BY `unit` DESC [ RunTime:0.081789s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.039803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18051663 LIMIT 2 [ RunTime:0.055338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051663 ORDER BY `minOrder` ASC [ RunTime:0.001558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18051664 LIMIT 5 [ RunTime:0.084678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051664 ORDER BY `minOrder` ASC [ RunTime:0.143678s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18051664 ORDER BY `unit` DESC [ RunTime:0.064599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18051664 LIMIT 2 [ RunTime:0.070185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051664 ORDER BY `minOrder` ASC [ RunTime:0.027945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18185884 LIMIT 5 [ RunTime:0.050153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18185884 ORDER BY `minOrder` ASC [ RunTime:0.023106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18185884 ORDER BY `unit` DESC [ RunTime:0.079200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18185884 LIMIT 2 [ RunTime:0.046957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18185884 ORDER BY `minOrder` ASC [ RunTime:0.041430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15067366 LIMIT 5 [ RunTime:0.063495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15067366 ORDER BY `minOrder` ASC [ RunTime:0.063550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15067366 ORDER BY `unit` DESC [ RunTime:0.052820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15067366 LIMIT 2 [ RunTime:0.047166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15067366 ORDER BY `minOrder` ASC [ RunTime:0.027617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15090331 LIMIT 5 [ RunTime:0.071381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15090331 ORDER BY `minOrder` ASC [ RunTime:0.062596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15090331 ORDER BY `unit` DESC [ RunTime:0.020381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15090331 LIMIT 2 [ RunTime:0.049859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15090331 ORDER BY `minOrder` ASC [ RunTime:0.022907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16861568 LIMIT 5 [ RunTime:0.033840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16861568 ORDER BY `minOrder` ASC [ RunTime:0.044772s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16861568 ORDER BY `unit` DESC [ RunTime:0.071294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16861568 LIMIT 2 [ RunTime:0.059045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16861568 ORDER BY `minOrder` ASC [ RunTime:0.023859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16861569 LIMIT 5 [ RunTime:0.016302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16861569 ORDER BY `minOrder` ASC [ RunTime:0.008709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16861569 ORDER BY `unit` DESC [ RunTime:0.039510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16861569 LIMIT 2 [ RunTime:0.085288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16861569 ORDER BY `minOrder` ASC [ RunTime:0.004334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18051674 LIMIT 5 [ RunTime:0.030418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051674 ORDER BY `minOrder` ASC [ RunTime:0.013074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18051674 ORDER BY `unit` DESC [ RunTime:0.016491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18051674 LIMIT 2 [ RunTime:0.017039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18051674 ORDER BY `minOrder` ASC [ RunTime:0.018221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15841729 LIMIT 5 [ RunTime:0.023369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15841729 ORDER BY `minOrder` ASC [ RunTime:0.042135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15841729 ORDER BY `unit` DESC [ RunTime:0.039246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15841729 LIMIT 2 [ RunTime:0.019528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15841729 ORDER BY `minOrder` ASC [ RunTime:0.005327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15841730 LIMIT 5 [ RunTime:0.027539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15841730 ORDER BY `minOrder` ASC [ RunTime:0.007122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15841730 ORDER BY `unit` DESC [ RunTime:0.031667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15841730 LIMIT 2 [ RunTime:0.016283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15841730 ORDER BY `minOrder` ASC [ RunTime:0.034038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15791169 LIMIT 5 [ RunTime:0.026464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15791169 ORDER BY `minOrder` ASC [ RunTime:0.052303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15791169 ORDER BY `unit` DESC [ RunTime:0.021290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15791169 LIMIT 2 [ RunTime:0.016191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15791169 ORDER BY `minOrder` ASC [ RunTime:0.011518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883430 LIMIT 5 [ RunTime:0.018915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883430 ORDER BY `minOrder` ASC [ RunTime:0.031277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16883430 ORDER BY `unit` DESC [ RunTime:0.006235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16883430 LIMIT 2 [ RunTime:0.048947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883430 ORDER BY `minOrder` ASC [ RunTime:0.026638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883431 LIMIT 5 [ RunTime:0.039556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883431 ORDER BY `minOrder` ASC [ RunTime:0.029563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16883431 ORDER BY `unit` DESC [ RunTime:0.022689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16883431 LIMIT 2 [ RunTime:0.062072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883431 ORDER BY `minOrder` ASC [ RunTime:0.005580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15067367 LIMIT 5 [ RunTime:0.023498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15067367 ORDER BY `minOrder` ASC [ RunTime:0.041507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15067367 ORDER BY `unit` DESC [ RunTime:0.075721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15067367 LIMIT 2 [ RunTime:0.048826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15067367 ORDER BY `minOrder` ASC [ RunTime:0.050013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883432 LIMIT 5 [ RunTime:0.037286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883432 ORDER BY `minOrder` ASC [ RunTime:0.049055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16883432 ORDER BY `unit` DESC [ RunTime:0.032858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16883432 LIMIT 2 [ RunTime:0.008479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16883432 ORDER BY `minOrder` ASC [ RunTime:0.018187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280351 LIMIT 5 [ RunTime:0.030365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280351 ORDER BY `minOrder` ASC [ RunTime:0.054323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18280351 ORDER BY `unit` DESC [ RunTime:0.072257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18280351 LIMIT 2 [ RunTime:0.021073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280351 ORDER BY `minOrder` ASC [ RunTime:0.029086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280352 LIMIT 5 [ RunTime:0.042132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280352 ORDER BY `minOrder` ASC [ RunTime:0.038472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18280352 ORDER BY `unit` DESC [ RunTime:0.017844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18280352 LIMIT 2 [ RunTime:0.044833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280352 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280355 LIMIT 5 [ RunTime:0.070670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280355 ORDER BY `minOrder` ASC [ RunTime:0.056947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18280355 ORDER BY `unit` DESC [ RunTime:0.021645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18280355 LIMIT 2 [ RunTime:0.034989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18280355 ORDER BY `minOrder` ASC [ RunTime:0.049057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15023820 LIMIT 5 [ RunTime:0.040539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15023820 ORDER BY `minOrder` ASC [ RunTime:0.052407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15023820 ORDER BY `unit` DESC [ RunTime:0.034181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15023820 LIMIT 2 [ RunTime:0.074675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15023820 ORDER BY `minOrder` ASC [ RunTime:0.027676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16882670 LIMIT 5 [ RunTime:0.032859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16882670 ORDER BY `minOrder` ASC [ RunTime:0.044849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16882670 ORDER BY `unit` DESC [ RunTime:0.070463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16882670 LIMIT 2 [ RunTime:0.031628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16882670 ORDER BY `minOrder` ASC [ RunTime:0.045666s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053190s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33000353 LIMIT 5 [ RunTime:0.044906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000353 ORDER BY `minOrder` ASC [ RunTime:0.050524s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33000353 ORDER BY `unit` DESC [ RunTime:0.050237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33000353 LIMIT 2 [ RunTime:0.019859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000353 ORDER BY `minOrder` ASC [ RunTime:0.019047s ]
select * from pdf where partno='UCR03EVPFLR200' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.027523s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR200' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.053165s ]
SELECT `id` FROM `stock` WHERE `id` <> 33000353 AND `partno` = 'UCR03EVPFLR200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.053059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18051663 [ RunTime:0.022288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33152926 LIMIT 5 [ RunTime:0.022726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152926 ORDER BY `minOrder` ASC [ RunTime:0.026936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33152926 ORDER BY `unit` DESC [ RunTime:0.001038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33152926 LIMIT 2 [ RunTime:0.015463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152926 ORDER BY `minOrder` ASC [ RunTime:0.004935s ]
select * from pdf where partno='UCR03EVPFLR180' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.013769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR180' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.019187s ]
SELECT `id` FROM `stock` WHERE `id` <> 33152926 AND `partno` = 'UCR03EVPFLR180' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.010763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18185884 [ RunTime:0.040917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33000355 LIMIT 5 [ RunTime:0.029579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000355 ORDER BY `minOrder` ASC [ RunTime:0.016262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33000355 ORDER BY `unit` DESC [ RunTime:0.016879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33000355 LIMIT 2 [ RunTime:0.018211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000355 ORDER BY `minOrder` ASC [ RunTime:0.012154s ]
select * from pdf where partno='UCR03EVPFLR100' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.018408s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR100' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007973s ]
SELECT `id` FROM `stock` WHERE `id` <> 33000355 AND `partno` = 'UCR03EVPFLR100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.008465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18051664 [ RunTime:0.008895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33254647 LIMIT 5 [ RunTime:0.010307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254647 ORDER BY `minOrder` ASC [ RunTime:0.019551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33254647 ORDER BY `unit` DESC [ RunTime:0.004364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33254647 LIMIT 2 [ RunTime:0.017955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254647 ORDER BY `minOrder` ASC [ RunTime:0.001141s ]
select * from pdf where partno='UCR03EVPFLR160' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.005621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR160' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002822s ]
SELECT `id` FROM `stock` WHERE `id` <> 33254647 AND `partno` = 'UCR03EVPFLR160' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15067366 [ RunTime:0.007250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33152935 LIMIT 5 [ RunTime:0.011781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152935 ORDER BY `minOrder` ASC [ RunTime:0.012645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33152935 ORDER BY `unit` DESC [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33152935 LIMIT 2 [ RunTime:0.000713s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152935 ORDER BY `minOrder` ASC [ RunTime:0.009295s ]
select * from pdf where partno='UCR03EVPFLR150' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.007384s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR150' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002011s ]
SELECT `id` FROM `stock` WHERE `id` <> 33152935 AND `partno` = 'UCR03EVPFLR150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15023820 [ RunTime:0.010410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346765 LIMIT 5 [ RunTime:0.009373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346765 ORDER BY `minOrder` ASC [ RunTime:0.007309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346765 ORDER BY `unit` DESC [ RunTime:0.004691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346765 LIMIT 2 [ RunTime:0.001316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346765 ORDER BY `minOrder` ASC [ RunTime:0.000454s ]
select * from pdf where partno='UCR03EVPFLR620' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.006803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR620' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.013941s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346765 AND `partno` = 'UCR03EVPFLR620' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.005424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15090331 [ RunTime:0.011913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33152944 LIMIT 5 [ RunTime:0.005394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152944 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33152944 ORDER BY `unit` DESC [ RunTime:0.000717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33152944 LIMIT 2 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152944 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='UCR03EVPFLR120' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.006001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR120' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000815s ]
SELECT `id` FROM `stock` WHERE `id` <> 33152944 AND `partno` = 'UCR03EVPFLR120' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.012961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16861568 [ RunTime:0.006325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346777 LIMIT 5 [ RunTime:0.008093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346777 ORDER BY `minOrder` ASC [ RunTime:0.002833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346777 ORDER BY `unit` DESC [ RunTime:0.003190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346777 LIMIT 2 [ RunTime:0.001531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346777 ORDER BY `minOrder` ASC [ RunTime:0.000764s ]
select * from pdf where partno='UCR03EVPFLR510' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.002655s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR510' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001027s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346777 AND `partno` = 'UCR03EVPFLR510' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15841729 [ RunTime:0.009479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346778 LIMIT 5 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346778 ORDER BY `minOrder` ASC [ RunTime:0.017487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346778 ORDER BY `unit` DESC [ RunTime:0.005796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346778 LIMIT 2 [ RunTime:0.003532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346778 ORDER BY `minOrder` ASC [ RunTime:0.000481s ]
select * from pdf where partno='UCR03EVPFLR430' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001358s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR430' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005396s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346778 AND `partno` = 'UCR03EVPFLR430' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.003220s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15841730 [ RunTime:0.000804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346782 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346782 ORDER BY `minOrder` ASC [ RunTime:0.005002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346782 ORDER BY `unit` DESC [ RunTime:0.000724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346782 LIMIT 2 [ RunTime:0.009751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346782 ORDER BY `minOrder` ASC [ RunTime:0.000622s ]
select * from pdf where partno='UCR03EVPFLR130' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001828s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR130' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001914s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346782 AND `partno` = 'UCR03EVPFLR130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883430 [ RunTime:0.000800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33000363 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000363 ORDER BY `minOrder` ASC [ RunTime:0.002840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33000363 ORDER BY `unit` DESC [ RunTime:0.002082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33000363 LIMIT 2 [ RunTime:0.000705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33000363 ORDER BY `minOrder` ASC [ RunTime:0.001152s ]
select * from pdf where partno='UCR03EVPFLR270' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR270' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.005479s ]
SELECT `id` FROM `stock` WHERE `id` <> 33000363 AND `partno` = 'UCR03EVPFLR270' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15791169 [ RunTime:0.005575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346783 LIMIT 5 [ RunTime:0.004149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346783 ORDER BY `minOrder` ASC [ RunTime:0.001252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346783 ORDER BY `unit` DESC [ RunTime:0.000848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346783 LIMIT 2 [ RunTime:0.006053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346783 ORDER BY `minOrder` ASC [ RunTime:0.001053s ]
select * from pdf where partno='UCR03EVPFLR390' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.008737s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR390' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.036684s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346783 AND `partno` = 'UCR03EVPFLR390' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.011099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883431 [ RunTime:0.016294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346786 LIMIT 5 [ RunTime:0.006468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346786 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346786 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346786 LIMIT 2 [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346786 ORDER BY `minOrder` ASC [ RunTime:0.021270s ]
select * from pdf where partno='UCR03EVPFLR360' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.010257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR360' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.014688s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346786 AND `partno` = 'UCR03EVPFLR360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.012346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280351 [ RunTime:0.035212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346787 LIMIT 5 [ RunTime:0.023652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346787 ORDER BY `minOrder` ASC [ RunTime:0.006930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346787 ORDER BY `unit` DESC [ RunTime:0.002335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346787 LIMIT 2 [ RunTime:0.005233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346787 ORDER BY `minOrder` ASC [ RunTime:0.004492s ]
select * from pdf where partno='UCR03EVPFLR240' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR240' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.007123s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346787 AND `partno` = 'UCR03EVPFLR240' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.009776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16883432 [ RunTime:0.003301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33254661 LIMIT 5 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254661 ORDER BY `minOrder` ASC [ RunTime:0.005367s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33254661 ORDER BY `unit` DESC [ RunTime:0.004644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33254661 LIMIT 2 [ RunTime:0.009697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33254661 ORDER BY `minOrder` ASC [ RunTime:0.002549s ]
select * from pdf where partno='UCR03EVPFLR220' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.017216s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR220' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001266s ]
SELECT `id` FROM `stock` WHERE `id` <> 33254661 AND `partno` = 'UCR03EVPFLR220' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280352 [ RunTime:0.000800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346788 LIMIT 5 [ RunTime:0.000768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346788 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346788 ORDER BY `unit` DESC [ RunTime:0.001734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346788 LIMIT 2 [ RunTime:0.001420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346788 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
select * from pdf where partno='UCR03EVPFLR680' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.008286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR680' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000921s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346788 AND `partno` = 'UCR03EVPFLR680' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280355 [ RunTime:0.001367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33152958 LIMIT 5 [ RunTime:0.007392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152958 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33152958 ORDER BY `unit` DESC [ RunTime:0.001296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33152958 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33152958 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='UCR03EVPFLR750' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR750' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000945s ]
SELECT `id` FROM `stock` WHERE `id` <> 33152958 AND `partno` = 'UCR03EVPFLR750' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15067367 [ RunTime:0.000700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346461 LIMIT 5 [ RunTime:0.001099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346461 ORDER BY `minOrder` ASC [ RunTime:0.001663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346461 ORDER BY `unit` DESC [ RunTime:0.000807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346461 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346461 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='UCR03EVPFLR820' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR820' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.001826s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346461 AND `partno` = 'UCR03EVPFLR820' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.002955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16882671 [ RunTime:0.007072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33346791 LIMIT 5 [ RunTime:0.005008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346791 ORDER BY `minOrder` ASC [ RunTime:0.002601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33346791 ORDER BY `unit` DESC [ RunTime:0.000709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33346791 LIMIT 2 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33346791 ORDER BY `minOrder` ASC [ RunTime:0.001949s ]
select * from pdf where partno='UCR03EVPFLR300' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001371s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR300' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.003718s ]
SELECT `id` FROM `stock` WHERE `id` <> 33346791 AND `partno` = 'UCR03EVPFLR300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.005361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16861569 [ RunTime:0.004324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33347014 LIMIT 5 [ RunTime:0.000857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33347014 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33347014 ORDER BY `unit` DESC [ RunTime:0.000765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33347014 LIMIT 2 [ RunTime:0.003053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33347014 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
select * from pdf where partno='UCR03EVPFLR330' and brandshort='Rohm Semiconductor' limit 1 [ RunTime:0.001695s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UCR03EVPFLR330' OR `brand` LIKE 'Rohm Semiconductor%' ) ) LIMIT 1 [ RunTime:0.002626s ]
SELECT `id` FROM `stock` WHERE `id` <> 33347014 AND `partno` = 'UCR03EVPFLR330' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%rohm semiconductor%' ) [ RunTime:0.001152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18280358 [ RunTime:0.004465s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001520s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006225s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003303s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001398s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003388s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001306s ]
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 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003110s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UCR03EVPFL%' OR `brand` LIKE 'UCR03EVPFL%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.019552s ]