SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002277s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=SMBQ4XFA&search=1' [ RunTime:0.003992s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001557s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000517s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001940s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001682s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000438s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001837s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SMBQ4XFA' LIMIT 1 [ RunTime:0.000925s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-17 12:03:46' WHERE `partno` = 'SMBQ4XFA' [ RunTime:0.002973s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003885s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005412s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240995 LIMIT 5 [ RunTime:0.001294s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240995 ORDER BY `minOrder` ASC [ RunTime:0.009739s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12240995 ORDER BY `unit` DESC [ RunTime:0.008351s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12240995 LIMIT 2 [ RunTime:0.000726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240995 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240081 LIMIT 5 [ RunTime:0.004994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240081 ORDER BY `minOrder` ASC [ RunTime:0.001695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12240081 ORDER BY `unit` DESC [ RunTime:0.003409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12240081 LIMIT 2 [ RunTime:0.020789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240081 ORDER BY `minOrder` ASC [ RunTime:0.006515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240080 LIMIT 5 [ RunTime:0.005559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240080 ORDER BY `minOrder` ASC [ RunTime:0.036344s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12240080 ORDER BY `unit` DESC [ RunTime:0.008185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12240080 LIMIT 2 [ RunTime:0.001104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12240080 ORDER BY `minOrder` ASC [ RunTime:0.003989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234582 LIMIT 5 [ RunTime:0.052561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234582 ORDER BY `minOrder` ASC [ RunTime:0.027322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11234582 ORDER BY `unit` DESC [ RunTime:0.040850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11234582 LIMIT 2 [ RunTime:0.066318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11234582 ORDER BY `minOrder` ASC [ RunTime:0.018717s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244355 LIMIT 5 [ RunTime:0.050725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244355 ORDER BY `minOrder` ASC [ RunTime:0.078314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32244355 ORDER BY `unit` DESC [ RunTime:0.025965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32244355 LIMIT 2 [ RunTime:0.002112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244355 ORDER BY `minOrder` ASC [ RunTime:0.018694s ]
select * from pdf where partno='smbq4xfam12' and brandshort='banner engineering' limit 1 [ RunTime:0.042226s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001956s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbq4xfam12' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.020790s ]
SELECT `id` FROM `stock` WHERE `id` <> 32244355 AND `partno` = 'smbq4xfam12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.040455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173519 [ RunTime:0.012646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215277 [ RunTime:0.002582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240995 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215277 LIMIT 5 [ RunTime:0.002786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215277 ORDER BY `minOrder` ASC [ RunTime:0.007369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32215277 ORDER BY `unit` DESC [ RunTime:0.000508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32215277 LIMIT 2 [ RunTime:0.004542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32215277 ORDER BY `minOrder` ASC [ RunTime:0.009129s ]
select * from pdf where partno='smbq4xfam12' and brandshort='banner engineering' limit 1 [ RunTime:0.000404s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbq4xfam12' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.000291s ]
SELECT `id` FROM `stock` WHERE `id` <> 32215277 AND `partno` = 'smbq4xfam12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.000704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173519 [ RunTime:0.001936s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244355 [ RunTime:0.004748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240995 [ RunTime:0.003145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32173519 LIMIT 5 [ RunTime:0.003132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173519 ORDER BY `minOrder` ASC [ RunTime:0.003713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32173519 ORDER BY `unit` DESC [ RunTime:0.005298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32173519 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32173519 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='smbq4xfam12' and brandshort='banner engineering' limit 1 [ RunTime:0.000509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbq4xfam12' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.000461s ]
SELECT `id` FROM `stock` WHERE `id` <> 32173519 AND `partno` = 'smbq4xfam12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.007493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32215277 [ RunTime:0.006306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244355 [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240995 [ RunTime:0.000298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32244724 LIMIT 5 [ RunTime:0.005739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244724 ORDER BY `minOrder` ASC [ RunTime:0.011997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32244724 ORDER BY `unit` DESC [ RunTime:0.000952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32244724 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32244724 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
select * from pdf where partno='smbq4xfam10' and brandshort='banner engineering' limit 1 [ RunTime:0.000888s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'smbq4xfam10' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.000873s ]
SELECT `id` FROM `stock` WHERE `id` <> 32244724 AND `partno` = 'smbq4xfam10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.007895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212325 [ 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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212108 LIMIT 5 [ RunTime:0.017063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212108 ORDER BY `minOrder` ASC [ RunTime:0.010065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212108 ORDER BY `unit` DESC [ RunTime:0.015045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212108 LIMIT 2 [ RunTime:0.018412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212108 ORDER BY `minOrder` ASC [ RunTime:0.002964s ]
select * from pdf where partno='SMBQ4XFAM12' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.004211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFAM12' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.002183s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212108 AND `partno` = 'SMBQ4XFAM12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.016495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240995 [ RunTime:0.014292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63212325 LIMIT 5 [ RunTime:0.000815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212325 ORDER BY `minOrder` ASC [ RunTime:0.003621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63212325 ORDER BY `unit` DESC [ RunTime:0.001292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63212325 LIMIT 2 [ RunTime:0.015770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63212325 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
select * from pdf where partno='SMBQ4XFAM10' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.008204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFAM10' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.001443s ]
SELECT `id` FROM `stock` WHERE `id` <> 63212325 AND `partno` = 'SMBQ4XFAM10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.006009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63217728 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217728 ORDER BY `minOrder` ASC [ RunTime:0.010126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63217728 ORDER BY `unit` DESC [ RunTime:0.008850s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63217728 LIMIT 2 [ RunTime:0.010034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217728 ORDER BY `minOrder` ASC [ RunTime:0.009666s ]
select * from pdf where partno='SMBQ4XFAM10-SS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.001724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFAM10-SS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.005717s ]
SELECT `id` FROM `stock` WHERE `id` <> 63217728 AND `partno` = 'SMBQ4XFAM10-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.005520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240081 [ RunTime:0.000925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63217726 LIMIT 5 [ RunTime:0.004410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217726 ORDER BY `minOrder` ASC [ RunTime:0.005425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63217726 ORDER BY `unit` DESC [ RunTime:0.043730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63217726 LIMIT 2 [ RunTime:0.009108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63217726 ORDER BY `minOrder` ASC [ RunTime:0.005905s ]
select * from pdf where partno='SMBQ4XFA-SS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.009746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFA-SS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.005757s ]
SELECT `id` FROM `stock` WHERE `id` <> 63217726 AND `partno` = 'SMBQ4XFA-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.011964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12240080 [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213875 LIMIT 5 [ RunTime:0.024519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213875 ORDER BY `minOrder` ASC [ RunTime:0.026057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213875 ORDER BY `unit` DESC [ RunTime:0.004806s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213875 LIMIT 2 [ RunTime:0.002744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213875 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
select * from pdf where partno='SMBQ4XFAM12-SS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.002154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFAM12-SS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.000665s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213875 AND `partno` = 'SMBQ4XFAM12-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.001563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11234582 [ RunTime:0.025740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63213510 LIMIT 5 [ RunTime:0.008822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213510 ORDER BY `minOrder` ASC [ RunTime:0.009065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63213510 ORDER BY `unit` DESC [ RunTime:0.010754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63213510 LIMIT 2 [ RunTime:0.004500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63213510 ORDER BY `minOrder` ASC [ RunTime:0.009756s ]
select * from pdf where partno='SMBQ4XFA' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.003099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMBQ4XFA' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.002673s ]
SELECT `id` FROM `stock` WHERE `id` <> 63213510 AND `partno` = 'SMBQ4XFA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.001626s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003945s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002655s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003343s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003387s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006189s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003018s ]
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 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002303s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMBQ4XFA%' OR `brand` LIKE 'SMBQ4XFA%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001016s ]