SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002175s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.149' , `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=1285&search=1' [ RunTime:0.003437s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001374s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001127s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002116s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.149' ) [ RunTime:0.000804s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002118s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002169s ]
SELECT * FROM `stock_search` WHERE `partno` = '1285' LIMIT 1 [ RunTime:0.000872s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-09-08 07:42:30' WHERE `partno` = '1285' [ RunTime:0.003112s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002395s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032231s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417063 LIMIT 5 [ RunTime:0.000852s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417063 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11417063 ORDER BY `unit` DESC [ RunTime:0.000322s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001238s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11417063 LIMIT 2 [ RunTime:0.000439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11417063 ORDER BY `minOrder` ASC [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516335 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516335 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12516335 ORDER BY `unit` DESC [ RunTime:0.000364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12516335 LIMIT 2 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12516335 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13453462 LIMIT 5 [ RunTime:0.002756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13453462 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13453462 ORDER BY `unit` DESC [ RunTime:0.000412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13453462 LIMIT 2 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13453462 ORDER BY `minOrder` ASC [ RunTime:0.000379s ]
select * from pdf where partno='1285AS-H-1R5M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000647s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14306918 LIMIT 5 [ RunTime:0.000651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14306918 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14306918 ORDER BY `unit` DESC [ RunTime:0.000358s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14306918 LIMIT 2 [ RunTime:0.000368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14306918 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='1285AS-H-R56M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16383962 LIMIT 5 [ RunTime:0.000747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16383962 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16383962 ORDER BY `unit` DESC [ RunTime:0.000349s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16383962 LIMIT 2 [ RunTime:0.000301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16383962 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='1285AS-H-1R0M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354865 LIMIT 5 [ RunTime:0.002767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354865 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14354865 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14354865 LIMIT 2 [ RunTime:0.000361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14354865 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881195 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881195 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881195 ORDER BY `unit` DESC [ RunTime:0.000336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881195 LIMIT 2 [ RunTime:0.000384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881195 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12891288 LIMIT 5 [ RunTime:0.001622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891288 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12891288 ORDER BY `unit` DESC [ RunTime:0.000309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12891288 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12891288 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258111 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258111 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258111 ORDER BY `unit` DESC [ RunTime:0.000313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258111 LIMIT 2 [ RunTime:0.000304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258111 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15008730 LIMIT 5 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008730 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15008730 ORDER BY `unit` DESC [ RunTime:0.000287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15008730 LIMIT 2 [ RunTime:0.000282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15008730 ORDER BY `minOrder` ASC [ RunTime:0.000327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173925 LIMIT 5 [ RunTime:0.002647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173925 ORDER BY `minOrder` ASC [ RunTime:0.000316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12173925 ORDER BY `unit` DESC [ RunTime:0.000333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12173925 LIMIT 2 [ RunTime:0.000288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173925 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268440 LIMIT 5 [ RunTime:0.000546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268440 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15268440 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15268440 LIMIT 2 [ RunTime:0.000299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15268440 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212786 LIMIT 5 [ RunTime:0.000533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212786 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212786 ORDER BY `unit` DESC [ RunTime:0.000293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212786 LIMIT 2 [ RunTime:0.000274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212786 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173932 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173932 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12173932 ORDER BY `unit` DESC [ RunTime:0.000294s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12173932 LIMIT 2 [ RunTime:0.000276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12173932 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186683 LIMIT 5 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186683 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11186683 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11186683 LIMIT 2 [ RunTime:0.000281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11186683 ORDER BY `minOrder` ASC [ RunTime:0.000294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042044 LIMIT 5 [ RunTime:0.000739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042044 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042044 ORDER BY `unit` DESC [ RunTime:0.000286s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042044 LIMIT 2 [ RunTime:0.000270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042044 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14308754 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14308754 ORDER BY `minOrder` ASC [ RunTime:0.000304s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14308754 ORDER BY `unit` DESC [ RunTime:0.000285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14308754 LIMIT 2 [ RunTime:0.000275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14308754 ORDER BY `minOrder` ASC [ RunTime:0.000292s ]
select * from pdf where partno='1285AS-H-2R2M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11192268 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192268 ORDER BY `minOrder` ASC [ RunTime:0.000322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11192268 ORDER BY `unit` DESC [ RunTime:0.000291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11192268 LIMIT 2 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192268 ORDER BY `minOrder` ASC [ RunTime:0.000303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11192267 LIMIT 5 [ RunTime:0.000323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192267 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11192267 ORDER BY `unit` DESC [ RunTime:0.000316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11192267 LIMIT 2 [ RunTime:0.000285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11192267 ORDER BY `minOrder` ASC [ RunTime:0.000302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19604838 LIMIT 5 [ RunTime:0.000554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19604838 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19604838 ORDER BY `unit` DESC [ RunTime:0.000296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19604838 LIMIT 2 [ RunTime:0.000310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19604838 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095434 LIMIT 5 [ RunTime:0.000269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095434 ORDER BY `minOrder` ASC [ RunTime:0.000507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095434 ORDER BY `unit` DESC [ RunTime:0.000254s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095434 LIMIT 2 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095434 ORDER BY `minOrder` ASC [ RunTime:0.000310s ]
select * from pdf where partno='1285' and brandshort='adafruit' limit 1 [ RunTime:0.000722s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001052s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095434 AND `partno` = '1285' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit%' ) [ RunTime:0.000626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258111 [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078034 LIMIT 5 [ RunTime:0.000261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078034 ORDER BY `minOrder` ASC [ RunTime:0.000685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078034 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078034 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078034 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='1285200000' and brandshort='weidmuller' limit 1 [ RunTime:0.000667s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285200000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.000741s ]
SELECT `id` FROM `stock` WHERE `id` <> 51078034 AND `partno` = '1285200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.000559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268440 [ RunTime:0.000329s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67445898 LIMIT 5 [ RunTime:0.000387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67445898 ORDER BY `minOrder` ASC [ RunTime:0.001991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67445898 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67445898 LIMIT 2 [ RunTime:0.000302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67445898 ORDER BY `minOrder` ASC [ RunTime:0.000340s ]
select * from pdf where partno='1285-ST' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000787s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285-ST' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000465s ]
SELECT `id` FROM `stock` WHERE `id` <> 67445898 AND `partno` = '1285-ST' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11417063 [ RunTime:0.000340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40458624 LIMIT 5 [ RunTime:0.000259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40458624 ORDER BY `minOrder` ASC [ RunTime:0.000596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40458624 ORDER BY `unit` DESC [ RunTime:0.000249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40458624 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40458624 ORDER BY `minOrder` ASC [ RunTime:0.000320s ]
select * from pdf where partno='1285AS-H-2R2M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285AS-H-2R2M=P2' OR `brand` LIKE 'Murata Electronics%' ) ) LIMIT 1 [ RunTime:0.000320s ]
SELECT `id` FROM `stock` WHERE `id` <> 40458624 AND `partno` = '1285AS-H-2R2M=P2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata electronics%' ) [ RunTime:0.000381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14308754 [ RunTime:0.000291s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67445902 LIMIT 5 [ RunTime:0.000303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67445902 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67445902 ORDER BY `unit` DESC [ RunTime:0.000239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67445902 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67445902 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1285' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.000953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 67445902 AND `partno` = '1285' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516335 [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40458625 LIMIT 5 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40458625 ORDER BY `minOrder` ASC [ RunTime:0.000312s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40458625 ORDER BY `unit` DESC [ RunTime:0.000308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40458625 LIMIT 2 [ RunTime:0.000235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40458625 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='1285AS-H-1R0M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000628s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285AS-H-1R0M=P2' OR `brand` LIKE 'Murata Electronics%' ) ) LIMIT 1 [ RunTime:0.000312s ]
SELECT `id` FROM `stock` WHERE `id` <> 40458625 AND `partno` = '1285AS-H-1R0M=P2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata electronics%' ) [ RunTime:0.000351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16383962 [ RunTime:0.000354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40464998 LIMIT 5 [ RunTime:0.000296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40464998 ORDER BY `minOrder` ASC [ RunTime:0.000692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40464998 ORDER BY `unit` DESC [ RunTime:0.000243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40464998 LIMIT 2 [ RunTime:0.000284s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40464998 ORDER BY `minOrder` ASC [ RunTime:0.000334s ]
select * from pdf where partno='1285AS-H-1R5M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285AS-H-1R5M=P2' OR `brand` LIKE 'Murata Electronics%' ) ) LIMIT 1 [ RunTime:0.000307s ]
SELECT `id` FROM `stock` WHERE `id` <> 40464998 AND `partno` = '1285AS-H-1R5M=P2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata electronics%' ) [ RunTime:0.000347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13453462 [ RunTime:0.000281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40465046 LIMIT 5 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40465046 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40465046 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40465046 LIMIT 2 [ RunTime:0.000234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40465046 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='1285AS-H-R56M=P2' and brandshort='Murata Electronics' limit 1 [ RunTime:0.000690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285AS-H-R56M=P2' OR `brand` LIKE 'Murata Electronics%' ) ) LIMIT 1 [ RunTime:0.000371s ]
SELECT `id` FROM `stock` WHERE `id` <> 40465046 AND `partno` = '1285AS-H-R56M=P2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata electronics%' ) [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14306918 [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68713747 LIMIT 5 [ RunTime:0.000254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68713747 ORDER BY `minOrder` ASC [ RunTime:0.000656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68713747 ORDER BY `unit` DESC [ RunTime:0.000250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68713747 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68713747 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='1285-6002' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.000775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285-6002' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.000388s ]
SELECT `id` FROM `stock` WHERE `id` <> 68713747 AND `partno` = '1285-6002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65127215 LIMIT 5 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65127215 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65127215 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65127215 LIMIT 2 [ RunTime:0.000236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65127215 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='12859' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12859' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000812s ]
SELECT `id` FROM `stock` WHERE `id` <> 65127215 AND `partno` = '12859' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14354865 [ RunTime:0.000280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70176092 LIMIT 5 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176092 ORDER BY `minOrder` ASC [ RunTime:0.000677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70176092 ORDER BY `unit` DESC [ RunTime:0.000244s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70176092 LIMIT 2 [ RunTime:0.000227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70176092 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
select * from pdf where partno='1285-38-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000630s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285-38-B-12' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000329s ]
SELECT `id` FROM `stock` WHERE `id` <> 70176092 AND `partno` = '1285-38-B-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 68713744 LIMIT 5 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68713744 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 68713744 ORDER BY `unit` DESC [ RunTime:0.000240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 68713744 LIMIT 2 [ RunTime:0.000232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 68713744 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='1285-6004' and brandshort='Amphenol SV Microwave' limit 1 [ RunTime:0.001013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285-6004' OR `brand` LIKE 'Amphenol SV Microwave%' ) ) LIMIT 1 [ RunTime:0.000347s ]
SELECT `id` FROM `stock` WHERE `id` <> 68713744 AND `partno` = '1285-6004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol sv microwave%' ) [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881195 [ RunTime:0.000274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 67136368 LIMIT 5 [ RunTime:0.000286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67136368 ORDER BY `minOrder` ASC [ RunTime:0.005104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 67136368 ORDER BY `unit` DESC [ RunTime:0.000281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 67136368 LIMIT 2 [ RunTime:0.000277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 67136368 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='12855' and brandshort='Bulgin' limit 1 [ RunTime:0.002820s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12855' OR `brand` LIKE 'Bulgin%' ) ) LIMIT 1 [ RunTime:0.000665s ]
SELECT `id` FROM `stock` WHERE `id` <> 67136368 AND `partno` = '12855' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin%' ) [ RunTime:0.000429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12891288 [ RunTime:0.000270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70178036 LIMIT 5 [ RunTime:0.000294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70178036 ORDER BY `minOrder` ASC [ RunTime:0.002512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70178036 ORDER BY `unit` DESC [ RunTime:0.000246s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70178036 LIMIT 2 [ RunTime:0.000228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70178036 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='1285-31-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.000939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285-31-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.000377s ]
SELECT `id` FROM `stock` WHERE `id` <> 70178036 AND `partno` = '1285-31-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.000345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042044 [ RunTime:0.000279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 70232793 LIMIT 5 [ RunTime:0.000283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70232793 ORDER BY `minOrder` ASC [ RunTime:0.000733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 70232793 ORDER BY `unit` DESC [ RunTime:0.000325s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 70232793 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 70232793 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='1285200000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285200000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000879s ]
SELECT `id` FROM `stock` WHERE `id` <> 70232793 AND `partno` = '1285200000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15268440 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65391844 LIMIT 5 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391844 ORDER BY `minOrder` ASC [ RunTime:0.002765s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65391844 ORDER BY `unit` DESC [ RunTime:0.000339s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65391844 LIMIT 2 [ RunTime:0.000298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391844 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
select * from pdf where partno='12856' and brandshort='Wiha' limit 1 [ RunTime:0.000683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12856' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000462s ]
SELECT `id` FROM `stock` WHERE `id` <> 65391844 AND `partno` = '12856' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173925 [ RunTime:0.000362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65391899 LIMIT 5 [ RunTime:0.000353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391899 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65391899 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65391899 LIMIT 2 [ RunTime:0.000331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391899 ORDER BY `minOrder` ASC [ RunTime:0.000357s ]
select * from pdf where partno='12854' and brandshort='Wiha' limit 1 [ RunTime:0.000687s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12854' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000587s ]
SELECT `id` FROM `stock` WHERE `id` <> 65391899 AND `partno` = '12854' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11186683 [ RunTime:0.000438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65391723 LIMIT 5 [ RunTime:0.000355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391723 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65391723 ORDER BY `unit` DESC [ RunTime:0.000363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65391723 LIMIT 2 [ RunTime:0.000322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391723 ORDER BY `minOrder` ASC [ RunTime:0.000371s ]
select * from pdf where partno='12857' and brandshort='Wiha' limit 1 [ RunTime:0.000573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12857' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000451s ]
SELECT `id` FROM `stock` WHERE `id` <> 65391723 AND `partno` = '12857' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12173932 [ RunTime:0.000374s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107779 LIMIT 5 [ RunTime:0.000333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107779 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107779 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107779 LIMIT 2 [ RunTime:0.000330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107779 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='1285002-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000515s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285002-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000426s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107779 AND `partno` = '1285002-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000488s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212786 [ RunTime:0.000369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65391848 LIMIT 5 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391848 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65391848 ORDER BY `unit` DESC [ RunTime:0.000319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65391848 LIMIT 2 [ RunTime:0.000309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391848 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
select * from pdf where partno='12852' and brandshort='Wiha' limit 1 [ RunTime:0.000788s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12852' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT `id` FROM `stock` WHERE `id` <> 65391848 AND `partno` = '12852' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11192268 [ RunTime:0.000358s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65391847 LIMIT 5 [ RunTime:0.000334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391847 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65391847 ORDER BY `unit` DESC [ RunTime:0.000331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65391847 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65391847 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='12851' and brandshort='Wiha' limit 1 [ RunTime:0.000508s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12851' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.000416s ]
SELECT `id` FROM `stock` WHERE `id` <> 65391847 AND `partno` = '12851' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11192267 [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 65347531 LIMIT 5 [ RunTime:0.000392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65347531 ORDER BY `minOrder` ASC [ RunTime:0.006426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 65347531 ORDER BY `unit` DESC [ RunTime:0.000340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 65347531 LIMIT 2 [ RunTime:0.000291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 65347531 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='1285002-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.000524s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1285002-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 65347531 AND `partno` = '1285002-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000506s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000813s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000786s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000740s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000714s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000740s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000707s ]
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 '1285%' OR `brand` LIKE '1285%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000801s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1285%' OR `brand` LIKE '1285%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001854s ]