SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001667s ]
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=TL50BLZR&search=1' [ RunTime:0.004794s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001679s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000610s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002112s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.003830s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001818s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000877s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001330s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TL50BLZR' LIMIT 1 [ RunTime:0.033038s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-26 12:01:35' WHERE `partno` = 'TL50BLZR' [ RunTime:0.010284s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001866s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018420s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845859 LIMIT 5 [ RunTime:0.022751s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.020050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845859 ORDER BY `minOrder` ASC [ RunTime:0.060032s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.028212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845859 ORDER BY `unit` DESC [ RunTime:0.026078s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845859 LIMIT 2 [ RunTime:0.050592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845859 ORDER BY `minOrder` ASC [ RunTime:0.014074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845810 LIMIT 5 [ RunTime:0.044178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845810 ORDER BY `minOrder` ASC [ RunTime:0.037233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845810 ORDER BY `unit` DESC [ RunTime:0.044199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845810 LIMIT 2 [ RunTime:0.048170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845810 ORDER BY `minOrder` ASC [ RunTime:0.040090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845706 LIMIT 5 [ RunTime:0.047231s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845706 ORDER BY `minOrder` ASC [ RunTime:0.048905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845706 ORDER BY `unit` DESC [ RunTime:0.051883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845706 LIMIT 2 [ RunTime:0.097274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845706 ORDER BY `minOrder` ASC [ RunTime:0.019701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845647 LIMIT 5 [ RunTime:0.043773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845647 ORDER BY `minOrder` ASC [ RunTime:0.030390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845647 ORDER BY `unit` DESC [ RunTime:0.129394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845647 LIMIT 2 [ RunTime:0.080967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845647 ORDER BY `minOrder` ASC [ RunTime:0.019749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845599 LIMIT 5 [ RunTime:0.022053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845599 ORDER BY `minOrder` ASC [ RunTime:0.106571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845599 ORDER BY `unit` DESC [ RunTime:0.035620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845599 LIMIT 2 [ RunTime:0.068611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845599 ORDER BY `minOrder` ASC [ RunTime:0.012149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845536 LIMIT 5 [ RunTime:0.038816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845536 ORDER BY `minOrder` ASC [ RunTime:0.034462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845536 ORDER BY `unit` DESC [ RunTime:0.046808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845536 LIMIT 2 [ RunTime:0.022057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845536 ORDER BY `minOrder` ASC [ RunTime:0.020158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845533 LIMIT 5 [ RunTime:0.022956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845533 ORDER BY `minOrder` ASC [ RunTime:0.058929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845533 ORDER BY `unit` DESC [ RunTime:0.041877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845533 LIMIT 2 [ RunTime:0.067564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845533 ORDER BY `minOrder` ASC [ RunTime:0.027808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845494 LIMIT 5 [ RunTime:0.050481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845494 ORDER BY `minOrder` ASC [ RunTime:0.015415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845494 ORDER BY `unit` DESC [ RunTime:0.054561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845494 LIMIT 2 [ RunTime:0.076096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845494 ORDER BY `minOrder` ASC [ RunTime:0.020687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845404 LIMIT 5 [ RunTime:0.055443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845404 ORDER BY `minOrder` ASC [ RunTime:0.027448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845404 ORDER BY `unit` DESC [ RunTime:0.036051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845404 LIMIT 2 [ RunTime:0.051757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845404 ORDER BY `minOrder` ASC [ RunTime:0.024826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845402 LIMIT 5 [ RunTime:0.021238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845402 ORDER BY `minOrder` ASC [ RunTime:0.031041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845402 ORDER BY `unit` DESC [ RunTime:0.012106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845402 LIMIT 2 [ RunTime:0.024298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845402 ORDER BY `minOrder` ASC [ RunTime:0.018378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845401 LIMIT 5 [ RunTime:0.019335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845401 ORDER BY `minOrder` ASC [ RunTime:0.025890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845401 ORDER BY `unit` DESC [ RunTime:0.005986s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845401 LIMIT 2 [ RunTime:0.022273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845401 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845398 LIMIT 5 [ RunTime:0.010046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845398 ORDER BY `minOrder` ASC [ RunTime:0.014897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845398 ORDER BY `unit` DESC [ RunTime:0.052527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845398 LIMIT 2 [ RunTime:0.014217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845398 ORDER BY `minOrder` ASC [ RunTime:0.004497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845362 LIMIT 5 [ RunTime:0.015006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845362 ORDER BY `minOrder` ASC [ RunTime:0.022050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845362 ORDER BY `unit` DESC [ RunTime:0.001067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845362 LIMIT 2 [ RunTime:0.002073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845362 ORDER BY `minOrder` ASC [ RunTime:0.002789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845206 LIMIT 5 [ RunTime:0.010673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845206 ORDER BY `minOrder` ASC [ RunTime:0.033260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845206 ORDER BY `unit` DESC [ RunTime:0.009143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845206 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845206 ORDER BY `minOrder` ASC [ RunTime:0.006494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845202 LIMIT 5 [ RunTime:0.000852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845202 ORDER BY `minOrder` ASC [ RunTime:0.010877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845202 ORDER BY `unit` DESC [ RunTime:0.023689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845202 LIMIT 2 [ RunTime:0.032622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845202 ORDER BY `minOrder` ASC [ RunTime:0.007213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845070 LIMIT 5 [ RunTime:0.010749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845070 ORDER BY `minOrder` ASC [ RunTime:0.008220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845070 ORDER BY `unit` DESC [ RunTime:0.029128s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845070 LIMIT 2 [ RunTime:0.017408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845070 ORDER BY `minOrder` ASC [ RunTime:0.019353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845067 LIMIT 5 [ RunTime:0.022033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845067 ORDER BY `minOrder` ASC [ RunTime:0.016445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845067 ORDER BY `unit` DESC [ RunTime:0.003072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845067 LIMIT 2 [ RunTime:0.016617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845067 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845062 LIMIT 5 [ RunTime:0.025153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845062 ORDER BY `minOrder` ASC [ RunTime:0.017565s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845062 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845062 LIMIT 2 [ RunTime:0.012823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845062 ORDER BY `minOrder` ASC [ RunTime:0.014371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845059 LIMIT 5 [ RunTime:0.039870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845059 ORDER BY `minOrder` ASC [ RunTime:0.052254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845059 ORDER BY `unit` DESC [ RunTime:0.069773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845059 LIMIT 2 [ RunTime:0.025270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845059 ORDER BY `minOrder` ASC [ RunTime:0.028905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845055 LIMIT 5 [ RunTime:0.030106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845055 ORDER BY `minOrder` ASC [ RunTime:0.023493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18845055 ORDER BY `unit` DESC [ RunTime:0.042289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18845055 LIMIT 2 [ RunTime:0.067476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18845055 ORDER BY `minOrder` ASC [ RunTime:0.013008s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033816s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451305 LIMIT 5 [ RunTime:0.010813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451305 ORDER BY `minOrder` ASC [ RunTime:0.020560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451305 ORDER BY `unit` DESC [ RunTime:0.035696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451305 LIMIT 2 [ RunTime:0.009796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451305 ORDER BY `minOrder` ASC [ RunTime:0.012088s ]
select * from pdf where partno='TL50BLZR1Y1B1G1' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.009349s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR1Y1B1G1' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.025759s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451305 AND `partno` = 'TL50BLZR1Y1B1G1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.028670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845859 [ RunTime:0.007739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451260 LIMIT 5 [ RunTime:0.003360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451260 ORDER BY `minOrder` ASC [ RunTime:0.014960s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451260 ORDER BY `unit` DESC [ RunTime:0.035392s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451260 LIMIT 2 [ RunTime:0.017135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451260 ORDER BY `minOrder` ASC [ RunTime:0.025278s ]
select * from pdf where partno='TL50BLZR1R1R1C' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.021981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR1R1R1C' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.009971s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451260 AND `partno` = 'TL50BLZR1R1R1C' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.031124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845647 [ RunTime:0.042346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451219 LIMIT 5 [ RunTime:0.027408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451219 ORDER BY `minOrder` ASC [ RunTime:0.015882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451219 ORDER BY `unit` DESC [ RunTime:0.050978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451219 LIMIT 2 [ RunTime:0.021789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451219 ORDER BY `minOrder` ASC [ RunTime:0.018713s ]
select * from pdf where partno='TL50BLZRGGA' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.022800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRGGA' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.036447s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451219 AND `partno` = 'TL50BLZRGGA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.068275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845810 [ RunTime:0.060119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451115 LIMIT 5 [ RunTime:0.029753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451115 ORDER BY `minOrder` ASC [ RunTime:0.074652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451115 ORDER BY `unit` DESC [ RunTime:0.033406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451115 LIMIT 2 [ RunTime:0.025794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451115 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
select * from pdf where partno='TL50BLZR2AOS4' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.028407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2AOS4' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.031825s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451115 AND `partno` = 'TL50BLZR2AOS4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.038599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845494 [ RunTime:0.030567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451064 LIMIT 5 [ RunTime:0.011117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451064 ORDER BY `minOrder` ASC [ RunTime:0.004193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451064 ORDER BY `unit` DESC [ RunTime:0.019342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451064 LIMIT 2 [ RunTime:0.051608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451064 ORDER BY `minOrder` ASC [ RunTime:0.012630s ]
select * from pdf where partno='TL50BLZRWAOS3I' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.003106s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRWAOS3I' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.005852s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451064 AND `partno` = 'TL50BLZRWAOS3I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.019535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845706 [ RunTime:0.014432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451057 LIMIT 5 [ RunTime:0.037474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451057 ORDER BY `minOrder` ASC [ RunTime:0.039530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451057 ORDER BY `unit` DESC [ RunTime:0.016447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451057 LIMIT 2 [ RunTime:0.030432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451057 ORDER BY `minOrder` ASC [ RunTime:0.006551s ]
select * from pdf where partno='TL50BLZR2AOSI' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.019182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2AOSI' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.005692s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451057 AND `partno` = 'TL50BLZR2AOSI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.020592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845404 [ RunTime:0.013346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64451055 LIMIT 5 [ RunTime:0.011252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451055 ORDER BY `minOrder` ASC [ RunTime:0.030831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64451055 ORDER BY `unit` DESC [ RunTime:0.004597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64451055 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64451055 ORDER BY `minOrder` ASC [ RunTime:0.001264s ]
select * from pdf where partno='TL50BLZR2AOS3' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.001234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2AOS3' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.010983s ]
SELECT `id` FROM `stock` WHERE `id` <> 64451055 AND `partno` = 'TL50BLZR2AOS3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.014730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845401 [ RunTime:0.002982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450987 LIMIT 5 [ RunTime:0.006824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450987 ORDER BY `minOrder` ASC [ RunTime:0.004926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450987 ORDER BY `unit` DESC [ RunTime:0.009048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450987 LIMIT 2 [ RunTime:0.019724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450987 ORDER BY `minOrder` ASC [ RunTime:0.005207s ]
select * from pdf where partno='TL50BLZRAOS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.002478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRAOS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.003509s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450987 AND `partno` = 'TL50BLZRAOS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.020502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845398 [ RunTime:0.012369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450930 LIMIT 5 [ RunTime:0.009912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450930 ORDER BY `minOrder` ASC [ RunTime:0.006861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450930 ORDER BY `unit` DESC [ RunTime:0.005648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450930 LIMIT 2 [ RunTime:0.013139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450930 ORDER BY `minOrder` ASC [ RunTime:0.008687s ]
select * from pdf where partno='TL50BLZR2Y2G2' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.000763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2Y2G2' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.002354s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450930 AND `partno` = 'TL50BLZR2Y2G2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845599 [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450830 LIMIT 5 [ RunTime:0.016234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450830 ORDER BY `minOrder` ASC [ RunTime:0.016325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450830 ORDER BY `unit` DESC [ RunTime:0.006086s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450830 LIMIT 2 [ RunTime:0.008164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450830 ORDER BY `minOrder` ASC [ RunTime:0.019956s ]
select * from pdf where partno='TL50BLZR2Y2ALS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.017369s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2Y2ALS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.002527s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450830 AND `partno` = 'TL50BLZR2Y2ALS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.017168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845536 [ RunTime:0.007083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450827 LIMIT 5 [ RunTime:0.001241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450827 ORDER BY `minOrder` ASC [ RunTime:0.008883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450827 ORDER BY `unit` DESC [ RunTime:0.014056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450827 LIMIT 2 [ RunTime:0.002372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450827 ORDER BY `minOrder` ASC [ RunTime:0.000526s ]
select * from pdf where partno='TL50BLZR1Y1ALS3QP' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.005580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR1Y1ALS3QP' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.002593s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450827 AND `partno` = 'TL50BLZR1Y1ALS3QP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.015097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845533 [ RunTime:0.003764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450628 LIMIT 5 [ RunTime:0.001611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450628 ORDER BY `minOrder` ASC [ RunTime:0.000915s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450628 ORDER BY `unit` DESC [ RunTime:0.006917s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450628 LIMIT 2 [ RunTime:0.002589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450628 ORDER BY `minOrder` ASC [ RunTime:0.004000s ]
select * from pdf where partno='TL50BLZR1AOS4' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.011748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR1AOS4' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.014700s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450628 AND `partno` = 'TL50BLZR1AOS4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.002344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238126 [ RunTime:0.007868s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450627 LIMIT 5 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450627 ORDER BY `minOrder` ASC [ RunTime:0.002897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450627 ORDER BY `unit` DESC [ RunTime:0.003070s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450627 LIMIT 2 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450627 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='TL50BLZR2AOS3IQP' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.000908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2AOS3IQP' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.000711s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450627 AND `partno` = 'TL50BLZR2AOS3IQP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.002078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15238125 [ RunTime:0.004721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450626 LIMIT 5 [ RunTime:0.001933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450626 ORDER BY `minOrder` ASC [ RunTime:0.000774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450626 ORDER BY `unit` DESC [ RunTime:0.000627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450626 LIMIT 2 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450626 ORDER BY `minOrder` ASC [ RunTime:0.003392s ]
select * from pdf where partno='TL50BLZRAOS3I' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.003431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRAOS3I' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.008977s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450626 AND `partno` = 'TL50BLZRAOS3I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.027178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845362 [ RunTime:0.028790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450530 LIMIT 5 [ RunTime:0.011949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450530 ORDER BY `minOrder` ASC [ RunTime:0.014158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450530 ORDER BY `unit` DESC [ RunTime:0.027883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450530 LIMIT 2 [ RunTime:0.040724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450530 ORDER BY `minOrder` ASC [ RunTime:0.014956s ]
select * from pdf where partno='TL50BLZR2AOS4I' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.008442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2AOS4I' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.015632s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450530 AND `partno` = 'TL50BLZR2AOS4I' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.022763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845206 [ RunTime:0.043963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450528 LIMIT 5 [ RunTime:0.020269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450528 ORDER BY `minOrder` ASC [ RunTime:0.017054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450528 ORDER BY `unit` DESC [ RunTime:0.010427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450528 LIMIT 2 [ RunTime:0.006020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450528 ORDER BY `minOrder` ASC [ RunTime:0.007540s ]
select * from pdf where partno='TL50BLZRAOS3' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.007819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRAOS3' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.012936s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450528 AND `partno` = 'TL50BLZRAOS3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.026394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845202 [ RunTime:0.013455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450376 LIMIT 5 [ RunTime:0.014236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450376 ORDER BY `minOrder` ASC [ RunTime:0.011612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450376 ORDER BY `unit` DESC [ RunTime:0.019667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450376 LIMIT 2 [ RunTime:0.009361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450376 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
select * from pdf where partno='TL50BLZRALS' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.005370s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRALS' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.004059s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450376 AND `partno` = 'TL50BLZRALS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.016783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845070 [ RunTime:0.019884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450375 LIMIT 5 [ RunTime:0.008655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450375 ORDER BY `minOrder` ASC [ RunTime:0.012222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450375 ORDER BY `unit` DESC [ RunTime:0.004796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450375 LIMIT 2 [ RunTime:0.005296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450375 ORDER BY `minOrder` ASC [ RunTime:0.005845s ]
select * from pdf where partno='TL50BLZR2ALSQP' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.013156s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2ALSQP' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.030846s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450375 AND `partno` = 'TL50BLZR2ALSQP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.052648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14186145 [ RunTime:0.005788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450374 LIMIT 5 [ RunTime:0.016922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450374 ORDER BY `minOrder` ASC [ RunTime:0.007366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450374 ORDER BY `unit` DESC [ RunTime:0.002839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450374 LIMIT 2 [ RunTime:0.013573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450374 ORDER BY `minOrder` ASC [ RunTime:0.008113s ]
select * from pdf where partno='TL50BLZR2ALS4' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.001207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZR2ALS4' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.003711s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450374 AND `partno` = 'TL50BLZR2ALS4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845067 [ RunTime:0.006614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64450373 LIMIT 5 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450373 ORDER BY `minOrder` ASC [ RunTime:0.003618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64450373 ORDER BY `unit` DESC [ RunTime:0.012173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64450373 LIMIT 2 [ RunTime:0.002273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64450373 ORDER BY `minOrder` ASC [ RunTime:0.004177s ]
select * from pdf where partno='TL50BLZRALS3' and brandshort='Banner Engineering Corporation' limit 1 [ RunTime:0.004163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TL50BLZRALS3' OR `brand` LIKE 'Banner Engineering Corporation%' ) ) LIMIT 1 [ RunTime:0.006454s ]
SELECT `id` FROM `stock` WHERE `id` <> 64450373 AND `partno` = 'TL50BLZRALS3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%banner engineering corporation%' ) [ RunTime:0.010697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18845062 [ RunTime:0.012172s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005422s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001402s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005751s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003535s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007324s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001263s ]
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 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002548s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'TL50BLZR%' OR `brand` LIKE 'TL50BLZR%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002902s ]