SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.006212s ]
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=PS2502-1&search=1' [ RunTime:0.003366s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001347s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001380s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001808s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.002743s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002505s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001464s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PS2502-1' LIMIT 1 [ RunTime:0.017015s ]
UPDATE `stock_search` SET `count` = 9 , `updatetime` = '2026-08-26 14:00:36' WHERE `partno` = 'PS2502-1' [ RunTime:0.010271s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001826s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008057s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693968 LIMIT 5 [ RunTime:0.003932s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693968 ORDER BY `minOrder` ASC [ RunTime:0.012801s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693968 ORDER BY `unit` DESC [ RunTime:0.025050s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693968 LIMIT 2 [ RunTime:0.039518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693968 ORDER BY `minOrder` ASC [ RunTime:0.017703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991313 LIMIT 5 [ RunTime:0.040138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991313 ORDER BY `minOrder` ASC [ RunTime:0.054911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991313 ORDER BY `unit` DESC [ RunTime:0.027307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991313 LIMIT 2 [ RunTime:0.048026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991313 ORDER BY `minOrder` ASC [ RunTime:0.012821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991311 LIMIT 5 [ RunTime:0.056863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991311 ORDER BY `minOrder` ASC [ RunTime:0.077509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991311 ORDER BY `unit` DESC [ RunTime:0.047824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991311 LIMIT 2 [ RunTime:0.080556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991311 ORDER BY `minOrder` ASC [ RunTime:0.027482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991442 LIMIT 5 [ RunTime:0.055946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991442 ORDER BY `minOrder` ASC [ RunTime:0.022520s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991442 ORDER BY `unit` DESC [ RunTime:0.047279s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991442 LIMIT 2 [ RunTime:0.044988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991442 ORDER BY `minOrder` ASC [ RunTime:0.024689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694959 LIMIT 5 [ RunTime:0.017943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694959 ORDER BY `minOrder` ASC [ RunTime:0.032513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694959 ORDER BY `unit` DESC [ RunTime:0.005296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694959 LIMIT 2 [ RunTime:0.012921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694959 ORDER BY `minOrder` ASC [ RunTime:0.014465s ]
select * from pdf where partno='PS2502-1' and brandshort='CEL' limit 1 [ RunTime:0.019758s ]
select foldpath,foldpath2,filename from pdf_file where id=2032279 limit 1 [ RunTime:0.015269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693602 LIMIT 5 [ RunTime:0.028327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693602 ORDER BY `minOrder` ASC [ RunTime:0.060551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693602 ORDER BY `unit` DESC [ RunTime:0.067100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693602 LIMIT 2 [ RunTime:0.034683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693602 ORDER BY `minOrder` ASC [ RunTime:0.042944s ]
select * from pdf where partno='PS2502-1-L-A' and brandshort='CEL' limit 1 [ RunTime:0.052124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693601 LIMIT 5 [ RunTime:0.050326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693601 ORDER BY `minOrder` ASC [ RunTime:0.048893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693601 ORDER BY `unit` DESC [ RunTime:0.061893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693601 LIMIT 2 [ RunTime:0.021034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693601 ORDER BY `minOrder` ASC [ RunTime:0.034644s ]
select * from pdf where partno='PS2502-1-K-A' and brandshort='CEL' limit 1 [ RunTime:0.036493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693029 LIMIT 5 [ RunTime:0.031715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693029 ORDER BY `minOrder` ASC [ RunTime:0.061329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693029 ORDER BY `unit` DESC [ RunTime:0.012261s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693029 LIMIT 2 [ RunTime:0.019319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693029 ORDER BY `minOrder` ASC [ RunTime:0.009663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692917 LIMIT 5 [ RunTime:0.024458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692917 ORDER BY `minOrder` ASC [ RunTime:0.010316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692917 ORDER BY `unit` DESC [ RunTime:0.024772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692917 LIMIT 2 [ RunTime:0.021084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692917 ORDER BY `minOrder` ASC [ RunTime:0.004071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18692872 LIMIT 5 [ RunTime:0.003895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692872 ORDER BY `minOrder` ASC [ RunTime:0.018267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18692872 ORDER BY `unit` DESC [ RunTime:0.018700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18692872 LIMIT 2 [ RunTime:0.019534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18692872 ORDER BY `minOrder` ASC [ RunTime:0.019204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689055 LIMIT 5 [ RunTime:0.036508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689055 ORDER BY `minOrder` ASC [ RunTime:0.017896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689055 ORDER BY `unit` DESC [ RunTime:0.028638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689055 LIMIT 2 [ RunTime:0.021070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689055 ORDER BY `minOrder` ASC [ RunTime:0.011840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689054 LIMIT 5 [ RunTime:0.006005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689054 ORDER BY `minOrder` ASC [ RunTime:0.013932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689054 ORDER BY `unit` DESC [ RunTime:0.005092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689054 LIMIT 2 [ RunTime:0.010289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689054 ORDER BY `minOrder` ASC [ RunTime:0.013285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992116 LIMIT 5 [ RunTime:0.018050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992116 ORDER BY `minOrder` ASC [ RunTime:0.005515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16992116 ORDER BY `unit` DESC [ RunTime:0.012777s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16992116 LIMIT 2 [ RunTime:0.020984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16992116 ORDER BY `minOrder` ASC [ RunTime:0.009343s ]
select * from pdf where partno='PS2502-1-M-A' and brandshort='CEL' limit 1 [ RunTime:0.028475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991936 LIMIT 5 [ RunTime:0.033106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991936 ORDER BY `minOrder` ASC [ RunTime:0.014287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991936 ORDER BY `unit` DESC [ RunTime:0.002633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991936 LIMIT 2 [ RunTime:0.013456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991936 ORDER BY `minOrder` ASC [ RunTime:0.000609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991896 LIMIT 5 [ RunTime:0.002564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991896 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16991896 ORDER BY `unit` DESC [ RunTime:0.015162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16991896 LIMIT 2 [ RunTime:0.020160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16991896 ORDER BY `minOrder` ASC [ RunTime:0.006854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171418 LIMIT 5 [ RunTime:0.003909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171418 ORDER BY `minOrder` ASC [ RunTime:0.003919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171418 ORDER BY `unit` DESC [ RunTime:0.003778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171418 LIMIT 2 [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171418 ORDER BY `minOrder` ASC [ RunTime:0.035283s ]
select * from pdf where partno='PS2502-1-A' and brandshort='CEL' limit 1 [ RunTime:0.004514s ]
select foldpath,foldpath2,filename from pdf_file where id=2032279 limit 1 [ RunTime:0.009485s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006519s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030240s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64261373 LIMIT 5 [ RunTime:0.003649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64261373 ORDER BY `minOrder` ASC [ RunTime:0.019082s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64261373 ORDER BY `unit` DESC [ RunTime:0.003817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64261373 LIMIT 2 [ RunTime:0.014724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64261373 ORDER BY `minOrder` ASC [ RunTime:0.000426s ]
select * from pdf where partno='PS2502-1XG' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.001528s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1XG' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.012299s ]
SELECT `id` FROM `stock` WHERE `id` <> 64261373 AND `partno` = 'PS2502-1XG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.011816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991313 [ RunTime:0.048744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260807 LIMIT 5 [ RunTime:0.011032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260807 ORDER BY `minOrder` ASC [ RunTime:0.042360s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260807 ORDER BY `unit` DESC [ RunTime:0.041654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260807 LIMIT 2 [ RunTime:0.033032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260807 ORDER BY `minOrder` ASC [ RunTime:0.010505s ]
select * from pdf where partno='PS2502-1X' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.023734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1X' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.005305s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260807 AND `partno` = 'PS2502-1X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.001170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991311 [ RunTime:0.000793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64260285 LIMIT 5 [ RunTime:0.047690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260285 ORDER BY `minOrder` ASC [ RunTime:0.024561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64260285 ORDER BY `unit` DESC [ RunTime:0.013881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64260285 LIMIT 2 [ RunTime:0.042100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64260285 ORDER BY `minOrder` ASC [ RunTime:0.011589s ]
select * from pdf where partno='PS2502-1-A' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.014621s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.125988s ]
SELECT `id` FROM `stock` WHERE `id` <> 64260285 AND `partno` = 'PS2502-1-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.053587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693968 [ RunTime:0.067028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64262941 LIMIT 5 [ RunTime:0.040412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262941 ORDER BY `minOrder` ASC [ RunTime:0.077898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64262941 ORDER BY `unit` DESC [ RunTime:0.093593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64262941 LIMIT 2 [ RunTime:0.042585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64262941 ORDER BY `minOrder` ASC [ RunTime:0.069082s ]
select * from pdf where partno='PS2502-1XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.027947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.015594s ]
SELECT `id` FROM `stock` WHERE `id` <> 64262941 AND `partno` = 'PS2502-1XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.028483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16991442 [ RunTime:0.038460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267743 LIMIT 5 [ RunTime:0.060992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267743 ORDER BY `minOrder` ASC [ RunTime:0.018161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267743 ORDER BY `unit` DESC [ RunTime:0.028427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267743 LIMIT 2 [ RunTime:0.018233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267743 ORDER BY `minOrder` ASC [ RunTime:0.023617s ]
select * from pdf where partno='PS2502-1-A' and brandshort='CEL' limit 1 [ RunTime:0.001303s ]
select foldpath,foldpath2,filename from pdf_file where id=2032279 limit 1 [ RunTime:0.000265s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.017489s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267743 AND `partno` = 'PS2502-1-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.045204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171418 [ RunTime:0.029332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267740 LIMIT 5 [ RunTime:0.017957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267740 ORDER BY `minOrder` ASC [ RunTime:0.013754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267740 ORDER BY `unit` DESC [ RunTime:0.039934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267740 LIMIT 2 [ RunTime:0.032405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267740 ORDER BY `minOrder` ASC [ RunTime:0.014275s ]
select * from pdf where partno='PS2502-1-M-A' and brandshort='CEL' limit 1 [ RunTime:0.023292s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-M-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.031467s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267740 AND `partno` = 'PS2502-1-M-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.050959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16992116 [ RunTime:0.038669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267739 LIMIT 5 [ RunTime:0.043969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267739 ORDER BY `minOrder` ASC [ RunTime:0.002468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267739 ORDER BY `unit` DESC [ RunTime:0.047601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267739 LIMIT 2 [ RunTime:0.005959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267739 ORDER BY `minOrder` ASC [ RunTime:0.000735s ]
select * from pdf where partno='PS2502-1-L-A' and brandshort='CEL' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-L-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.000579s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267739 AND `partno` = 'PS2502-1-L-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.007097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693602 [ RunTime:0.011818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267738 LIMIT 5 [ RunTime:0.031187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267738 ORDER BY `minOrder` ASC [ RunTime:0.046036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267738 ORDER BY `unit` DESC [ RunTime:0.021763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267738 LIMIT 2 [ RunTime:0.025766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267738 ORDER BY `minOrder` ASC [ RunTime:0.022218s ]
select * from pdf where partno='PS2502-1-K-A' and brandshort='CEL' limit 1 [ RunTime:0.000534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-K-A' OR `brand` LIKE 'CEL%' ) ) LIMIT 1 [ RunTime:0.032497s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267738 AND `partno` = 'PS2502-1-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cel%' ) [ RunTime:0.036202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693601 [ RunTime:0.009530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267689 LIMIT 5 [ RunTime:0.001121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267689 ORDER BY `minOrder` ASC [ RunTime:0.022729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267689 ORDER BY `unit` DESC [ RunTime:0.012815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267689 LIMIT 2 [ RunTime:0.037644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267689 ORDER BY `minOrder` ASC [ RunTime:0.011475s ]
select * from pdf where partno='PS2502-1-A/RJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/RJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.031779s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267689 AND `partno` = 'PS2502-1-A/RJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.021340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267688 LIMIT 5 [ RunTime:0.020379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267688 ORDER BY `minOrder` ASC [ RunTime:0.023193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267688 ORDER BY `unit` DESC [ RunTime:0.011885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267688 LIMIT 2 [ RunTime:0.039864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267688 ORDER BY `minOrder` ASC [ RunTime:0.019887s ]
select * from pdf where partno='PS2502-1-A/R' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.018179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/R' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.072413s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267688 AND `partno` = 'PS2502-1-A/R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.065239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267687 LIMIT 5 [ RunTime:0.028024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267687 ORDER BY `minOrder` ASC [ RunTime:0.074946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267687 ORDER BY `unit` DESC [ RunTime:0.034212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267687 LIMIT 2 [ RunTime:0.018671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267687 ORDER BY `minOrder` ASC [ RunTime:0.033913s ]
select * from pdf where partno='PS2502-1-A/KJ2' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.051962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/KJ2' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.059468s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267687 AND `partno` = 'PS2502-1-A/KJ2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.048372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267686 LIMIT 5 [ RunTime:0.059042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267686 ORDER BY `minOrder` ASC [ RunTime:0.038485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267686 ORDER BY `unit` DESC [ RunTime:0.028592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267686 LIMIT 2 [ RunTime:0.078654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267686 ORDER BY `minOrder` ASC [ RunTime:0.034836s ]
select * from pdf where partno='PS2502-1-A/L' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.034352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/L' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.051064s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267686 AND `partno` = 'PS2502-1-A/L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.062849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267685 LIMIT 5 [ RunTime:0.049314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267685 ORDER BY `minOrder` ASC [ RunTime:0.055462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267685 ORDER BY `unit` DESC [ RunTime:0.030676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267685 LIMIT 2 [ RunTime:0.046895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267685 ORDER BY `minOrder` ASC [ RunTime:0.044093s ]
select * from pdf where partno='PS2502-1-A/LJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.025598s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/LJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.072295s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267685 AND `partno` = 'PS2502-1-A/LJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.066368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267684 LIMIT 5 [ RunTime:0.087280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267684 ORDER BY `minOrder` ASC [ RunTime:0.036582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267684 ORDER BY `unit` DESC [ RunTime:0.024489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267684 LIMIT 2 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267684 ORDER BY `minOrder` ASC [ RunTime:0.006719s ]
select * from pdf where partno='PS2502-1-A-K' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.009589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A-K' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.027358s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267684 AND `partno` = 'PS2502-1-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.012096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267682 LIMIT 5 [ RunTime:0.017384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267682 ORDER BY `minOrder` ASC [ RunTime:0.016236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267682 ORDER BY `unit` DESC [ RunTime:0.000477s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267682 LIMIT 2 [ RunTime:0.016277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267682 ORDER BY `minOrder` ASC [ RunTime:0.030031s ]
select * from pdf where partno='PS2502-1-A/K' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.023470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/K' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.018934s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267682 AND `partno` = 'PS2502-1-A/K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.010395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267681 LIMIT 5 [ RunTime:0.002813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267681 ORDER BY `minOrder` ASC [ RunTime:0.031694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267681 ORDER BY `unit` DESC [ RunTime:0.018673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267681 LIMIT 2 [ RunTime:0.033231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267681 ORDER BY `minOrder` ASC [ RunTime:0.022311s ]
select * from pdf where partno='PS2502-1-A/KJ' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.034149s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A/KJ' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.023688s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267681 AND `partno` = 'PS2502-1-A/KJ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.020225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267680 LIMIT 5 [ RunTime:0.040172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267680 ORDER BY `minOrder` ASC [ RunTime:0.023529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267680 ORDER BY `unit` DESC [ RunTime:0.020952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267680 LIMIT 2 [ RunTime:0.025831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267680 ORDER BY `minOrder` ASC [ RunTime:0.006180s ]
select * from pdf where partno='PS2502-1-A-R' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.006144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A-R' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.004192s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267680 AND `partno` = 'PS2502-1-A-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.003776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267679 LIMIT 5 [ RunTime:0.010946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267679 ORDER BY `minOrder` ASC [ RunTime:0.037519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267679 ORDER BY `unit` DESC [ RunTime:0.017091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267679 LIMIT 2 [ RunTime:0.009495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267679 ORDER BY `minOrder` ASC [ RunTime:0.027625s ]
select * from pdf where partno='PS2502-1-A-N' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.007873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A-N' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.020318s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267679 AND `partno` = 'PS2502-1-A-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.012102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267678 LIMIT 5 [ RunTime:0.016006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267678 ORDER BY `minOrder` ASC [ RunTime:0.025507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267678 ORDER BY `unit` DESC [ RunTime:0.024359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267678 LIMIT 2 [ RunTime:0.008685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267678 ORDER BY `minOrder` ASC [ RunTime:0.003738s ]
select * from pdf where partno='PS2502-1-A-P' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.010056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A-P' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.023868s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267678 AND `partno` = 'PS2502-1-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.044928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64267677 LIMIT 5 [ RunTime:0.038277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267677 ORDER BY `minOrder` ASC [ RunTime:0.031726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64267677 ORDER BY `unit` DESC [ RunTime:0.006639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64267677 LIMIT 2 [ RunTime:0.033023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64267677 ORDER BY `minOrder` ASC [ RunTime:0.010661s ]
select * from pdf where partno='PS2502-1-A-M' and brandshort='Renesas Electronics Corporation' limit 1 [ RunTime:0.010553s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PS2502-1-A-M' OR `brand` LIKE 'Renesas Electronics Corporation%' ) ) LIMIT 1 [ RunTime:0.014976s ]
SELECT `id` FROM `stock` WHERE `id` <> 64267677 AND `partno` = 'PS2502-1-A-M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%renesas electronics corporation%' ) [ RunTime:0.015350s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035494s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066346s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049393s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067602s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034186s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029080s ]
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 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029861s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PS2502-1%' OR `brand` LIKE 'PS2502-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.026190s ]