SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001546s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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=PS2561L-1-V&search=1' [ RunTime:0.001691s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001141s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002281s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000877s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002511s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001092s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PS2561L-1-V' LIMIT 1 [ RunTime:0.011926s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-27 10:10:48' WHERE `partno` = 'PS2561L-1-V' [ RunTime:0.003181s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001501s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027407s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170724 LIMIT 5 [ RunTime:0.000767s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170724 ORDER BY `minOrder` ASC [ RunTime:0.023047s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170724 ORDER BY `unit` DESC [ RunTime:0.014642s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170724 LIMIT 2 [ RunTime:0.002793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170724 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991197 LIMIT 5 [ RunTime:0.007642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991197 ORDER BY `minOrder` ASC [ RunTime:0.008422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991197 ORDER BY `unit` DESC [ RunTime:0.024435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991197 LIMIT 2 [ RunTime:0.011234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991197 ORDER BY `minOrder` ASC [ RunTime:0.013696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694999 LIMIT 5 [ RunTime:0.018413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694999 ORDER BY `minOrder` ASC [ RunTime:0.008008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694999 ORDER BY `unit` DESC [ RunTime:0.008650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694999 LIMIT 2 [ RunTime:0.021219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694999 ORDER BY `minOrder` ASC [ RunTime:0.011052s ]
select * from pdf where partno='PS2561L-1-V' and brandshort='CEL' limit 1 [ RunTime:0.032557s ]
select foldpath,foldpath2,filename from pdf_file where id=1982380 limit 1 [ RunTime:0.010860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693239 LIMIT 5 [ RunTime:0.024319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693239 ORDER BY `minOrder` ASC [ RunTime:0.002129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693239 ORDER BY `unit` DESC [ RunTime:0.007068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693239 LIMIT 2 [ RunTime:0.011425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693239 ORDER BY `minOrder` ASC [ RunTime:0.010360s ]
select * from pdf where partno='PS2561L-1-V-L-A' and brandshort='CEL' limit 1 [ RunTime:0.030929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692635 LIMIT 5 [ RunTime:0.009079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692635 ORDER BY `minOrder` ASC [ RunTime:0.018323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692635 ORDER BY `unit` DESC [ RunTime:0.019475s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692635 LIMIT 2 [ RunTime:0.021308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692635 ORDER BY `minOrder` ASC [ RunTime:0.024124s ]
select * from pdf where partno='PS2561L-1-V-F3-W-A' and brandshort='CEL' limit 1 [ RunTime:0.008300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692634 LIMIT 5 [ RunTime:0.018433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692634 ORDER BY `minOrder` ASC [ RunTime:0.013649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692634 ORDER BY `unit` DESC [ RunTime:0.004829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692634 LIMIT 2 [ RunTime:0.011562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692634 ORDER BY `minOrder` ASC [ RunTime:0.019315s ]
select * from pdf where partno='PS2561L-1-V-F3-L-A' and brandshort='CEL' limit 1 [ RunTime:0.014960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692633 LIMIT 5 [ RunTime:0.009605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692633 ORDER BY `minOrder` ASC [ RunTime:0.015487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692633 ORDER BY `unit` DESC [ RunTime:0.004718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692633 LIMIT 2 [ RunTime:0.015642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692633 ORDER BY `minOrder` ASC [ RunTime:0.010283s ]
select * from pdf where partno='PS2561L-1-V-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.015367s ]
select foldpath,foldpath2,filename from pdf_file where id=1982380 limit 1 [ RunTime:0.003743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689079 LIMIT 5 [ RunTime:0.011684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689079 ORDER BY `minOrder` ASC [ RunTime:0.009021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689079 ORDER BY `unit` DESC [ RunTime:0.001409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689079 LIMIT 2 [ RunTime:0.000813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689079 ORDER BY `minOrder` ASC [ RunTime:0.011974s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689078 LIMIT 5 [ RunTime:0.012914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689078 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689078 ORDER BY `unit` DESC [ RunTime:0.024058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689078 LIMIT 2 [ RunTime:0.000791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689078 ORDER BY `minOrder` ASC [ RunTime:0.000903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204396 LIMIT 5 [ RunTime:0.016725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204396 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204396 ORDER BY `unit` DESC [ RunTime:0.006664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204396 LIMIT 2 [ RunTime:0.014338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204396 ORDER BY `minOrder` ASC [ RunTime:0.002258s ]
select * from pdf where partno='PS2561L-1-V-H-A' and brandshort='CEL' limit 1 [ RunTime:0.008667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204395 LIMIT 5 [ RunTime:0.002659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204395 ORDER BY `minOrder` ASC [ RunTime:0.007450s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204395 ORDER BY `unit` DESC [ RunTime:0.002644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204395 LIMIT 2 [ RunTime:0.011466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204395 ORDER BY `minOrder` ASC [ RunTime:0.010557s ]
select * from pdf where partno='PS2561L-1-V-D-A' and brandshort='CEL' limit 1 [ RunTime:0.007537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204394 LIMIT 5 [ RunTime:0.003854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204394 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204394 ORDER BY `unit` DESC [ RunTime:0.018790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204394 LIMIT 2 [ RunTime:0.008269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204394 ORDER BY `minOrder` ASC [ RunTime:0.010926s ]
select * from pdf where partno='PS2561L-1-V-A' and brandshort='CEL' limit 1 [ RunTime:0.012609s ]
select foldpath,foldpath2,filename from pdf_file where id=1982380 limit 1 [ RunTime:0.003314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203254 LIMIT 5 [ RunTime:0.017659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203254 ORDER BY `minOrder` ASC [ RunTime:0.020573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203254 ORDER BY `unit` DESC [ RunTime:0.011456s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203254 LIMIT 2 [ RunTime:0.009464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203254 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15202999 LIMIT 5 [ RunTime:0.008675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202999 ORDER BY `minOrder` ASC [ RunTime:0.023384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15202999 ORDER BY `unit` DESC [ RunTime:0.007034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15202999 LIMIT 2 [ RunTime:0.034762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15202999 ORDER BY `minOrder` ASC [ RunTime:0.006842s ]
select * from pdf where partno='PS2561L-1-V-E3-H-A' and brandshort='CEL' limit 1 [ RunTime:0.019850s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008736s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450147 LIMIT 5 [ RunTime:0.005513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450147 ORDER BY `minOrder` ASC [ RunTime:0.009426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450147 ORDER BY `unit` DESC [ RunTime:0.008427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450147 LIMIT 2 [ RunTime:0.013078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450147 ORDER BY `minOrder` ASC [ RunTime:0.012890s ]
select * from pdf where partno='PS2561L-1-V-F3-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.008541s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002347s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.019642s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450147 AND `partno` = 'PS2561L-1-V-F3-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.012452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170724 [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57450160 LIMIT 5 [ RunTime:0.001395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450160 ORDER BY `minOrder` ASC [ RunTime:0.015628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57450160 ORDER BY `unit` DESC [ RunTime:0.024364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57450160 LIMIT 2 [ RunTime:0.000885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57450160 ORDER BY `minOrder` ASC [ RunTime:0.002003s ]
select * from pdf where partno='PS2561L-1-V-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.008751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.017864s ]
SELECT `id` FROM `stock` WHERE `id` <> 57450160 AND `partno` = 'PS2561L-1-V-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.007222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991197 [ RunTime:0.007518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456464 LIMIT 5 [ RunTime:0.023248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456464 ORDER BY `minOrder` ASC [ RunTime:0.019557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456464 ORDER BY `unit` DESC [ RunTime:0.017706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456464 LIMIT 2 [ RunTime:0.004773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456464 ORDER BY `minOrder` ASC [ RunTime:0.007704s ]
select * from pdf where partno='PS2561L-1-V-A-D' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.008081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A-D' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.001612s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456464 AND `partno` = 'PS2561L-1-V-A-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.012790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456463 LIMIT 5 [ RunTime:0.034433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456463 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456463 ORDER BY `unit` DESC [ RunTime:0.009425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456463 LIMIT 2 [ RunTime:0.005346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456463 ORDER BY `minOrder` ASC [ RunTime:0.020523s ]
select * from pdf where partno='PS2561L-1-V-A-H' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.032126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A-H' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.015955s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456463 AND `partno` = 'PS2561L-1-V-A-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.019613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456461 LIMIT 5 [ RunTime:0.030214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456461 ORDER BY `minOrder` ASC [ RunTime:0.013702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456461 ORDER BY `unit` DESC [ RunTime:0.012757s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456461 LIMIT 2 [ RunTime:0.010492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456461 ORDER BY `minOrder` ASC [ RunTime:0.017705s ]
select * from pdf where partno='PS2561L-1-V-A-W' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.025388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A-W' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.030674s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456461 AND `partno` = 'PS2561L-1-V-A-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.038511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456460 LIMIT 5 [ RunTime:0.039200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456460 ORDER BY `minOrder` ASC [ RunTime:0.014786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456460 ORDER BY `unit` DESC [ RunTime:0.024976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456460 LIMIT 2 [ RunTime:0.014150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456460 ORDER BY `minOrder` ASC [ RunTime:0.008233s ]
select * from pdf where partno='PS2561L-1-V-A-L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.027048s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A-L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.014998s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456460 AND `partno` = 'PS2561L-1-V-A-L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456439 LIMIT 5 [ RunTime:0.017200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456439 ORDER BY `minOrder` ASC [ RunTime:0.073857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456439 ORDER BY `unit` DESC [ RunTime:0.020084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456439 LIMIT 2 [ RunTime:0.018846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456439 ORDER BY `minOrder` ASC [ RunTime:0.007783s ]
select * from pdf where partno='PS2561L-1-V-A' and brandshort='CEL' limit 1 [ RunTime:0.011182s ]
select foldpath,foldpath2,filename from pdf_file where id=1982380 limit 1 [ RunTime:0.015836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.012181s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456439 AND `partno` = 'PS2561L-1-V-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.038276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204394 [ RunTime:0.055803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456438 LIMIT 5 [ RunTime:0.051078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456438 ORDER BY `minOrder` ASC [ RunTime:0.059097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456438 ORDER BY `unit` DESC [ RunTime:0.020752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456438 LIMIT 2 [ RunTime:0.022854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456438 ORDER BY `minOrder` ASC [ RunTime:0.013091s ]
select * from pdf where partno='PS2561L-1-V-L-A' and brandshort='CEL' limit 1 [ RunTime:0.009851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-L-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.035535s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456438 AND `partno` = 'PS2561L-1-V-L-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.058225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693239 [ RunTime:0.058009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456437 LIMIT 5 [ RunTime:0.033389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456437 ORDER BY `minOrder` ASC [ RunTime:0.072168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456437 ORDER BY `unit` DESC [ RunTime:0.074005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456437 LIMIT 2 [ RunTime:0.057048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456437 ORDER BY `minOrder` ASC [ RunTime:0.034208s ]
select * from pdf where partno='PS2561L-1-V-H-A' and brandshort='CEL' limit 1 [ RunTime:0.009874s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-H-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.023532s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456437 AND `partno` = 'PS2561L-1-V-H-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.017308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204396 [ RunTime:0.041128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57456436 LIMIT 5 [ RunTime:0.029527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456436 ORDER BY `minOrder` ASC [ RunTime:0.048475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57456436 ORDER BY `unit` DESC [ RunTime:0.043010s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57456436 LIMIT 2 [ RunTime:0.014845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57456436 ORDER BY `minOrder` ASC [ RunTime:0.043261s ]
select * from pdf where partno='PS2561L-1-V-D-A' and brandshort='CEL' limit 1 [ RunTime:0.024645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-D-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.087908s ]
SELECT `id` FROM `stock` WHERE `id` <> 57456436 AND `partno` = 'PS2561L-1-V-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.088621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204395 [ RunTime:0.070877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455637 LIMIT 5 [ RunTime:0.073443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455637 ORDER BY `minOrder` ASC [ RunTime:0.029522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455637 ORDER BY `unit` DESC [ RunTime:0.025001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455637 LIMIT 2 [ RunTime:0.041688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455637 ORDER BY `minOrder` ASC [ RunTime:0.009246s ]
select * from pdf where partno='PS2561L-1-V-F3-A/H' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.040255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/H' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.058629s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455637 AND `partno` = 'PS2561L-1-V-F3-A/H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.061157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455634 LIMIT 5 [ RunTime:0.027961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455634 ORDER BY `minOrder` ASC [ RunTime:0.034056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455634 ORDER BY `unit` DESC [ RunTime:0.065316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455634 LIMIT 2 [ RunTime:0.018704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455634 ORDER BY `minOrder` ASC [ RunTime:0.021534s ]
select * from pdf where partno='PS2561L-1-V-F3-A/HJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.023643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/HJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.030827s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455634 AND `partno` = 'PS2561L-1-V-F3-A/HJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.058803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455631 LIMIT 5 [ RunTime:0.065003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455631 ORDER BY `minOrder` ASC [ RunTime:0.034424s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455631 ORDER BY `unit` DESC [ RunTime:0.046382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455631 LIMIT 2 [ RunTime:0.027863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455631 ORDER BY `minOrder` ASC [ RunTime:0.013788s ]
select * from pdf where partno='PS2561L-1-V-F3-A/DJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.070037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/DJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.025273s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455631 AND `partno` = 'PS2561L-1-V-F3-A/DJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.043803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455629 LIMIT 5 [ RunTime:0.019166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455629 ORDER BY `minOrder` ASC [ RunTime:0.034251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455629 ORDER BY `unit` DESC [ RunTime:0.052897s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455629 LIMIT 2 [ RunTime:0.050595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455629 ORDER BY `minOrder` ASC [ RunTime:0.020427s ]
select * from pdf where partno='PS2561L-1-V-F3-A/L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.033778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.023703s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455629 AND `partno` = 'PS2561L-1-V-F3-A/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.040048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455628 LIMIT 5 [ RunTime:0.059785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455628 ORDER BY `minOrder` ASC [ RunTime:0.029113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455628 ORDER BY `unit` DESC [ RunTime:0.014953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455628 LIMIT 2 [ RunTime:0.014154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455628 ORDER BY `minOrder` ASC [ RunTime:0.025037s ]
select * from pdf where partno='PS2561L-1-V-F3-A/H/HJ/HK' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.022732s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/H/HJ/HK' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.037660s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455628 AND `partno` = 'PS2561L-1-V-F3-A/H/HJ/HK' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.044903s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455626 LIMIT 5 [ RunTime:0.043270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455626 ORDER BY `minOrder` ASC [ RunTime:0.021718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455626 ORDER BY `unit` DESC [ RunTime:0.017676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455626 LIMIT 2 [ RunTime:0.035192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455626 ORDER BY `minOrder` ASC [ RunTime:0.014084s ]
select * from pdf where partno='PS2561L-1-V-F3-A/D' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.044058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/D' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.031259s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455626 AND `partno` = 'PS2561L-1-V-F3-A/D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.007942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455623 LIMIT 5 [ RunTime:0.050981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455623 ORDER BY `minOrder` ASC [ RunTime:0.062134s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455623 ORDER BY `unit` DESC [ RunTime:0.024310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455623 LIMIT 2 [ RunTime:0.046445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455623 ORDER BY `minOrder` ASC [ RunTime:0.011262s ]
select * from pdf where partno='PS2561L-1-V-F3-A/WJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.019652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/WJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.025803s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455623 AND `partno` = 'PS2561L-1-V-F3-A/WJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.022688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455622 LIMIT 5 [ RunTime:0.017300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455622 ORDER BY `minOrder` ASC [ RunTime:0.061747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455622 ORDER BY `unit` DESC [ RunTime:0.005055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455622 LIMIT 2 [ RunTime:0.035683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455622 ORDER BY `minOrder` ASC [ RunTime:0.017871s ]
select * from pdf where partno='PS2561L-1-V-F3-A-H' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.013026s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A-H' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.032908s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455622 AND `partno` = 'PS2561L-1-V-F3-A-H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455620 LIMIT 5 [ RunTime:0.006537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455620 ORDER BY `minOrder` ASC [ RunTime:0.019131s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455620 ORDER BY `unit` DESC [ RunTime:0.014574s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455620 LIMIT 2 [ RunTime:0.028628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455620 ORDER BY `minOrder` ASC [ RunTime:0.009394s ]
select * from pdf where partno='PS2561L-1-V-F3-A/LJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.032970s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A/LJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.036972s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455620 AND `partno` = 'PS2561L-1-V-F3-A/LJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57455619 LIMIT 5 [ RunTime:0.020779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455619 ORDER BY `minOrder` ASC [ RunTime:0.039038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57455619 ORDER BY `unit` DESC [ RunTime:0.025910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57455619 LIMIT 2 [ RunTime:0.027819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57455619 ORDER BY `minOrder` ASC [ RunTime:0.020354s ]
select * from pdf where partno='PS2561L-1-V-F3-A-W' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.036997s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2561L-1-V-F3-A-W' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.026026s ]
SELECT `id` FROM `stock` WHERE `id` <> 57455619 AND `partno` = 'PS2561L-1-V-F3-A-W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.008701s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035389s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053530s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045371s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027729s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037155s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042449s ]
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 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086485s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PS2561L-1-V%' OR `brand` LIKE 'PS2561L-1-V%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.054884s ]