SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002529s ]
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=TL50GYRB&search=1' [ RunTime:0.023903s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002654s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009186s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001795s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001265s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.026361s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001181s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TL50GYRB' LIMIT 1 [ RunTime:0.036458s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-28 19:06:35' WHERE `partno` = 'TL50GYRB' [ RunTime:0.022486s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001331s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.052925s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845686 LIMIT 5 [ RunTime:0.016036s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845686 ORDER BY `minOrder` ASC [ RunTime:0.011407s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845686 ORDER BY `unit` DESC [ RunTime:0.056847s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.028067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845686 LIMIT 2 [ RunTime:0.034178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845686 ORDER BY `minOrder` ASC [ RunTime:0.033253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845684 LIMIT 5 [ RunTime:0.015086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845684 ORDER BY `minOrder` ASC [ RunTime:0.023851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845684 ORDER BY `unit` DESC [ RunTime:0.019171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845684 LIMIT 2 [ RunTime:0.073579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845684 ORDER BY `minOrder` ASC [ RunTime:0.019879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845325 LIMIT 5 [ RunTime:0.032635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845325 ORDER BY `minOrder` ASC [ RunTime:0.057771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845325 ORDER BY `unit` DESC [ RunTime:0.059956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845325 LIMIT 2 [ RunTime:0.061590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845325 ORDER BY `minOrder` ASC [ RunTime:0.077968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845080 LIMIT 5 [ RunTime:0.193937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845080 ORDER BY `minOrder` ASC [ RunTime:0.022303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845080 ORDER BY `unit` DESC [ RunTime:0.058973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845080 LIMIT 2 [ RunTime:0.044536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845080 ORDER BY `minOrder` ASC [ RunTime:0.035400s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844824 LIMIT 5 [ RunTime:0.051294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844824 ORDER BY `minOrder` ASC [ RunTime:0.028753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18844824 ORDER BY `unit` DESC [ RunTime:0.035007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18844824 LIMIT 2 [ RunTime:0.093792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844824 ORDER BY `minOrder` ASC [ RunTime:0.069178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844823 LIMIT 5 [ RunTime:0.067064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844823 ORDER BY `minOrder` ASC [ RunTime:0.051563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18844823 ORDER BY `unit` DESC [ RunTime:0.120321s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18844823 LIMIT 2 [ RunTime:0.028773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844823 ORDER BY `minOrder` ASC [ RunTime:0.110275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844333 LIMIT 5 [ RunTime:0.154108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844333 ORDER BY `minOrder` ASC [ RunTime:0.047456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18844333 ORDER BY `unit` DESC [ RunTime:0.063465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18844333 LIMIT 2 [ RunTime:0.104935s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18844333 ORDER BY `minOrder` ASC [ RunTime:0.060838s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023053 LIMIT 5 [ RunTime:0.057815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023053 ORDER BY `minOrder` ASC [ RunTime:0.175888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17023053 ORDER BY `unit` DESC [ RunTime:0.074114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17023053 LIMIT 2 [ RunTime:0.119544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17023053 ORDER BY `minOrder` ASC [ RunTime:0.066699s ]
select * from pdf where partno='TL50GYRBWQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.044534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022906 LIMIT 5 [ RunTime:0.088900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022906 ORDER BY `minOrder` ASC [ RunTime:0.066965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17022906 ORDER BY `unit` DESC [ RunTime:0.032163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17022906 LIMIT 2 [ RunTime:0.028536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17022906 ORDER BY `minOrder` ASC [ RunTime:0.065359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238119 LIMIT 5 [ RunTime:0.078324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238119 ORDER BY `minOrder` ASC [ RunTime:0.012998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15238119 ORDER BY `unit` DESC [ RunTime:0.010007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15238119 LIMIT 2 [ RunTime:0.012773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15238119 ORDER BY `minOrder` ASC [ RunTime:0.015996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237915 LIMIT 5 [ RunTime:0.077719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237915 ORDER BY `minOrder` ASC [ RunTime:0.030717s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15237915 ORDER BY `unit` DESC [ RunTime:0.019525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15237915 LIMIT 2 [ RunTime:0.147795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15237915 ORDER BY `minOrder` ASC [ RunTime:0.037139s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51091224 LIMIT 5 [ RunTime:0.031950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51091224 ORDER BY `minOrder` ASC [ RunTime:0.037252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51091224 ORDER BY `unit` DESC [ RunTime:0.022413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51091224 LIMIT 2 [ RunTime:0.016439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51091224 ORDER BY `minOrder` ASC [ RunTime:0.027807s ]
select * from pdf where partno='tl50gyrbaq' and brandshort='banner engineering' limit 1 [ RunTime:0.029667s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'tl50gyrbaq' OR `brand` LIKE 'banner engineering%' ) ) LIMIT 1 [ RunTime:0.061609s ]
SELECT `id` FROM `stock` WHERE `id` <> 51091224 AND `partno` = 'tl50gyrbaq' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering%' ) [ RunTime:0.017898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844824 [ RunTime:0.023606s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451307 LIMIT 5 [ RunTime:0.051048s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451307 ORDER BY `minOrder` ASC [ RunTime:0.009769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451307 ORDER BY `unit` DESC [ RunTime:0.028812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451307 LIMIT 2 [ RunTime:0.033103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451307 ORDER BY `minOrder` ASC [ RunTime:0.040637s ]
select * from pdf where partno='TL50GYRBKQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.024148s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBKQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.031124s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451307 AND `partno` = 'TL50GYRBKQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.022288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845684 [ RunTime:0.020170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450932 LIMIT 5 [ RunTime:0.146779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450932 ORDER BY `minOrder` ASC [ RunTime:0.161018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450932 ORDER BY `unit` DESC [ RunTime:0.057817s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450932 LIMIT 2 [ RunTime:0.203393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450932 ORDER BY `minOrder` ASC [ RunTime:0.054241s ]
select * from pdf where partno='TL50GYRBAOSIQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.072525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBAOSIQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.051227s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450932 AND `partno` = 'TL50GYRBAOSIQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.092986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845325 [ RunTime:0.074616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450767 LIMIT 5 [ RunTime:0.081083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450767 ORDER BY `minOrder` ASC [ RunTime:0.201709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450767 ORDER BY `unit` DESC [ RunTime:0.287865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450767 LIMIT 2 [ RunTime:0.033341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450767 ORDER BY `minOrder` ASC [ RunTime:0.056228s ]
select * from pdf where partno='TL50GYRBWQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.048729s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBWQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.037356s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450767 AND `partno` = 'TL50GYRBWQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.042390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17023053 [ RunTime:0.015711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450736 LIMIT 5 [ RunTime:0.024498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450736 ORDER BY `minOrder` ASC [ RunTime:0.022557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450736 ORDER BY `unit` DESC [ RunTime:0.034156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450736 LIMIT 2 [ RunTime:0.049131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450736 ORDER BY `minOrder` ASC [ RunTime:0.033107s ]
select * from pdf where partno='TL50GYRBALSQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.041232s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBALSQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.021586s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450736 AND `partno` = 'TL50GYRBALSQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.033665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845080 [ RunTime:0.013105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450475 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450475 ORDER BY `minOrder` ASC [ RunTime:0.014737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450475 ORDER BY `unit` DESC [ RunTime:0.043115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450475 LIMIT 2 [ RunTime:0.032113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450475 ORDER BY `minOrder` ASC [ RunTime:0.027190s ]
select * from pdf where partno='TL50GYRBAQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.019336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBAQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.015247s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450475 AND `partno` = 'TL50GYRBAQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.019468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844824 [ RunTime:0.061252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450474 LIMIT 5 [ RunTime:0.029524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450474 ORDER BY `minOrder` ASC [ RunTime:0.009905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450474 ORDER BY `unit` DESC [ RunTime:0.007181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450474 LIMIT 2 [ RunTime:0.051526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450474 ORDER BY `minOrder` ASC [ RunTime:0.037968s ]
select * from pdf where partno='TL50GYRBA' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.014403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBA' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.008138s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450474 AND `partno` = 'TL50GYRBA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.014342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844823 [ RunTime:0.018134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450031 LIMIT 5 [ RunTime:0.082365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450031 ORDER BY `minOrder` ASC [ RunTime:0.062468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450031 ORDER BY `unit` DESC [ RunTime:0.095463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450031 LIMIT 2 [ RunTime:0.067233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450031 ORDER BY `minOrder` ASC [ RunTime:0.016664s ]
select * from pdf where partno='TL50GYRBQP' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.049674s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBQP' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.024678s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450031 AND `partno` = 'TL50GYRBQP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.136375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15237915 [ RunTime:0.007202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64449919 LIMIT 5 [ RunTime:0.043082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64449919 ORDER BY `minOrder` ASC [ RunTime:0.012079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64449919 ORDER BY `unit` DESC [ RunTime:0.024316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64449919 LIMIT 2 [ RunTime:0.021839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64449919 ORDER BY `minOrder` ASC [ RunTime:0.052879s ]
select * from pdf where partno='TL50GYRB' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.011136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRB' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.008497s ]
SELECT `id` FROM `stock` WHERE `id` <> 64449919 AND `partno` = 'TL50GYRB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.001756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17022906 [ RunTime:0.007597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64449815 LIMIT 5 [ RunTime:0.027816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64449815 ORDER BY `minOrder` ASC [ RunTime:0.024146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64449815 ORDER BY `unit` DESC [ RunTime:0.014546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64449815 LIMIT 2 [ RunTime:0.038543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64449815 ORDER BY `minOrder` ASC [ RunTime:0.005262s ]
select * from pdf where partno='TL50GYRBQ' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.015549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50GYRBQ' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.010165s ]
SELECT `id` FROM `stock` WHERE `id` <> 64449815 AND `partno` = 'TL50GYRBQ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.004258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18844333 [ RunTime:0.000984s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044585s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019805s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027044s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033017s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035808s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024241s ]
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 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060704s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TL50GYRB%' OR `brand` LIKE 'TL50GYRB%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.078355s ]