SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002030s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.111' , `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=PIAT46U&search=1' [ RunTime:0.003370s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001105s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005935s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001318s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.111' ) [ RunTime:0.004088s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001064s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006080s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001134s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PIAT46U' LIMIT 1 [ RunTime:0.011207s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-28 23:30:47' WHERE `partno` = 'PIAT46U' [ RunTime:0.022470s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001503s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012302s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200178 LIMIT 5 [ RunTime:0.018048s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200178 ORDER BY `minOrder` ASC [ RunTime:0.014799s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200178 ORDER BY `unit` DESC [ RunTime:0.034017s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.012259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200178 LIMIT 2 [ RunTime:0.029080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200178 ORDER BY `minOrder` ASC [ RunTime:0.009753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200115 LIMIT 5 [ RunTime:0.018121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200115 ORDER BY `minOrder` ASC [ RunTime:0.016733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11200115 ORDER BY `unit` DESC [ RunTime:0.012722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11200115 LIMIT 2 [ RunTime:0.012091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11200115 ORDER BY `minOrder` ASC [ RunTime:0.024461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12191036 LIMIT 5 [ RunTime:0.007185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12191036 ORDER BY `minOrder` ASC [ RunTime:0.004714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12191036 ORDER BY `unit` DESC [ RunTime:0.006952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12191036 LIMIT 2 [ RunTime:0.006837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12191036 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787654 LIMIT 5 [ RunTime:0.004242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787654 ORDER BY `minOrder` ASC [ RunTime:0.006207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18787654 ORDER BY `unit` DESC [ RunTime:0.003694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18787654 LIMIT 2 [ RunTime:0.003506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18787654 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190739 LIMIT 5 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190739 ORDER BY `minOrder` ASC [ RunTime:0.004047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12190739 ORDER BY `unit` DESC [ RunTime:0.007483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12190739 LIMIT 2 [ RunTime:0.002736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12190739 ORDER BY `minOrder` ASC [ RunTime:0.005693s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136333 LIMIT 5 [ RunTime:0.007250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136333 ORDER BY `minOrder` ASC [ RunTime:0.009959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136333 ORDER BY `unit` DESC [ RunTime:0.005657s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136333 LIMIT 2 [ RunTime:0.000874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136333 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='piat46uta-vl' and brandshort='banner engineering' limit 1 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'piat46uta-vl' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.000357s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136333 AND `partno` = 'piat46uta-vl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.000455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200178 [ RunTime:0.000284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136331 LIMIT 5 [ RunTime:0.002158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136331 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136331 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136331 LIMIT 2 [ RunTime:0.001926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136331 ORDER BY `minOrder` ASC [ RunTime:0.003808s ]
select * from pdf where partno='piat46u' and brandshort='banner engineering' limit 1 [ RunTime:0.004267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'piat46u' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.011740s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136331 AND `partno` = 'piat46u' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.015980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190739 [ RunTime:0.008935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136332 LIMIT 5 [ RunTime:0.001425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136332 ORDER BY `minOrder` ASC [ RunTime:0.003638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136332 ORDER BY `unit` DESC [ RunTime:0.008827s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136332 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136332 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='piat46uhfmta' and brandshort='banner engineering' limit 1 [ RunTime:0.005759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'piat46uhfmta' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.006475s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136332 AND `partno` = 'piat46uhfmta' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.015802s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200115 [ RunTime:0.021759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51136298 LIMIT 5 [ RunTime:0.015254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136298 ORDER BY `minOrder` ASC [ RunTime:0.015125s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51136298 ORDER BY `unit` DESC [ RunTime:0.012563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51136298 LIMIT 2 [ RunTime:0.030226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51136298 ORDER BY `minOrder` ASC [ RunTime:0.001128s ]
select * from pdf where partno='piat46uhfta-vl' and brandshort='banner engineering' limit 1 [ RunTime:0.018100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'piat46uhfta-vl' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.009456s ]
SELECT `id` FROM `stock` WHERE `id` <> 51136298 AND `partno` = 'piat46uhfta-vl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.007639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32571003 [ RunTime:0.012216s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333599 LIMIT 5 [ RunTime:0.011397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333599 ORDER BY `minOrder` ASC [ RunTime:0.012869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333599 ORDER BY `unit` DESC [ RunTime:0.001443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333599 LIMIT 2 [ RunTime:0.000944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333599 ORDER BY `minOrder` ASC [ RunTime:0.002293s ]
select * from pdf where partno='PIAT46UHFMTA' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.002467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UHFMTA' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.006829s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333599 AND `partno` = 'PIAT46UHFMTA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.028725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200115 [ RunTime:0.003804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333825 LIMIT 5 [ RunTime:0.005161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333825 ORDER BY `minOrder` ASC [ RunTime:0.032984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333825 ORDER BY `unit` DESC [ RunTime:0.002297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333825 LIMIT 2 [ RunTime:0.007823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333825 ORDER BY `minOrder` ASC [ RunTime:0.004960s ]
select * from pdf where partno='PIAT46U' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.016225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46U' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.027576s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333825 AND `partno` = 'PIAT46U' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.007094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12190739 [ RunTime:0.005848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63333475 LIMIT 5 [ RunTime:0.006552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333475 ORDER BY `minOrder` ASC [ RunTime:0.018634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63333475 ORDER BY `unit` DESC [ RunTime:0.001269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63333475 LIMIT 2 [ RunTime:0.016311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63333475 ORDER BY `minOrder` ASC [ RunTime:0.008473s ]
select * from pdf where partno='PIAT46UTA-VL' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.016911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UTA-VL' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.005242s ]
SELECT `id` FROM `stock` WHERE `id` <> 63333475 AND `partno` = 'PIAT46UTA-VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.002023s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11200178 [ RunTime:0.006716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63336622 LIMIT 5 [ RunTime:0.019281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336622 ORDER BY `minOrder` ASC [ RunTime:0.015528s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63336622 ORDER BY `unit` DESC [ RunTime:0.001043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63336622 LIMIT 2 [ RunTime:0.015038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63336622 ORDER BY `minOrder` ASC [ RunTime:0.015091s ]
select * from pdf where partno='PIAT46UM.4X.4MT' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.006676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UM.4X.4MT' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.001644s ]
SELECT `id` FROM `stock` WHERE `id` <> 63336622 AND `partno` = 'PIAT46UM.4X.4MT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.007681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12191036 [ RunTime:0.005335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63342637 LIMIT 5 [ RunTime:0.018674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342637 ORDER BY `minOrder` ASC [ RunTime:0.029792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63342637 ORDER BY `unit` DESC [ RunTime:0.021663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63342637 LIMIT 2 [ RunTime:0.009114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63342637 ORDER BY `minOrder` ASC [ RunTime:0.007450s ]
select * from pdf where partno='PIAT46UMTM6' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.004815s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UMTM6' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.015069s ]
SELECT `id` FROM `stock` WHERE `id` <> 63342637 AND `partno` = 'PIAT46UMTM6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.001036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18787654 [ RunTime:0.002893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32604457 LIMIT 5 [ RunTime:0.008842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32604457 ORDER BY `minOrder` ASC [ RunTime:0.015953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32604457 ORDER BY `unit` DESC [ RunTime:0.015720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32604457 LIMIT 2 [ RunTime:0.005389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32604457 ORDER BY `minOrder` ASC [ RunTime:0.009580s ]
select * from pdf where partno='PIAT46UMSL1.5MT' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.011910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UMSL1.5MT' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.008681s ]
SELECT `id` FROM `stock` WHERE `id` <> 32604457 AND `partno` = 'PIAT46UMSL1.5MT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.002932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32571003 LIMIT 5 [ RunTime:0.005215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571003 ORDER BY `minOrder` ASC [ RunTime:0.008503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32571003 ORDER BY `unit` DESC [ RunTime:0.010629s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32571003 LIMIT 2 [ RunTime:0.008924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32571003 ORDER BY `minOrder` ASC [ RunTime:0.004051s ]
select * from pdf where partno='PIAT46UHFTA-VL' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.000744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UHFTA-VL' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.000601s ]
SELECT `id` FROM `stock` WHERE `id` <> 32571003 AND `partno` = 'PIAT46UHFTA-VL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.008597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32560031 LIMIT 5 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32560031 ORDER BY `minOrder` ASC [ RunTime:0.005828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32560031 ORDER BY `unit` DESC [ RunTime:0.019163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32560031 LIMIT 2 [ RunTime:0.021606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32560031 ORDER BY `minOrder` ASC [ RunTime:0.001102s ]
select * from pdf where partno='PIAT46UHF' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.002503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PIAT46UHF' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.003809s ]
SELECT `id` FROM `stock` WHERE `id` <> 32560031 AND `partno` = 'PIAT46UHF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.009200s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013976s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004128s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003532s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011272s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004781s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014370s ]
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 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009589s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PIAT46U%' OR `brand` LIKE 'PIAT46U%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006766s ]