SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001592s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.250' , `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=2675&search=1' [ RunTime:0.002505s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001954s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003580s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001286s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.250' ) [ RunTime:0.013291s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001173s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002331s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001301s ]
SELECT * FROM `stock_search` WHERE `partno` = '2675' LIMIT 1 [ RunTime:0.032539s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-11 13:06:37' WHERE `partno` = '2675' [ RunTime:0.028862s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001333s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030958s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943533 LIMIT 5 [ RunTime:0.023281s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943533 ORDER BY `minOrder` ASC [ RunTime:0.017289s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943533 ORDER BY `unit` DESC [ RunTime:0.015990s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943533 LIMIT 2 [ RunTime:0.000905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943533 ORDER BY `minOrder` ASC [ RunTime:0.013371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13210685 LIMIT 5 [ RunTime:0.003871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13210685 ORDER BY `minOrder` ASC [ RunTime:0.018803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13210685 ORDER BY `unit` DESC [ RunTime:0.022790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13210685 LIMIT 2 [ RunTime:0.041510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13210685 ORDER BY `minOrder` ASC [ RunTime:0.031110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211260 LIMIT 5 [ RunTime:0.017672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211260 ORDER BY `minOrder` ASC [ RunTime:0.020006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211260 ORDER BY `unit` DESC [ RunTime:0.003348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211260 LIMIT 2 [ RunTime:0.027142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211260 ORDER BY `minOrder` ASC [ RunTime:0.017707s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211436 LIMIT 5 [ RunTime:0.014745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211436 ORDER BY `minOrder` ASC [ RunTime:0.009754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211436 ORDER BY `unit` DESC [ RunTime:0.055252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211436 LIMIT 2 [ RunTime:0.027554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211436 ORDER BY `minOrder` ASC [ RunTime:0.014962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943569 LIMIT 5 [ RunTime:0.037617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943569 ORDER BY `minOrder` ASC [ RunTime:0.066589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11943569 ORDER BY `unit` DESC [ RunTime:0.082157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11943569 LIMIT 2 [ RunTime:0.053118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11943569 ORDER BY `minOrder` ASC [ RunTime:0.012182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260697 LIMIT 5 [ RunTime:0.019913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260697 ORDER BY `minOrder` ASC [ RunTime:0.009300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260697 ORDER BY `unit` DESC [ RunTime:0.033542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260697 LIMIT 2 [ RunTime:0.066809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260697 ORDER BY `minOrder` ASC [ RunTime:0.026443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377127 LIMIT 5 [ RunTime:0.012132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377127 ORDER BY `minOrder` ASC [ RunTime:0.052329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13377127 ORDER BY `unit` DESC [ RunTime:0.014026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13377127 LIMIT 2 [ RunTime:0.039309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13377127 ORDER BY `minOrder` ASC [ RunTime:0.008391s ]
select * from pdf where partno='2675800302' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.040216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7358 LIMIT 5 [ RunTime:0.024310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7358 ORDER BY `minOrder` ASC [ RunTime:0.049902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 7358 ORDER BY `unit` DESC [ RunTime:0.032460s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 7358 LIMIT 2 [ RunTime:0.066316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 7358 ORDER BY `minOrder` ASC [ RunTime:0.025644s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675540002' OR `brand` LIKE 'FAIR-RITE%' ) ) LIMIT 1 [ RunTime:0.036806s ]
SELECT `id` FROM `stock` WHERE `id` <> 7358 AND `partno` = '2675540002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.028295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149445 [ RunTime:0.016876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260711 LIMIT 5 [ RunTime:0.025476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260711 ORDER BY `minOrder` ASC [ RunTime:0.027481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260711 ORDER BY `unit` DESC [ RunTime:0.067222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260711 LIMIT 2 [ RunTime:0.027627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260711 ORDER BY `minOrder` ASC [ RunTime:0.017485s ]
select * from pdf where partno='2675800202' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.016486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260722 LIMIT 5 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260722 ORDER BY `minOrder` ASC [ RunTime:0.023324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14260722 ORDER BY `unit` DESC [ RunTime:0.036058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14260722 LIMIT 2 [ RunTime:0.063100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14260722 ORDER BY `minOrder` ASC [ RunTime:0.003102s ]
select * from pdf where partno='2675801102' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.045753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263186 LIMIT 5 [ RunTime:0.065958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263186 ORDER BY `minOrder` ASC [ RunTime:0.053300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14263186 ORDER BY `unit` DESC [ RunTime:0.015682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14263186 LIMIT 2 [ RunTime:0.057435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14263186 ORDER BY `minOrder` ASC [ RunTime:0.022019s ]
select * from pdf where partno='2675801802' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.041231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046661 LIMIT 5 [ RunTime:0.014916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046661 ORDER BY `minOrder` ASC [ RunTime:0.020234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12046661 ORDER BY `unit` DESC [ RunTime:0.006529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12046661 LIMIT 2 [ RunTime:0.035670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12046661 ORDER BY `minOrder` ASC [ RunTime:0.060940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211620 LIMIT 5 [ RunTime:0.032750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211620 ORDER BY `minOrder` ASC [ RunTime:0.050754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13211620 ORDER BY `unit` DESC [ RunTime:0.017648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13211620 LIMIT 2 [ RunTime:0.047327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13211620 ORDER BY `minOrder` ASC [ RunTime:0.033764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183990 LIMIT 5 [ RunTime:0.046188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183990 ORDER BY `minOrder` ASC [ RunTime:0.062219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11183990 ORDER BY `unit` DESC [ RunTime:0.051190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11183990 LIMIT 2 [ RunTime:0.045286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11183990 ORDER BY `minOrder` ASC [ RunTime:0.045926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260332 LIMIT 5 [ RunTime:0.034456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260332 ORDER BY `minOrder` ASC [ RunTime:0.007724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260332 ORDER BY `unit` DESC [ RunTime:0.008800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260332 LIMIT 2 [ RunTime:0.022599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260332 ORDER BY `minOrder` ASC [ RunTime:0.060486s ]
select * from pdf where partno='2675' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.024488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400347 LIMIT 5 [ RunTime:0.044481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400347 ORDER BY `minOrder` ASC [ RunTime:0.062193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400347 ORDER BY `unit` DESC [ RunTime:0.044075s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400347 LIMIT 2 [ RunTime:0.043168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400347 ORDER BY `minOrder` ASC [ RunTime:0.019182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400346 LIMIT 5 [ RunTime:0.058759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400346 ORDER BY `minOrder` ASC [ RunTime:0.042245s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400346 ORDER BY `unit` DESC [ RunTime:0.052712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400346 LIMIT 2 [ RunTime:0.004514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400346 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400345 LIMIT 5 [ RunTime:0.008374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400345 ORDER BY `minOrder` ASC [ RunTime:0.019097s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400345 ORDER BY `unit` DESC [ RunTime:0.047913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400345 LIMIT 2 [ RunTime:0.021625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400345 ORDER BY `minOrder` ASC [ RunTime:0.007024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400344 LIMIT 5 [ RunTime:0.018242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400344 ORDER BY `minOrder` ASC [ RunTime:0.021888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400344 ORDER BY `unit` DESC [ RunTime:0.029724s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400344 LIMIT 2 [ RunTime:0.050753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400344 ORDER BY `minOrder` ASC [ RunTime:0.005136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14400343 LIMIT 5 [ RunTime:0.004777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400343 ORDER BY `minOrder` ASC [ RunTime:0.006148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14400343 ORDER BY `unit` DESC [ RunTime:0.001575s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14400343 LIMIT 2 [ RunTime:0.007665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14400343 ORDER BY `minOrder` ASC [ RunTime:0.001803s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32201481 LIMIT 5 [ RunTime:0.008380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32201481 ORDER BY `minOrder` ASC [ RunTime:0.008154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32201481 ORDER BY `unit` DESC [ RunTime:0.002222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32201481 LIMIT 2 [ RunTime:0.028899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32201481 ORDER BY `minOrder` ASC [ RunTime:0.008274s ]
select * from pdf where partno='2675000101' and brandshort='fair-rite' limit 1 [ RunTime:0.018168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675000101' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.048569s ]
SELECT `id` FROM `stock` WHERE `id` <> 32201481 AND `partno` = '2675000101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.044070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32197203 [ RunTime:0.040686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943533 [ RunTime:0.108204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32197203 LIMIT 5 [ RunTime:0.035521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32197203 ORDER BY `minOrder` ASC [ RunTime:0.098438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32197203 ORDER BY `unit` DESC [ RunTime:0.082590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32197203 LIMIT 2 [ RunTime:0.063622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32197203 ORDER BY `minOrder` ASC [ RunTime:0.033497s ]
select * from pdf where partno='2675000101' and brandshort='fair-rite' limit 1 [ RunTime:0.006560s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675000101' OR `brand` LIKE 'fair-rite%' ) ) LIMIT 1 [ RunTime:0.028836s ]
SELECT `id` FROM `stock` WHERE `id` <> 32197203 AND `partno` = '2675000101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite%' ) [ RunTime:0.022108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32201481 [ RunTime:0.047445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11943533 [ RunTime:0.004847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106388 LIMIT 5 [ RunTime:0.032082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106388 ORDER BY `minOrder` ASC [ RunTime:0.008811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106388 ORDER BY `unit` DESC [ RunTime:0.011903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106388 LIMIT 2 [ RunTime:0.017388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106388 ORDER BY `minOrder` ASC [ RunTime:0.021460s ]
select * from pdf where partno='2675' and brandshort='adafruit' limit 1 [ RunTime:0.018877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.020350s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149806 LIMIT 5 [ RunTime:0.059168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149806 ORDER BY `minOrder` ASC [ RunTime:0.042665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149806 ORDER BY `unit` DESC [ RunTime:0.058705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149806 LIMIT 2 [ RunTime:0.046092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149806 ORDER BY `minOrder` ASC [ RunTime:0.037897s ]
select * from pdf where partno='2675000101' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.040589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675000101' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.028105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149051 LIMIT 5 [ RunTime:0.031755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149051 ORDER BY `minOrder` ASC [ RunTime:0.048683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149051 ORDER BY `unit` DESC [ RunTime:0.061736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149051 LIMIT 2 [ RunTime:0.037050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149051 ORDER BY `minOrder` ASC [ RunTime:0.040412s ]
select * from pdf where partno='2675023002' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.028942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675023002' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.029108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149445 LIMIT 5 [ RunTime:0.008997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149445 ORDER BY `minOrder` ASC [ RunTime:0.024690s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149445 ORDER BY `unit` DESC [ RunTime:0.015615s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149445 LIMIT 2 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149445 ORDER BY `minOrder` ASC [ RunTime:0.008599s ]
select * from pdf where partno='2675540002' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.002501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675540002' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.014872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149172 LIMIT 5 [ RunTime:0.015369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149172 ORDER BY `minOrder` ASC [ RunTime:0.011364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149172 ORDER BY `unit` DESC [ RunTime:0.001306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149172 LIMIT 2 [ RunTime:0.004942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149172 ORDER BY `minOrder` ASC [ RunTime:0.003620s ]
select * from pdf where partno='2675102002' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.009514s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675102002' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.009652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149114 LIMIT 5 [ RunTime:0.008786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149114 ORDER BY `minOrder` ASC [ RunTime:0.010023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149114 ORDER BY `unit` DESC [ RunTime:0.018683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149114 LIMIT 2 [ RunTime:0.017615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149114 ORDER BY `minOrder` ASC [ RunTime:0.005988s ]
select * from pdf where partno='2675665702' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.012350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675665702' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.013212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149467 LIMIT 5 [ RunTime:0.027497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149467 ORDER BY `minOrder` ASC [ RunTime:0.012014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149467 ORDER BY `unit` DESC [ RunTime:0.006555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149467 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149467 ORDER BY `minOrder` ASC [ RunTime:0.000430s ]
select * from pdf where partno='2675626402' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.001871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675626402' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.004300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149501 LIMIT 5 [ RunTime:0.006394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149501 ORDER BY `minOrder` ASC [ RunTime:0.007019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149501 ORDER BY `unit` DESC [ RunTime:0.002162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149501 LIMIT 2 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149501 ORDER BY `minOrder` ASC [ RunTime:0.011086s ]
select * from pdf where partno='2675821502' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.009658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675821502' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402525 LIMIT 5 [ RunTime:0.003467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402525 ORDER BY `minOrder` ASC [ RunTime:0.004002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402525 ORDER BY `unit` DESC [ RunTime:0.012433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402525 LIMIT 2 [ RunTime:0.005294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402525 ORDER BY `minOrder` ASC [ RunTime:0.000527s ]
select * from pdf where partno='2675800302' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675800302' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000886s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402525 AND `partno` = '2675800302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.009981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377127 [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402141 LIMIT 5 [ RunTime:0.002234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402141 ORDER BY `minOrder` ASC [ RunTime:0.005725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402141 ORDER BY `unit` DESC [ RunTime:0.007067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402141 LIMIT 2 [ RunTime:0.013860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402141 ORDER BY `minOrder` ASC [ RunTime:0.000522s ]
select * from pdf where partno='2675801802' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675801802' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.011202s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402141 AND `partno` = '2675801802' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.014805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14263186 [ RunTime:0.018930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402059 LIMIT 5 [ RunTime:0.009372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402059 ORDER BY `minOrder` ASC [ RunTime:0.011834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402059 ORDER BY `unit` DESC [ RunTime:0.028097s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402059 LIMIT 2 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402059 ORDER BY `minOrder` ASC [ RunTime:0.008622s ]
select * from pdf where partno='2675801102' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675801102' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.000882s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402059 AND `partno` = '2675801102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.002537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260722 [ RunTime:0.016504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149402 LIMIT 5 [ RunTime:0.000724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149402 ORDER BY `minOrder` ASC [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149402 ORDER BY `unit` DESC [ RunTime:0.003116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149402 LIMIT 2 [ RunTime:0.002959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149402 ORDER BY `minOrder` ASC [ RunTime:0.004019s ]
select * from pdf where partno='2675540202' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.019597s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675540202' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64556164 LIMIT 5 [ RunTime:0.006895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556164 ORDER BY `minOrder` ASC [ RunTime:0.005987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64556164 ORDER BY `unit` DESC [ RunTime:0.002742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64556164 LIMIT 2 [ RunTime:0.005624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64556164 ORDER BY `minOrder` ASC [ RunTime:0.008160s ]
select * from pdf where partno='2675CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.031249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.001573s ]
SELECT `id` FROM `stock` WHERE `id` <> 64556164 AND `partno` = '2675CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.001881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63409487 LIMIT 5 [ RunTime:0.009288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63409487 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63409487 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63409487 LIMIT 2 [ RunTime:0.000957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63409487 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
select * from pdf where partno='2675' and brandshort='Pololu' limit 1 [ RunTime:0.000590s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.001657s ]
SELECT `id` FROM `stock` WHERE `id` <> 63409487 AND `partno` = '2675' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.000503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12046661 [ RunTime:0.001078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149455 LIMIT 5 [ RunTime:0.008885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149455 ORDER BY `minOrder` ASC [ RunTime:0.014899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149455 ORDER BY `unit` DESC [ RunTime:0.011523s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149455 LIMIT 2 [ RunTime:0.024052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149455 ORDER BY `minOrder` ASC [ RunTime:0.020072s ]
select * from pdf where partno='2675625102' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.012667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675625102' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.009971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64149549 LIMIT 5 [ RunTime:0.005066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149549 ORDER BY `minOrder` ASC [ RunTime:0.004124s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64149549 ORDER BY `unit` DESC [ RunTime:0.008135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64149549 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64149549 ORDER BY `minOrder` ASC [ RunTime:0.001519s ]
select * from pdf where partno='2675103002' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.010841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675103002' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.024639s ]
SELECT `id` FROM `stock` WHERE `id` <> 64149549 AND `partno` = '2675103002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.010339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13211620 [ RunTime:0.003470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402718 LIMIT 5 [ RunTime:0.000761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402718 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402718 ORDER BY `unit` DESC [ RunTime:0.004936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402718 LIMIT 2 [ RunTime:0.005552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402718 ORDER BY `minOrder` ASC [ RunTime:0.002145s ]
select * from pdf where partno='2675801202' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.003115s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675801202' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002357s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402718 AND `partno` = '2675801202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.016116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14261321 [ RunTime:0.007100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402730 LIMIT 5 [ RunTime:0.004090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402730 ORDER BY `minOrder` ASC [ RunTime:0.012213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402730 ORDER BY `unit` DESC [ RunTime:0.027976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402730 LIMIT 2 [ RunTime:0.021134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402730 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
select * from pdf where partno='2675805302' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.010639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675805302' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.013737s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402730 AND `partno` = '2675805302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.004706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14261326 [ RunTime:0.006726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64402000 LIMIT 5 [ RunTime:0.000851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402000 ORDER BY `minOrder` ASC [ RunTime:0.014978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64402000 ORDER BY `unit` DESC [ RunTime:0.001543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64402000 LIMIT 2 [ RunTime:0.003232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64402000 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='2675800202' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.005181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675800202' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.002119s ]
SELECT `id` FROM `stock` WHERE `id` <> 64402000 AND `partno` = '2675800202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.002946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260711 [ RunTime:0.002126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64403197 LIMIT 5 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64403197 ORDER BY `minOrder` ASC [ RunTime:0.004992s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64403197 ORDER BY `unit` DESC [ RunTime:0.001675s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64403197 LIMIT 2 [ RunTime:0.001925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64403197 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='2675800102' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.003606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675800102' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.004200s ]
SELECT `id` FROM `stock` WHERE `id` <> 64403197 AND `partno` = '2675800102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.014376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14260697 [ RunTime:0.020438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64403445 LIMIT 5 [ RunTime:0.004544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64403445 ORDER BY `minOrder` ASC [ RunTime:0.013606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64403445 ORDER BY `unit` DESC [ RunTime:0.011804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64403445 LIMIT 2 [ RunTime:0.002349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64403445 ORDER BY `minOrder` ASC [ RunTime:0.001635s ]
select * from pdf where partno='2675828302' and brandshort='Fair-Rite Products Corp.' limit 1 [ RunTime:0.000947s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2675828302' OR `brand` LIKE 'Fair-Rite Products Corp.%' ) ) LIMIT 1 [ RunTime:0.020505s ]
SELECT `id` FROM `stock` WHERE `id` <> 64403445 AND `partno` = '2675828302' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fair-rite products corp.%' ) [ RunTime:0.019458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13377421 [ RunTime:0.031946s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010014s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001860s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004384s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008508s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011680s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006526s ]
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 '2675%' OR `brand` LIKE '2675%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005832s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2675%' OR `brand` LIKE '2675%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021402s ]