SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001645s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=PS2802-4-F3-A&search=1' [ RunTime:0.006120s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001364s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002567s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.060004s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002206s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.014663s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002026s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PS2802-4-F3-A' LIMIT 1 [ RunTime:0.078003s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 15:38:12' WHERE `partno` = 'PS2802-4-F3-A' [ RunTime:0.045534s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002674s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021191s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690688 LIMIT 5 [ RunTime:0.038109s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690688 ORDER BY `minOrder` ASC [ RunTime:0.009782s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690688 ORDER BY `unit` DESC [ RunTime:0.025873s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690688 LIMIT 2 [ RunTime:0.100977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690688 ORDER BY `minOrder` ASC [ RunTime:0.012498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694371 LIMIT 5 [ RunTime:0.047921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694371 ORDER BY `minOrder` ASC [ RunTime:0.006567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694371 ORDER BY `unit` DESC [ RunTime:0.027548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694371 LIMIT 2 [ RunTime:0.069613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694371 ORDER BY `minOrder` ASC [ RunTime:0.025475s ]
select * from pdf where partno='PS2802-4-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.033594s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.027641s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019664s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648380 LIMIT 5 [ RunTime:0.020715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648380 ORDER BY `minOrder` ASC [ RunTime:0.015045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648380 ORDER BY `unit` DESC [ RunTime:0.039488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648380 LIMIT 2 [ RunTime:0.048523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648380 ORDER BY `minOrder` ASC [ RunTime:0.054186s ]
select * from pdf where partno='PS2802-4-F3-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.027011s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.042786s ]
SELECT `id` FROM `stock` WHERE `id` <> 37648380 AND `partno` = 'PS2802-4-F3-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.017584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690688 [ RunTime:0.009871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50450999 LIMIT 5 [ RunTime:0.028229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50450999 ORDER BY `minOrder` ASC [ RunTime:0.022567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50450999 ORDER BY `unit` DESC [ RunTime:0.007569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50450999 LIMIT 2 [ RunTime:0.022224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50450999 ORDER BY `minOrder` ASC [ RunTime:0.066208s ]
select * from pdf where partno='PS2802-4-F3-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.034062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.030031s ]
SELECT `id` FROM `stock` WHERE `id` <> 50450999 AND `partno` = 'PS2802-4-F3-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.029152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690688 [ RunTime:0.029640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461036 LIMIT 5 [ RunTime:0.036143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461036 ORDER BY `minOrder` ASC [ RunTime:0.019708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50461036 ORDER BY `unit` DESC [ RunTime:0.016559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50461036 LIMIT 2 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461036 ORDER BY `minOrder` ASC [ RunTime:0.007241s ]
select * from pdf where partno='PS2802-4-F3-A-Y' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A-Y' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.008939s ]
SELECT `id` FROM `stock` WHERE `id` <> 50461036 AND `partno` = 'PS2802-4-F3-A-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.007948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658403 [ RunTime:0.021491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461035 LIMIT 5 [ RunTime:0.005575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461035 ORDER BY `minOrder` ASC [ RunTime:0.001409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50461035 ORDER BY `unit` DESC [ RunTime:0.011384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50461035 LIMIT 2 [ RunTime:0.011264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461035 ORDER BY `minOrder` ASC [ RunTime:0.006423s ]
select * from pdf where partno='PS2802-4-F3-A/N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.013214s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A/N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.015133s ]
SELECT `id` FROM `stock` WHERE `id` <> 50461035 AND `partno` = 'PS2802-4-F3-A/N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.015676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658402 [ RunTime:0.005573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461034 LIMIT 5 [ RunTime:0.009266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461034 ORDER BY `minOrder` ASC [ RunTime:0.016389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50461034 ORDER BY `unit` DESC [ RunTime:0.015706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50461034 LIMIT 2 [ RunTime:0.061868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50461034 ORDER BY `minOrder` ASC [ RunTime:0.022153s ]
select * from pdf where partno='PS2802-4-F3-A/Y' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.024767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A/Y' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.005695s ]
SELECT `id` FROM `stock` WHERE `id` <> 50461034 AND `partno` = 'PS2802-4-F3-A/Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.014882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658401 [ RunTime:0.003952s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50460942 LIMIT 5 [ RunTime:0.023477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460942 ORDER BY `minOrder` ASC [ RunTime:0.025486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50460942 ORDER BY `unit` DESC [ RunTime:0.020445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50460942 LIMIT 2 [ RunTime:0.032468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460942 ORDER BY `minOrder` ASC [ RunTime:0.006226s ]
select * from pdf where partno='PS2802-4-F3-A-N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.019357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A-N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.006302s ]
SELECT `id` FROM `stock` WHERE `id` <> 50460942 AND `partno` = 'PS2802-4-F3-A-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.007788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658304 [ RunTime:0.008846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50460785 LIMIT 5 [ RunTime:0.004086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460785 ORDER BY `minOrder` ASC [ RunTime:0.009151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50460785 ORDER BY `unit` DESC [ RunTime:0.007545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50460785 LIMIT 2 [ RunTime:0.014994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50460785 ORDER BY `minOrder` ASC [ RunTime:0.010311s ]
select * from pdf where partno='PS2802-4-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.004449s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.008573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.008990s ]
SELECT `id` FROM `stock` WHERE `id` <> 50460785 AND `partno` = 'PS2802-4-F3-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.002404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694371 [ RunTime:0.005080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658403 LIMIT 5 [ RunTime:0.019639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658403 ORDER BY `minOrder` ASC [ RunTime:0.001606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658403 ORDER BY `unit` DESC [ RunTime:0.008678s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658403 LIMIT 2 [ RunTime:0.006874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658403 ORDER BY `minOrder` ASC [ RunTime:0.007387s ]
select * from pdf where partno='PS2802-4-F3-A-Y' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A-Y' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.007247s ]
SELECT `id` FROM `stock` WHERE `id` <> 37658403 AND `partno` = 'PS2802-4-F3-A-Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.009582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461036 [ RunTime:0.002231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658402 LIMIT 5 [ RunTime:0.002355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658402 ORDER BY `minOrder` ASC [ RunTime:0.003384s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658402 ORDER BY `unit` DESC [ RunTime:0.014457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658402 LIMIT 2 [ RunTime:0.026619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658402 ORDER BY `minOrder` ASC [ RunTime:0.011100s ]
select * from pdf where partno='PS2802-4-F3-A/N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.011744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A/N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.026293s ]
SELECT `id` FROM `stock` WHERE `id` <> 37658402 AND `partno` = 'PS2802-4-F3-A/N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.006571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461035 [ RunTime:0.016890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658401 LIMIT 5 [ RunTime:0.037929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658401 ORDER BY `minOrder` ASC [ RunTime:0.007595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658401 ORDER BY `unit` DESC [ RunTime:0.016630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658401 LIMIT 2 [ RunTime:0.010004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658401 ORDER BY `minOrder` ASC [ RunTime:0.023699s ]
select * from pdf where partno='PS2802-4-F3-A/Y' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.005231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A/Y' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.008459s ]
SELECT `id` FROM `stock` WHERE `id` <> 37658401 AND `partno` = 'PS2802-4-F3-A/Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.003554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50461034 [ RunTime:0.006006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658304 LIMIT 5 [ RunTime:0.054068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658304 ORDER BY `minOrder` ASC [ RunTime:0.001145s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658304 ORDER BY `unit` DESC [ RunTime:0.052502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658304 LIMIT 2 [ RunTime:0.049855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658304 ORDER BY `minOrder` ASC [ RunTime:0.004953s ]
select * from pdf where partno='PS2802-4-F3-A-N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A-N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.028577s ]
SELECT `id` FROM `stock` WHERE `id` <> 37658304 AND `partno` = 'PS2802-4-F3-A-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.018925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50460942 [ RunTime:0.018136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37658148 LIMIT 5 [ RunTime:0.023150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658148 ORDER BY `minOrder` ASC [ RunTime:0.028032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37658148 ORDER BY `unit` DESC [ RunTime:0.009969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37658148 LIMIT 2 [ RunTime:0.043417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37658148 ORDER BY `minOrder` ASC [ RunTime:0.074304s ]
select * from pdf where partno='PS2802-4-F3-A' and brandshort='CEL' limit 1 [ RunTime:0.052271s ]
select foldpath,foldpath2,filename from pdf_file where id=751896 limit 1 [ RunTime:0.058346s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2802-4-F3-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.016103s ]
SELECT `id` FROM `stock` WHERE `id` <> 37658148 AND `partno` = 'PS2802-4-F3-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.036943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694371 [ RunTime:0.006869s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014788s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036044s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016426s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031540s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017392s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045382s ]
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 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016942s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PS2802-4-F3-A%' OR `brand` LIKE 'PS2802-4-F3-A%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007283s ]