SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002409s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=AC1020&search=1' [ RunTime:0.001974s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001345s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000626s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001308s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000883s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.000959s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004650s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001242s ]
SELECT * FROM `stock_search` WHERE `partno` = 'AC1020' LIMIT 1 [ RunTime:0.001005s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 08:11:32' WHERE `partno` = 'AC1020' [ RunTime:0.008813s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001575s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012416s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15889711 LIMIT 5 [ RunTime:0.008381s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15889711 ORDER BY `minOrder` ASC [ RunTime:0.006986s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15889711 ORDER BY `unit` DESC [ RunTime:0.005002s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15889711 LIMIT 2 [ RunTime:0.006290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15889711 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='AC1020FK-0720RL' and brandshort='YAGEO' limit 1 [ RunTime:0.008036s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258166 LIMIT 5 [ RunTime:0.013143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258166 ORDER BY `minOrder` ASC [ RunTime:0.022039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13258166 ORDER BY `unit` DESC [ RunTime:0.022085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13258166 LIMIT 2 [ RunTime:0.022973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13258166 ORDER BY `minOrder` ASC [ RunTime:0.007445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11245002 LIMIT 5 [ RunTime:0.016365s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245002 ORDER BY `minOrder` ASC [ RunTime:0.035178s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11245002 ORDER BY `unit` DESC [ RunTime:0.019051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11245002 LIMIT 2 [ RunTime:0.014995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11245002 ORDER BY `minOrder` ASC [ RunTime:0.016120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17263154 LIMIT 5 [ RunTime:0.011092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17263154 ORDER BY `minOrder` ASC [ RunTime:0.004920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17263154 ORDER BY `unit` DESC [ RunTime:0.028079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17263154 LIMIT 2 [ RunTime:0.002971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17263154 ORDER BY `minOrder` ASC [ RunTime:0.001245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391132 LIMIT 5 [ RunTime:0.017330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391132 ORDER BY `minOrder` ASC [ RunTime:0.011490s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391132 ORDER BY `unit` DESC [ RunTime:0.001647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391132 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391132 ORDER BY `minOrder` ASC [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149817 LIMIT 5 [ RunTime:0.002580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149817 ORDER BY `minOrder` ASC [ RunTime:0.013081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149817 ORDER BY `unit` DESC [ RunTime:0.018889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149817 LIMIT 2 [ RunTime:0.001050s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149817 ORDER BY `minOrder` ASC [ RunTime:0.001667s ]
select * from pdf where partno='AC1020FK-0733KL' and brandshort='YAGEO' limit 1 [ RunTime:0.006385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149816 LIMIT 5 [ RunTime:0.026403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149816 ORDER BY `minOrder` ASC [ RunTime:0.011029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149816 ORDER BY `unit` DESC [ RunTime:0.005262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149816 LIMIT 2 [ RunTime:0.007228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149816 ORDER BY `minOrder` ASC [ RunTime:0.008003s ]
select * from pdf where partno='AC1020FK-071K82L' and brandshort='YAGEO' limit 1 [ RunTime:0.017995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149815 LIMIT 5 [ RunTime:0.008660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149815 ORDER BY `minOrder` ASC [ RunTime:0.018070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149815 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149815 LIMIT 2 [ RunTime:0.012279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149815 ORDER BY `minOrder` ASC [ RunTime:0.007610s ]
select * from pdf where partno='AC1020FK-074K02L' and brandshort='YAGEO' limit 1 [ RunTime:0.000840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149814 LIMIT 5 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149814 ORDER BY `minOrder` ASC [ RunTime:0.003434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149814 ORDER BY `unit` DESC [ RunTime:0.002448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149814 LIMIT 2 [ RunTime:0.029787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149814 ORDER BY `minOrder` ASC [ RunTime:0.003523s ]
select * from pdf where partno='AC1020FK-0768RL' and brandshort='YAGEO' limit 1 [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149813 LIMIT 5 [ RunTime:0.008985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149813 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149813 ORDER BY `unit` DESC [ RunTime:0.006193s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149813 LIMIT 2 [ RunTime:0.008429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149813 ORDER BY `minOrder` ASC [ RunTime:0.001401s ]
select * from pdf where partno='AC1020FK-0775RL' and brandshort='YAGEO' limit 1 [ RunTime:0.009905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149812 LIMIT 5 [ RunTime:0.008661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149812 ORDER BY `minOrder` ASC [ RunTime:0.012937s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149812 ORDER BY `unit` DESC [ RunTime:0.005103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149812 LIMIT 2 [ RunTime:0.011157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149812 ORDER BY `minOrder` ASC [ RunTime:0.000503s ]
select * from pdf where partno='AC1020FK-07510RL' and brandshort='YAGEO' limit 1 [ RunTime:0.007954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149811 LIMIT 5 [ RunTime:0.017527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149811 ORDER BY `minOrder` ASC [ RunTime:0.026062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149811 ORDER BY `unit` DESC [ RunTime:0.020528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149811 LIMIT 2 [ RunTime:0.020173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149811 ORDER BY `minOrder` ASC [ RunTime:0.011445s ]
select * from pdf where partno='AC1020FK-079R1L' and brandshort='YAGEO' limit 1 [ RunTime:0.017371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149810 LIMIT 5 [ RunTime:0.013906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149810 ORDER BY `minOrder` ASC [ RunTime:0.005920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149810 ORDER BY `unit` DESC [ RunTime:0.002571s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149810 LIMIT 2 [ RunTime:0.004358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149810 ORDER BY `minOrder` ASC [ RunTime:0.008493s ]
select * from pdf where partno='AC1020FK-0730RL' and brandshort='YAGEO' limit 1 [ RunTime:0.004807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149809 LIMIT 5 [ RunTime:0.014014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149809 ORDER BY `minOrder` ASC [ RunTime:0.019369s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149809 ORDER BY `unit` DESC [ RunTime:0.015774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149809 LIMIT 2 [ RunTime:0.003057s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149809 ORDER BY `minOrder` ASC [ RunTime:0.002589s ]
select * from pdf where partno='AC1020FK-078R2L' and brandshort='YAGEO' limit 1 [ RunTime:0.013737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149808 LIMIT 5 [ RunTime:0.014484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149808 ORDER BY `minOrder` ASC [ RunTime:0.013878s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149808 ORDER BY `unit` DESC [ RunTime:0.004737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149808 LIMIT 2 [ RunTime:0.000498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149808 ORDER BY `minOrder` ASC [ RunTime:0.000401s ]
select * from pdf where partno='AC1020FK-07820RL' and brandshort='YAGEO' limit 1 [ RunTime:0.004797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149807 LIMIT 5 [ RunTime:0.004721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149807 ORDER BY `minOrder` ASC [ RunTime:0.016929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149807 ORDER BY `unit` DESC [ RunTime:0.019379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149807 LIMIT 2 [ RunTime:0.010293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149807 ORDER BY `minOrder` ASC [ RunTime:0.009681s ]
select * from pdf where partno='AC1020FK-07360RL' and brandshort='YAGEO' limit 1 [ RunTime:0.004126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149806 LIMIT 5 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149806 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149806 ORDER BY `unit` DESC [ RunTime:0.017093s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149806 LIMIT 2 [ RunTime:0.007537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149806 ORDER BY `minOrder` ASC [ RunTime:0.003085s ]
select * from pdf where partno='AC1020FK-07390RL' and brandshort='YAGEO' limit 1 [ RunTime:0.006667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149805 LIMIT 5 [ RunTime:0.001759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149805 ORDER BY `minOrder` ASC [ RunTime:0.010741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149805 ORDER BY `unit` DESC [ RunTime:0.001287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149805 LIMIT 2 [ RunTime:0.007131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149805 ORDER BY `minOrder` ASC [ RunTime:0.004465s ]
select * from pdf where partno='AC1020FK-0751RL' and brandshort='YAGEO' limit 1 [ RunTime:0.007015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149804 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149804 ORDER BY `minOrder` ASC [ RunTime:0.013472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149804 ORDER BY `unit` DESC [ RunTime:0.002556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149804 LIMIT 2 [ RunTime:0.007823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149804 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
select * from pdf where partno='AC1020FK-0747RL' and brandshort='YAGEO' limit 1 [ RunTime:0.005878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18149803 LIMIT 5 [ RunTime:0.009276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149803 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18149803 ORDER BY `unit` DESC [ RunTime:0.003288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18149803 LIMIT 2 [ RunTime:0.017658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18149803 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='AC1020FK-077R5L' and brandshort='YAGEO' limit 1 [ RunTime:0.000861s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51109585 LIMIT 5 [ RunTime:0.015494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109585 ORDER BY `minOrder` ASC [ RunTime:0.004308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51109585 ORDER BY `unit` DESC [ RunTime:0.000517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51109585 LIMIT 2 [ RunTime:0.018549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109585 ORDER BY `minOrder` ASC [ RunTime:0.004871s ]
select * from pdf where partno='ac102015' and brandshort='microchip technology' limit 1 [ RunTime:0.021084s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ac102015' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.046551s ]
SELECT `id` FROM `stock` WHERE `id` <> 51109585 AND `partno` = 'ac102015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.010520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17263154 [ RunTime:0.017608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51108189 LIMIT 5 [ RunTime:0.008371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51108189 ORDER BY `minOrder` ASC [ RunTime:0.006757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51108189 ORDER BY `unit` DESC [ RunTime:0.003303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51108189 LIMIT 2 [ RunTime:0.011000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51108189 ORDER BY `minOrder` ASC [ RunTime:0.005660s ]
select * from pdf where partno='ac102013' and brandshort='microchip technology' limit 1 [ RunTime:0.014357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ac102013' OR `brand` LIKE 'microchip technology%' ) ) LIMIT 1 [ RunTime:0.013540s ]
SELECT `id` FROM `stock` WHERE `id` <> 51108189 AND `partno` = 'ac102013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.041414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390575 [ RunTime:0.011899s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51373855 LIMIT 5 [ RunTime:0.009381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51373855 ORDER BY `minOrder` ASC [ RunTime:0.008927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51373855 ORDER BY `unit` DESC [ RunTime:0.004019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51373855 LIMIT 2 [ RunTime:0.030486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51373855 ORDER BY `minOrder` ASC [ RunTime:0.005722s ]
select * from pdf where partno='AC1020' and brandshort='Talema Group LLC' limit 1 [ RunTime:0.005006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020' OR `brand` LIKE 'Talema Group LLC%' ) ) LIMIT 1 [ RunTime:0.008745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33248387 LIMIT 5 [ RunTime:0.009654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33248387 ORDER BY `minOrder` ASC [ RunTime:0.010111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33248387 ORDER BY `unit` DESC [ RunTime:0.017073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33248387 LIMIT 2 [ RunTime:0.017042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33248387 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
select * from pdf where partno='AC1020FK-0720RL' and brandshort='YAGEO' limit 1 [ RunTime:0.004519s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-0720RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.012438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33301504 LIMIT 5 [ RunTime:0.022079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33301504 ORDER BY `minOrder` ASC [ RunTime:0.021093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33301504 ORDER BY `unit` DESC [ RunTime:0.026795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33301504 LIMIT 2 [ RunTime:0.001927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33301504 ORDER BY `minOrder` ASC [ RunTime:0.013254s ]
select * from pdf where partno='AC1020FK-0710KL' and brandshort='YAGEO' limit 1 [ RunTime:0.005608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-0710KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.004431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57413771 LIMIT 5 [ RunTime:0.013920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413771 ORDER BY `minOrder` ASC [ RunTime:0.006836s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57413771 ORDER BY `unit` DESC [ RunTime:0.004654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57413771 LIMIT 2 [ RunTime:0.011388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57413771 ORDER BY `minOrder` ASC [ RunTime:0.009845s ]
select * from pdf where partno='AC10200-100' and brandshort='The Antenna Company' limit 1 [ RunTime:0.001103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC10200-100' OR `brand` LIKE 'The Antenna Company%' ) ) LIMIT 1 [ RunTime:0.009962s ]
SELECT `id` FROM `stock` WHERE `id` <> 57413771 AND `partno` = 'AC10200-100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%the antenna company%' ) [ RunTime:0.007383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258166 [ RunTime:0.003128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57248290 LIMIT 5 [ RunTime:0.008851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57248290 ORDER BY `minOrder` ASC [ RunTime:0.009346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57248290 ORDER BY `unit` DESC [ RunTime:0.012220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57248290 LIMIT 2 [ RunTime:0.007493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57248290 ORDER BY `minOrder` ASC [ RunTime:0.001828s ]
select * from pdf where partno='AC102015' and brandshort='Microchip Technology' limit 1 [ RunTime:0.016831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC102015' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.011056s ]
SELECT `id` FROM `stock` WHERE `id` <> 57248290 AND `partno` = 'AC102015' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.003448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17263154 [ RunTime:0.007179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57204370 LIMIT 5 [ RunTime:0.005021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204370 ORDER BY `minOrder` ASC [ RunTime:0.057844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57204370 ORDER BY `unit` DESC [ RunTime:0.003538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57204370 LIMIT 2 [ RunTime:0.003820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57204370 ORDER BY `minOrder` ASC [ RunTime:0.012241s ]
select * from pdf where partno='AC102016' and brandshort='Microchip Technology' limit 1 [ RunTime:0.024201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC102016' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.002824s ]
SELECT `id` FROM `stock` WHERE `id` <> 57204370 AND `partno` = 'AC102016' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.005871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391132 [ RunTime:0.002132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57420017 LIMIT 5 [ RunTime:0.003007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57420017 ORDER BY `minOrder` ASC [ RunTime:0.003361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57420017 ORDER BY `unit` DESC [ RunTime:0.000945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57420017 LIMIT 2 [ RunTime:0.016574s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57420017 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
select * from pdf where partno='AC10200-300' and brandshort='The Antenna Company' limit 1 [ RunTime:0.029873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC10200-300' OR `brand` LIKE 'The Antenna Company%' ) ) LIMIT 1 [ RunTime:0.040901s ]
SELECT `id` FROM `stock` WHERE `id` <> 57420017 AND `partno` = 'AC10200-300' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%the antenna company%' ) [ RunTime:0.030744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987257 [ RunTime:0.025055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57419986 LIMIT 5 [ RunTime:0.033770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57419986 ORDER BY `minOrder` ASC [ RunTime:0.018276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57419986 ORDER BY `unit` DESC [ RunTime:0.027709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57419986 LIMIT 2 [ RunTime:0.030586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57419986 ORDER BY `minOrder` ASC [ RunTime:0.010965s ]
select * from pdf where partno='AC10200-200' and brandshort='The Antenna Company' limit 1 [ RunTime:0.007237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC10200-200' OR `brand` LIKE 'The Antenna Company%' ) ) LIMIT 1 [ RunTime:0.008671s ]
SELECT `id` FROM `stock` WHERE `id` <> 57419986 AND `partno` = 'AC10200-200' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%the antenna company%' ) [ RunTime:0.003869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13258393 [ RunTime:0.002129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57419944 LIMIT 5 [ RunTime:0.034822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57419944 ORDER BY `minOrder` ASC [ RunTime:0.009608s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57419944 ORDER BY `unit` DESC [ RunTime:0.002946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57419944 LIMIT 2 [ RunTime:0.000755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57419944 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='AC10200-050' and brandshort='The Antenna Company' limit 1 [ RunTime:0.001983s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC10200-050' OR `brand` LIKE 'The Antenna Company%' ) ) LIMIT 1 [ RunTime:0.004441s ]
SELECT `id` FROM `stock` WHERE `id` <> 57419944 AND `partno` = 'AC10200-050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%the antenna company%' ) [ RunTime:0.010022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11987239 [ RunTime:0.007807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56173195 LIMIT 5 [ RunTime:0.007565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56173195 ORDER BY `minOrder` ASC [ RunTime:0.006241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56173195 ORDER BY `unit` DESC [ RunTime:0.015145s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56173195 LIMIT 2 [ RunTime:0.003514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56173195 ORDER BY `minOrder` ASC [ RunTime:0.001314s ]
select * from pdf where partno='AC102012-2' and brandshort='Microchip Technology' limit 1 [ RunTime:0.001612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC102012-2' OR `brand` LIKE 'Microchip Technology%' ) ) LIMIT 1 [ RunTime:0.003314s ]
SELECT `id` FROM `stock` WHERE `id` <> 56173195 AND `partno` = 'AC102012-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%microchip technology%' ) [ RunTime:0.011151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14697409 [ RunTime:0.012033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190794 LIMIT 5 [ RunTime:0.000588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190794 ORDER BY `minOrder` ASC [ RunTime:0.005213s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190794 ORDER BY `unit` DESC [ RunTime:0.017624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190794 LIMIT 2 [ RunTime:0.003968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190794 ORDER BY `minOrder` ASC [ RunTime:0.000245s ]
select * from pdf where partno='AC1020FK-0747K5L' and brandshort='YAGEO' limit 1 [ RunTime:0.001758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-0747K5L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.008535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190793 LIMIT 5 [ RunTime:0.016435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190793 ORDER BY `minOrder` ASC [ RunTime:0.000845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190793 ORDER BY `unit` DESC [ RunTime:0.016517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190793 LIMIT 2 [ RunTime:0.012619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190793 ORDER BY `minOrder` ASC [ RunTime:0.006374s ]
select * from pdf where partno='AC1020FK-074K99L' and brandshort='YAGEO' limit 1 [ RunTime:0.025886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-074K99L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.025470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190792 LIMIT 5 [ RunTime:0.021492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190792 ORDER BY `minOrder` ASC [ RunTime:0.034582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190792 ORDER BY `unit` DESC [ RunTime:0.009934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190792 LIMIT 2 [ RunTime:0.037890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190792 ORDER BY `minOrder` ASC [ RunTime:0.005127s ]
select * from pdf where partno='AC1020FK-0733KL' and brandshort='YAGEO' limit 1 [ RunTime:0.009269s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-0733KL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.035678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190791 LIMIT 5 [ RunTime:0.042006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190791 ORDER BY `minOrder` ASC [ RunTime:0.059410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190791 ORDER BY `unit` DESC [ RunTime:0.059030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190791 LIMIT 2 [ RunTime:0.052676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190791 ORDER BY `minOrder` ASC [ RunTime:0.007954s ]
select * from pdf where partno='AC1020FK-071K82L' and brandshort='YAGEO' limit 1 [ RunTime:0.036249s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-071K82L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.054348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190790 LIMIT 5 [ RunTime:0.114343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190790 ORDER BY `minOrder` ASC [ RunTime:0.106860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190790 ORDER BY `unit` DESC [ RunTime:0.053107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190790 LIMIT 2 [ RunTime:0.078378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190790 ORDER BY `minOrder` ASC [ RunTime:0.082261s ]
select * from pdf where partno='AC1020FK-074K75L' and brandshort='YAGEO' limit 1 [ RunTime:0.050510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-074K75L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.082987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190789 LIMIT 5 [ RunTime:0.065674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190789 ORDER BY `minOrder` ASC [ RunTime:0.048993s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190789 ORDER BY `unit` DESC [ RunTime:0.125782s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190789 LIMIT 2 [ RunTime:0.048102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190789 ORDER BY `minOrder` ASC [ RunTime:0.016147s ]
select * from pdf where partno='AC1020FK-071ML' and brandshort='YAGEO' limit 1 [ RunTime:0.039506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-071ML' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.052871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190788 LIMIT 5 [ RunTime:0.015789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190788 ORDER BY `minOrder` ASC [ RunTime:0.034730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190788 ORDER BY `unit` DESC [ RunTime:0.020156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190788 LIMIT 2 [ RunTime:0.057157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190788 ORDER BY `minOrder` ASC [ RunTime:0.011023s ]
select * from pdf where partno='AC1020FK-074K02L' and brandshort='YAGEO' limit 1 [ RunTime:0.003286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-074K02L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.011368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190787 LIMIT 5 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190787 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190787 ORDER BY `unit` DESC [ RunTime:0.009411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190787 LIMIT 2 [ RunTime:0.040795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190787 ORDER BY `minOrder` ASC [ RunTime:0.032779s ]
select * from pdf where partno='AC1020FK-0730RL' and brandshort='YAGEO' limit 1 [ RunTime:0.013790s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-0730RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.040176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190786 LIMIT 5 [ RunTime:0.082587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190786 ORDER BY `minOrder` ASC [ RunTime:0.033007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190786 ORDER BY `unit` DESC [ RunTime:0.028415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190786 LIMIT 2 [ RunTime:0.039446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190786 ORDER BY `minOrder` ASC [ RunTime:0.038134s ]
select * from pdf where partno='AC1020FK-07430RL' and brandshort='YAGEO' limit 1 [ RunTime:0.025552s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-07430RL' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.075222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38190785 LIMIT 5 [ RunTime:0.041449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190785 ORDER BY `minOrder` ASC [ RunTime:0.028689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38190785 ORDER BY `unit` DESC [ RunTime:0.056485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38190785 LIMIT 2 [ RunTime:0.025118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38190785 ORDER BY `minOrder` ASC [ RunTime:0.036979s ]
select * from pdf where partno='AC1020FK-073R3L' and brandshort='YAGEO' limit 1 [ RunTime:0.050940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'AC1020FK-073R3L' OR `brand` LIKE 'YAGEO%' ) ) LIMIT 1 [ RunTime:0.033423s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043087s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061252s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037828s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021796s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027309s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018251s ]
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 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012819s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'AC1020%' OR `brand` LIKE 'AC1020%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014738s ]