SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001406s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `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=H11AA1&search=1' [ RunTime:0.006294s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001307s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003762s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001364s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.000850s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001250s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001645s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.005368s ]
SELECT * FROM `stock_search` WHERE `partno` = 'H11AA1' LIMIT 1 [ RunTime:0.010896s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-23 12:41:11' WHERE `partno` = 'H11AA1' [ RunTime:0.001716s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001684s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007974s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171373 LIMIT 5 [ RunTime:0.001468s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171373 ORDER BY `minOrder` ASC [ RunTime:0.002255s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171373 ORDER BY `unit` DESC [ RunTime:0.002675s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171373 LIMIT 2 [ RunTime:0.005705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171373 ORDER BY `minOrder` ASC [ RunTime:0.014990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693327 LIMIT 5 [ RunTime:0.005633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693327 ORDER BY `minOrder` ASC [ RunTime:0.003207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693327 ORDER BY `unit` DESC [ RunTime:0.000338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693327 LIMIT 2 [ RunTime:0.004627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693327 ORDER BY `minOrder` ASC [ RunTime:0.001969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170833 LIMIT 5 [ RunTime:0.001814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170833 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170833 ORDER BY `unit` DESC [ RunTime:0.000354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170833 LIMIT 2 [ RunTime:0.004901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170833 ORDER BY `minOrder` ASC [ RunTime:0.004288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15204570 LIMIT 5 [ RunTime:0.010728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204570 ORDER BY `minOrder` ASC [ RunTime:0.003375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15204570 ORDER BY `unit` DESC [ RunTime:0.000833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15204570 LIMIT 2 [ RunTime:0.006563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15204570 ORDER BY `minOrder` ASC [ RunTime:0.004225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203524 LIMIT 5 [ RunTime:0.032070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203524 ORDER BY `minOrder` ASC [ RunTime:0.020531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203524 ORDER BY `unit` DESC [ RunTime:0.009740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203524 LIMIT 2 [ RunTime:0.010761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203524 ORDER BY `minOrder` ASC [ RunTime:0.007442s ]
select * from pdf where partno='H11AA1-X001' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.003524s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690138 LIMIT 5 [ RunTime:0.008413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690138 ORDER BY `minOrder` ASC [ RunTime:0.002640s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690138 ORDER BY `unit` DESC [ RunTime:0.000393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690138 LIMIT 2 [ RunTime:0.006237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690138 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171488 LIMIT 5 [ RunTime:0.001089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171488 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14171488 ORDER BY `unit` DESC [ RunTime:0.007616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14171488 LIMIT 2 [ RunTime:0.000843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14171488 ORDER BY `minOrder` ASC [ RunTime:0.000459s ]
select * from pdf where partno='H11AA1-X007T' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.001731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690860 LIMIT 5 [ RunTime:0.004217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690860 ORDER BY `minOrder` ASC [ RunTime:0.001119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690860 ORDER BY `unit` DESC [ RunTime:0.001148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690860 LIMIT 2 [ RunTime:0.000412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690860 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693952 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693952 ORDER BY `minOrder` ASC [ RunTime:0.017417s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18693952 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18693952 LIMIT 2 [ RunTime:0.002617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18693952 ORDER BY `minOrder` ASC [ RunTime:0.003641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689620 LIMIT 5 [ RunTime:0.003183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689620 ORDER BY `minOrder` ASC [ RunTime:0.001258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689620 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689620 LIMIT 2 [ RunTime:0.002857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689620 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690859 LIMIT 5 [ RunTime:0.004263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690859 ORDER BY `minOrder` ASC [ RunTime:0.001385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18690859 ORDER BY `unit` DESC [ RunTime:0.000376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18690859 LIMIT 2 [ RunTime:0.010395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18690859 ORDER BY `minOrder` ASC [ RunTime:0.003681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203782 LIMIT 5 [ RunTime:0.007618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203782 ORDER BY `minOrder` ASC [ RunTime:0.003982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203782 ORDER BY `unit` DESC [ RunTime:0.015767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203782 LIMIT 2 [ RunTime:0.003593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203782 ORDER BY `minOrder` ASC [ RunTime:0.005412s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170885 LIMIT 5 [ RunTime:0.001415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170885 ORDER BY `minOrder` ASC [ RunTime:0.003324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14170885 ORDER BY `unit` DESC [ RunTime:0.010525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14170885 LIMIT 2 [ RunTime:0.005131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14170885 ORDER BY `minOrder` ASC [ RunTime:0.013157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203893 LIMIT 5 [ RunTime:0.028160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203893 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15203893 ORDER BY `unit` DESC [ RunTime:0.007648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15203893 LIMIT 2 [ RunTime:0.035742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15203893 ORDER BY `minOrder` ASC [ RunTime:0.023567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695237 LIMIT 5 [ RunTime:0.004839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695237 ORDER BY `minOrder` ASC [ RunTime:0.004174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695237 ORDER BY `unit` DESC [ RunTime:0.003063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695237 LIMIT 2 [ RunTime:0.011424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695237 ORDER BY `minOrder` ASC [ RunTime:0.001269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695236 LIMIT 5 [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695236 ORDER BY `minOrder` ASC [ RunTime:0.013302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695236 ORDER BY `unit` DESC [ RunTime:0.011580s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695236 LIMIT 2 [ RunTime:0.013356s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695236 ORDER BY `minOrder` ASC [ RunTime:0.013479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695235 LIMIT 5 [ RunTime:0.021107s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695235 ORDER BY `minOrder` ASC [ RunTime:0.013919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695235 ORDER BY `unit` DESC [ RunTime:0.006098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695235 LIMIT 2 [ RunTime:0.013286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695235 ORDER BY `minOrder` ASC [ RunTime:0.004216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18695234 LIMIT 5 [ RunTime:0.001192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695234 ORDER BY `minOrder` ASC [ RunTime:0.005120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18695234 ORDER BY `unit` DESC [ RunTime:0.000877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18695234 LIMIT 2 [ RunTime:0.009040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18695234 ORDER BY `minOrder` ASC [ RunTime:0.006666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694964 LIMIT 5 [ RunTime:0.005445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694964 ORDER BY `minOrder` ASC [ RunTime:0.002766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694964 ORDER BY `unit` DESC [ RunTime:0.007187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694964 LIMIT 2 [ RunTime:0.005414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694964 ORDER BY `minOrder` ASC [ RunTime:0.005933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18694412 LIMIT 5 [ RunTime:0.004861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694412 ORDER BY `minOrder` ASC [ RunTime:0.005306s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18694412 ORDER BY `unit` DESC [ RunTime:0.007677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18694412 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18694412 ORDER BY `minOrder` ASC [ RunTime:0.002872s ]
select * from pdf where partno='H11AA1-X009T' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.007205s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050580 LIMIT 5 [ RunTime:0.001763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050580 ORDER BY `minOrder` ASC [ RunTime:0.003077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050580 ORDER BY `unit` DESC [ RunTime:0.005509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050580 LIMIT 2 [ RunTime:0.001274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050580 ORDER BY `minOrder` ASC [ RunTime:0.006049s ]
select * from pdf where partno='h11aa1vm' and brandshort='onsemi' limit 1 [ RunTime:0.009131s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11aa1vm' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.039811s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050580 AND `partno` = 'h11aa1vm' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690859 [ RunTime:0.002757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51050969 LIMIT 5 [ RunTime:0.012359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050969 ORDER BY `minOrder` ASC [ RunTime:0.006148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51050969 ORDER BY `unit` DESC [ RunTime:0.009182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51050969 LIMIT 2 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51050969 ORDER BY `minOrder` ASC [ RunTime:0.001367s ]
select * from pdf where partno='h11aa1-x001' and brandshort='vishay semiconductors' limit 1 [ RunTime:0.001392s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'h11aa1-x001' OR `brand` LIKE 'vishay semiconductors%' ) ) LIMIT 1 [ RunTime:0.017851s ]
SELECT `id` FROM `stock` WHERE `id` <> 51050969 AND `partno` = 'h11aa1-x001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductors%' ) [ RunTime:0.013239s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648818 LIMIT 5 [ RunTime:0.017744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648818 ORDER BY `minOrder` ASC [ RunTime:0.019276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648818 ORDER BY `unit` DESC [ RunTime:0.006397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648818 LIMIT 2 [ RunTime:0.026727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648818 ORDER BY `minOrder` ASC [ RunTime:0.058381s ]
select * from pdf where partno='H11AA1SR2M' and brandshort='onsemi' limit 1 [ RunTime:0.050259s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SR2M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.049196s ]
SELECT `id` FROM `stock` WHERE `id` <> 37648818 AND `partno` = 'H11AA1SR2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.025474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171373 [ RunTime:0.019223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50451422 LIMIT 5 [ RunTime:0.004495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50451422 ORDER BY `minOrder` ASC [ RunTime:0.039105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50451422 ORDER BY `unit` DESC [ RunTime:0.015130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50451422 LIMIT 2 [ RunTime:0.007311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50451422 ORDER BY `minOrder` ASC [ RunTime:0.008404s ]
select * from pdf where partno='H11AA1SR2M' and brandshort='onsemi' limit 1 [ RunTime:0.003937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SR2M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.003402s ]
SELECT `id` FROM `stock` WHERE `id` <> 50451422 AND `partno` = 'H11AA1SR2M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.005210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171373 [ RunTime:0.012281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37648740 LIMIT 5 [ RunTime:0.020850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648740 ORDER BY `minOrder` ASC [ RunTime:0.002288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37648740 ORDER BY `unit` DESC [ RunTime:0.004997s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37648740 LIMIT 2 [ RunTime:0.004701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37648740 ORDER BY `minOrder` ASC [ RunTime:0.003662s ]
select * from pdf where partno='H11AA1M' and brandshort='onsemi' limit 1 [ RunTime:0.007494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.020290s ]
SELECT `id` FROM `stock` WHERE `id` <> 37648740 AND `partno` = 'H11AA1M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693327 [ RunTime:0.008418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50451482 LIMIT 5 [ RunTime:0.008557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50451482 ORDER BY `minOrder` ASC [ RunTime:0.007063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50451482 ORDER BY `unit` DESC [ RunTime:0.014079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50451482 LIMIT 2 [ RunTime:0.011302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50451482 ORDER BY `minOrder` ASC [ RunTime:0.017419s ]
select * from pdf where partno='H11AA1M' and brandshort='onsemi' limit 1 [ RunTime:0.026480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1M' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.000888s ]
SELECT `id` FROM `stock` WHERE `id` <> 50451482 AND `partno` = 'H11AA1M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.012929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693327 [ RunTime:0.004840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50453251 LIMIT 5 [ RunTime:0.001100s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453251 ORDER BY `minOrder` ASC [ RunTime:0.014298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50453251 ORDER BY `unit` DESC [ RunTime:0.029495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50453251 LIMIT 2 [ RunTime:0.032559s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453251 ORDER BY `minOrder` ASC [ RunTime:0.007347s ]
select * from pdf where partno='H11AA1W' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.024340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1W' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.024338s ]
SELECT `id` FROM `stock` WHERE `id` <> 50453251 AND `partno` = 'H11AA1W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.022329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170833 [ RunTime:0.010182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37650629 LIMIT 5 [ RunTime:0.003115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650629 ORDER BY `minOrder` ASC [ RunTime:0.002103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37650629 ORDER BY `unit` DESC [ RunTime:0.014981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37650629 LIMIT 2 [ RunTime:0.025105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650629 ORDER BY `minOrder` ASC [ RunTime:0.001591s ]
select * from pdf where partno='H11AA1W' and brandshort='Fairchild Semiconductor' limit 1 [ RunTime:0.004073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1W' OR `brand` LIKE 'Fairchild Semiconductor%' ) ) LIMIT 1 [ RunTime:0.000570s ]
SELECT `id` FROM `stock` WHERE `id` <> 37650629 AND `partno` = 'H11AA1W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%fairchild semiconductor%' ) [ RunTime:0.000990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14170833 [ RunTime:0.011466s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50452079 LIMIT 5 [ RunTime:0.001270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452079 ORDER BY `minOrder` ASC [ RunTime:0.002882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50452079 ORDER BY `unit` DESC [ RunTime:0.006430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50452079 LIMIT 2 [ RunTime:0.014997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452079 ORDER BY `minOrder` ASC [ RunTime:0.002229s ]
select * from pdf where partno='H11AA1SR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.010554s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.028843s ]
SELECT `id` FROM `stock` WHERE `id` <> 50452079 AND `partno` = 'H11AA1SR2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.007703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693952 [ RunTime:0.013033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649443 LIMIT 5 [ RunTime:0.014408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649443 ORDER BY `minOrder` ASC [ RunTime:0.019038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649443 ORDER BY `unit` DESC [ RunTime:0.029253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649443 LIMIT 2 [ RunTime:0.049208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649443 ORDER BY `minOrder` ASC [ RunTime:0.042708s ]
select * from pdf where partno='H11AA1SR2VM' and brandshort='onsemi' limit 1 [ RunTime:0.006896s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SR2VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.003588s ]
SELECT `id` FROM `stock` WHERE `id` <> 37649443 AND `partno` = 'H11AA1SR2VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.002225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18693952 [ RunTime:0.003311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50452151 LIMIT 5 [ RunTime:0.011394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452151 ORDER BY `minOrder` ASC [ RunTime:0.006435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50452151 ORDER BY `unit` DESC [ RunTime:0.022936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50452151 LIMIT 2 [ RunTime:0.030171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452151 ORDER BY `minOrder` ASC [ RunTime:0.022124s ]
select * from pdf where partno='H11AA1-X001' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.005961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1-X001' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.017053s ]
SELECT `id` FROM `stock` WHERE `id` <> 50452151 AND `partno` = 'H11AA1-X001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductor opto division%' ) [ RunTime:0.016926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203524 [ RunTime:0.018175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649517 LIMIT 5 [ RunTime:0.032739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649517 ORDER BY `minOrder` ASC [ RunTime:0.028047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649517 ORDER BY `unit` DESC [ RunTime:0.055165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649517 LIMIT 2 [ RunTime:0.010671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649517 ORDER BY `minOrder` ASC [ RunTime:0.004758s ]
select * from pdf where partno='H11AA1-X001' and brandshort='Vishay Semiconductor Opto Division' limit 1 [ RunTime:0.019836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1-X001' OR `brand` LIKE 'Vishay Semiconductor Opto Division%' ) ) LIMIT 1 [ RunTime:0.009024s ]
SELECT `id` FROM `stock` WHERE `id` <> 37649517 AND `partno` = 'H11AA1-X001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%vishay semiconductor opto division%' ) [ RunTime:0.005338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203524 [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37650411 LIMIT 5 [ RunTime:0.019972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650411 ORDER BY `minOrder` ASC [ RunTime:0.008606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37650411 ORDER BY `unit` DESC [ RunTime:0.017957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37650411 LIMIT 2 [ RunTime:0.013406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650411 ORDER BY `minOrder` ASC [ RunTime:0.003974s ]
select * from pdf where partno='H11AA1SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.020792s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.014121s ]
SELECT `id` FROM `stock` WHERE `id` <> 37650411 AND `partno` = 'H11AA1SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.011313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171355 [ RunTime:0.011283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50453036 LIMIT 5 [ RunTime:0.008857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453036 ORDER BY `minOrder` ASC [ RunTime:0.038548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50453036 ORDER BY `unit` DESC [ RunTime:0.007462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50453036 LIMIT 2 [ RunTime:0.022539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453036 ORDER BY `minOrder` ASC [ RunTime:0.038748s ]
select * from pdf where partno='H11AA1SM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.013469s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.031689s ]
SELECT `id` FROM `stock` WHERE `id` <> 50453036 AND `partno` = 'H11AA1SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.037278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14171355 [ RunTime:0.004618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649439 LIMIT 5 [ RunTime:0.013729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649439 ORDER BY `minOrder` ASC [ RunTime:0.009083s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649439 ORDER BY `unit` DESC [ RunTime:0.015742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649439 LIMIT 2 [ RunTime:0.017881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649439 ORDER BY `minOrder` ASC [ RunTime:0.018710s ]
select * from pdf where partno='H11AA1XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.039485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.014527s ]
SELECT `id` FROM `stock` WHERE `id` <> 37649439 AND `partno` = 'H11AA1XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.012288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690138 [ RunTime:0.008754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50452074 LIMIT 5 [ RunTime:0.016354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452074 ORDER BY `minOrder` ASC [ RunTime:0.010908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50452074 ORDER BY `unit` DESC [ RunTime:0.022182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50452074 LIMIT 2 [ RunTime:0.019064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452074 ORDER BY `minOrder` ASC [ RunTime:0.011164s ]
select * from pdf where partno='H11AA1XSM' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.008274s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1XSM' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.006153s ]
SELECT `id` FROM `stock` WHERE `id` <> 50452074 AND `partno` = 'H11AA1XSM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%isocom components 2004 ltd%' ) [ RunTime:0.007824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690138 [ RunTime:0.012685s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37650405 LIMIT 5 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650405 ORDER BY `minOrder` ASC [ RunTime:0.001576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37650405 ORDER BY `unit` DESC [ RunTime:0.019687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37650405 LIMIT 2 [ RunTime:0.013410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37650405 ORDER BY `minOrder` ASC [ RunTime:0.007274s ]
select * from pdf where partno='H11AA1' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.005580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.016926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50453030 LIMIT 5 [ RunTime:0.023016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453030 ORDER BY `minOrder` ASC [ RunTime:0.010508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50453030 ORDER BY `unit` DESC [ RunTime:0.009224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50453030 LIMIT 2 [ RunTime:0.009020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50453030 ORDER BY `minOrder` ASC [ RunTime:0.002599s ]
select * from pdf where partno='H11AA1' and brandshort='Isocom Components 2004 LTD' limit 1 [ RunTime:0.003684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1' OR `brand` LIKE 'Isocom Components 2004 LTD%' ) ) LIMIT 1 [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50452583 LIMIT 5 [ RunTime:0.004676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452583 ORDER BY `minOrder` ASC [ RunTime:0.007113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50452583 ORDER BY `unit` DESC [ RunTime:0.029805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50452583 LIMIT 2 [ RunTime:0.010477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452583 ORDER BY `minOrder` ASC [ RunTime:0.043548s ]
select * from pdf where partno='H11AA1VM' and brandshort='onsemi' limit 1 [ RunTime:0.024581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.031416s ]
SELECT `id` FROM `stock` WHERE `id` <> 50452583 AND `partno` = 'H11AA1VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.007247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690859 [ RunTime:0.005384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649402 LIMIT 5 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649402 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649402 ORDER BY `unit` DESC [ RunTime:0.007084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649402 LIMIT 2 [ RunTime:0.008245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649402 ORDER BY `minOrder` ASC [ RunTime:0.001713s ]
select * from pdf where partno='H11AA1VM' and brandshort='onsemi' limit 1 [ RunTime:0.005428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1VM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.013478s ]
SELECT `id` FROM `stock` WHERE `id` <> 37649402 AND `partno` = 'H11AA1VM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.023981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690859 [ RunTime:0.010329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37652100 LIMIT 5 [ RunTime:0.004909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37652100 ORDER BY `minOrder` ASC [ RunTime:0.018945s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37652100 ORDER BY `unit` DESC [ RunTime:0.065226s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37652100 LIMIT 2 [ RunTime:0.011469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37652100 ORDER BY `minOrder` ASC [ RunTime:0.040766s ]
select * from pdf where partno='H11AA1SVM' and brandshort='onsemi' limit 1 [ RunTime:0.033380s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.029066s ]
SELECT `id` FROM `stock` WHERE `id` <> 37652100 AND `partno` = 'H11AA1SVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.010348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690860 [ RunTime:0.006518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50454713 LIMIT 5 [ RunTime:0.020133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50454713 ORDER BY `minOrder` ASC [ RunTime:0.012890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50454713 ORDER BY `unit` DESC [ RunTime:0.022328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50454713 LIMIT 2 [ RunTime:0.013206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50454713 ORDER BY `minOrder` ASC [ RunTime:0.013484s ]
select * from pdf where partno='H11AA1SVM' and brandshort='onsemi' limit 1 [ RunTime:0.007023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'H11AA1SVM' OR `brand` LIKE 'onsemi%' ) ) LIMIT 1 [ RunTime:0.005628s ]
SELECT `id` FROM `stock` WHERE `id` <> 50454713 AND `partno` = 'H11AA1SVM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.029706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18690860 [ RunTime:0.010035s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019492s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012168s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003857s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005056s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003140s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009376s ]
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 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005857s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'H11AA1%' OR `brand` LIKE 'H11AA1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.028677s ]