SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002175s ]
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=647-1&search=1' [ RunTime:0.003042s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002007s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001316s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002105s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.006841s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001864s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002878s ]
SELECT * FROM `stock_search` WHERE `partno` = '647-1' LIMIT 1 [ RunTime:0.034746s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-25 19:41:42' WHERE `partno` = '647-1' [ RunTime:0.005245s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002296s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018895s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001147s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16975830 LIMIT 5 [ RunTime:0.019946s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16975830 ORDER BY `minOrder` ASC [ RunTime:0.012085s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16975830 ORDER BY `unit` DESC [ RunTime:0.012805s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16975830 LIMIT 2 [ RunTime:0.008956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16975830 ORDER BY `minOrder` ASC [ RunTime:0.008473s ]
select * from pdf where partno='647-10ABP' and brandshort='Wakefield-Vette' limit 1 [ RunTime:0.023715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18602318 LIMIT 5 [ RunTime:0.034358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602318 ORDER BY `minOrder` ASC [ RunTime:0.018570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18602318 ORDER BY `unit` DESC [ RunTime:0.022096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18602318 LIMIT 2 [ RunTime:0.038289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18602318 ORDER BY `minOrder` ASC [ RunTime:0.002036s ]
select * from pdf where partno='647-10ABEP' and brandshort='Wakefield-Vette' limit 1 [ RunTime:0.015146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1297 LIMIT 5 [ RunTime:0.013106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1297 ORDER BY `minOrder` ASC [ RunTime:0.073143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 1297 ORDER BY `unit` DESC [ RunTime:0.033472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 1297 LIMIT 2 [ RunTime:0.035165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 1297 ORDER BY `minOrder` ASC [ RunTime:0.016967s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002410s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10-ABEP' OR `brand` LIKE 'WAKEFIELD THERMAL%' ) ) LIMIT 1 [ RunTime:0.035159s ]
SELECT `id` FROM `stock` WHERE `id` <> 1297 AND `partno` = '647-10-ABEP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.016517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15627 [ RunTime:0.034994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646 [ RunTime:0.021459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646 LIMIT 5 [ RunTime:0.050268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646 ORDER BY `minOrder` ASC [ RunTime:0.052200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16646 ORDER BY `unit` DESC [ RunTime:0.034146s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16646 LIMIT 2 [ RunTime:0.024252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16646 ORDER BY `minOrder` ASC [ RunTime:0.027295s ]
select * from pdf where partno='647-10-ABEP' and brandshort='WAKEFIELD THERMAL' limit 1 [ RunTime:0.022726s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10-ABEP' OR `brand` LIKE 'WAKEFIELD THERMAL%' ) ) LIMIT 1 [ RunTime:0.004226s ]
SELECT `id` FROM `stock` WHERE `id` <> 16646 AND `partno` = '647-10-ABEP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.063419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1297 [ RunTime:0.036276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15627 [ RunTime:0.022573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15627 LIMIT 5 [ RunTime:0.027117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.020985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15627 ORDER BY `unit` DESC [ RunTime:0.017512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15627 LIMIT 2 [ RunTime:0.006453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15627 ORDER BY `minOrder` ASC [ RunTime:0.014857s ]
select * from pdf where partno='647-10-ABEP' and brandshort='WAKEFIELD THERMAL' limit 1 [ RunTime:0.005417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10-ABEP' OR `brand` LIKE 'WAKEFIELD THERMAL%' ) ) LIMIT 1 [ RunTime:0.007207s ]
SELECT `id` FROM `stock` WHERE `id` <> 15627 AND `partno` = '647-10-ABEP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal%' ) [ RunTime:0.016246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 1297 [ RunTime:0.013961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16646 [ RunTime:0.015066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18646455 LIMIT 5 [ RunTime:0.017349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646455 ORDER BY `minOrder` ASC [ RunTime:0.016873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18646455 ORDER BY `unit` DESC [ RunTime:0.007571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18646455 LIMIT 2 [ RunTime:0.022815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18646455 ORDER BY `minOrder` ASC [ RunTime:0.009435s ]
select * from pdf where partno='647-175ABPE' and brandshort='Wakefield-Vette' limit 1 [ RunTime:0.022283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18622961 LIMIT 5 [ RunTime:0.010542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18622961 ORDER BY `minOrder` ASC [ RunTime:0.017274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18622961 ORDER BY `unit` DESC [ RunTime:0.001160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18622961 LIMIT 2 [ RunTime:0.001689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18622961 ORDER BY `minOrder` ASC [ RunTime:0.009231s ]
select * from pdf where partno='647-15ABPE' and brandshort='Wakefield-Vette' limit 1 [ RunTime:0.000622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18620428 LIMIT 5 [ RunTime:0.001735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620428 ORDER BY `minOrder` ASC [ RunTime:0.002872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18620428 ORDER BY `unit` DESC [ RunTime:0.012026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18620428 LIMIT 2 [ RunTime:0.005496s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18620428 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='647-15ABP' and brandshort='Wakefield-Vette' limit 1 [ RunTime:0.000524s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005903s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43885684 LIMIT 5 [ RunTime:0.008503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885684 ORDER BY `minOrder` ASC [ RunTime:0.011637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43885684 ORDER BY `unit` DESC [ RunTime:0.005966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43885684 LIMIT 2 [ RunTime:0.016768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43885684 ORDER BY `minOrder` ASC [ RunTime:0.007592s ]
select * from pdf where partno='647-10ABP' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.007308s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10ABP' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.013437s ]
SELECT `id` FROM `stock` WHERE `id` <> 43885684 AND `partno` = '647-10ABP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.006012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884484 LIMIT 5 [ RunTime:0.006627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884484 ORDER BY `minOrder` ASC [ RunTime:0.047156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884484 ORDER BY `unit` DESC [ RunTime:0.005801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884484 LIMIT 2 [ RunTime:0.002353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884484 ORDER BY `minOrder` ASC [ RunTime:0.002569s ]
select * from pdf where partno='647-15ABPE' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.009643s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-15ABPE' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.005380s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884484 AND `partno` = '647-15ABPE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.005400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43884229 LIMIT 5 [ RunTime:0.012708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884229 ORDER BY `minOrder` ASC [ RunTime:0.006422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43884229 ORDER BY `unit` DESC [ RunTime:0.001151s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43884229 LIMIT 2 [ RunTime:0.002946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43884229 ORDER BY `minOrder` ASC [ RunTime:0.000318s ]
select * from pdf where partno='647-10ABEP' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.002175s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-10ABEP' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.000731s ]
SELECT `id` FROM `stock` WHERE `id` <> 43884229 AND `partno` = '647-10ABEP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.000745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64715945 LIMIT 5 [ RunTime:0.002895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715945 ORDER BY `minOrder` ASC [ RunTime:0.026540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64715945 ORDER BY `unit` DESC [ RunTime:0.009419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64715945 LIMIT 2 [ RunTime:0.011324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64715945 ORDER BY `minOrder` ASC [ RunTime:0.000344s ]
select * from pdf where partno='647-1' and brandshort='Dwyer' limit 1 [ RunTime:0.000971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-1' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.011219s ]
SELECT `id` FROM `stock` WHERE `id` <> 64715945 AND `partno` = '647-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.021881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32686872 [ RunTime:0.018150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43901743 LIMIT 5 [ RunTime:0.011532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43901743 ORDER BY `minOrder` ASC [ RunTime:0.001280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43901743 ORDER BY `unit` DESC [ RunTime:0.009404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43901743 LIMIT 2 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43901743 ORDER BY `minOrder` ASC [ RunTime:0.008403s ]
select * from pdf where partno='647-175ABPE' and brandshort='Wakefield Thermal Solutions' limit 1 [ RunTime:0.012476s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-175ABPE' OR `brand` LIKE 'Wakefield Thermal Solutions%' ) ) LIMIT 1 [ RunTime:0.004804s ]
SELECT `id` FROM `stock` WHERE `id` <> 43901743 AND `partno` = '647-175ABPE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wakefield thermal solutions%' ) [ RunTime:0.010826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32686872 LIMIT 5 [ RunTime:0.011251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32686872 ORDER BY `minOrder` ASC [ RunTime:0.002878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32686872 ORDER BY `unit` DESC [ RunTime:0.004060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32686872 LIMIT 2 [ RunTime:0.009747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32686872 ORDER BY `minOrder` ASC [ RunTime:0.004098s ]
select * from pdf where partno='647-1' and brandshort='Dwyer' limit 1 [ RunTime:0.005054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '647-1' OR `brand` LIKE 'Dwyer%' ) ) LIMIT 1 [ RunTime:0.004677s ]
SELECT `id` FROM `stock` WHERE `id` <> 32686872 AND `partno` = '647-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dwyer%' ) [ RunTime:0.003685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64715945 [ RunTime:0.008052s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008300s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000894s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005128s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006625s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007343s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000971s ]
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 '647-1%' OR `brand` LIKE '647-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009164s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '647-1%' OR `brand` LIKE '647-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002825s ]