SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.000972s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=1525&search=1' [ RunTime:0.008996s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001684s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003657s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001560s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.010262s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001359s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006910s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001543s ]
SELECT * FROM `stock_search` WHERE `partno` = '1525' LIMIT 1 [ RunTime:0.011068s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-21 14:28:52' WHERE `partno` = '1525' [ RunTime:0.010054s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001239s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041586s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413648 LIMIT 5 [ RunTime:0.006623s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413648 ORDER BY `minOrder` ASC [ RunTime:0.011074s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16413648 ORDER BY `unit` DESC [ RunTime:0.013548s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16413648 LIMIT 2 [ RunTime:0.020696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16413648 ORDER BY `minOrder` ASC [ RunTime:0.011196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11528529 LIMIT 5 [ RunTime:0.018785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11528529 ORDER BY `minOrder` ASC [ RunTime:0.005108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11528529 ORDER BY `unit` DESC [ RunTime:0.011903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11528529 LIMIT 2 [ RunTime:0.026981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11528529 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
select * from pdf where partno='15250682601000' and brandshort='HARTING' limit 1 [ RunTime:0.016942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11526700 LIMIT 5 [ RunTime:0.015546s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11526700 ORDER BY `minOrder` ASC [ RunTime:0.011117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11526700 ORDER BY `unit` DESC [ RunTime:0.009116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11526700 LIMIT 2 [ RunTime:0.009092s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11526700 ORDER BY `minOrder` ASC [ RunTime:0.016263s ]
select * from pdf where partno='15250262601000' and brandshort='HARTING' limit 1 [ RunTime:0.007375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12520201 LIMIT 5 [ RunTime:0.013297s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520201 ORDER BY `minOrder` ASC [ RunTime:0.004058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12520201 ORDER BY `unit` DESC [ RunTime:0.008046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12520201 LIMIT 2 [ RunTime:0.012236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12520201 ORDER BY `minOrder` ASC [ RunTime:0.012710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672504 LIMIT 5 [ RunTime:0.006397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672504 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12672504 ORDER BY `unit` DESC [ RunTime:0.005188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12672504 LIMIT 2 [ RunTime:0.009476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672504 ORDER BY `minOrder` ASC [ RunTime:0.005448s ]
select * from pdf where partno='15250062601000' and brandshort='HARTING' limit 1 [ RunTime:0.009352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518772 LIMIT 5 [ RunTime:0.028188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518772 ORDER BY `minOrder` ASC [ RunTime:0.001987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518772 ORDER BY `unit` DESC [ RunTime:0.005258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518772 LIMIT 2 [ RunTime:0.003421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518772 ORDER BY `minOrder` ASC [ RunTime:0.005638s ]
select * from pdf where partno='15250322601000' and brandshort='HARTING' limit 1 [ RunTime:0.001048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422542 LIMIT 5 [ RunTime:0.006726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422542 ORDER BY `minOrder` ASC [ RunTime:0.009318s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422542 ORDER BY `unit` DESC [ RunTime:0.007431s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422542 LIMIT 2 [ RunTime:0.003637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422542 ORDER BY `minOrder` ASC [ RunTime:0.000658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422539 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422539 ORDER BY `minOrder` ASC [ RunTime:0.006274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422539 ORDER BY `unit` DESC [ RunTime:0.001381s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422539 LIMIT 2 [ RunTime:0.001308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422539 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408415 LIMIT 5 [ RunTime:0.002382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408415 ORDER BY `minOrder` ASC [ RunTime:0.002662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408415 ORDER BY `unit` DESC [ RunTime:0.000555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408415 LIMIT 2 [ RunTime:0.000582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408415 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538084 LIMIT 5 [ RunTime:0.002369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538084 ORDER BY `minOrder` ASC [ RunTime:0.004814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538084 ORDER BY `unit` DESC [ RunTime:0.001461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538084 LIMIT 2 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538084 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538079 LIMIT 5 [ RunTime:0.000940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538079 ORDER BY `minOrder` ASC [ RunTime:0.000665s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538079 ORDER BY `unit` DESC [ RunTime:0.001772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538079 LIMIT 2 [ RunTime:0.007610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538079 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408406 LIMIT 5 [ RunTime:0.002764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408406 ORDER BY `minOrder` ASC [ RunTime:0.003818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14408406 ORDER BY `unit` DESC [ RunTime:0.002738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14408406 LIMIT 2 [ RunTime:0.000934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14408406 ORDER BY `minOrder` ASC [ RunTime:0.000416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518329 LIMIT 5 [ RunTime:0.004572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518329 ORDER BY `minOrder` ASC [ RunTime:0.001195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518329 ORDER BY `unit` DESC [ RunTime:0.003783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518329 LIMIT 2 [ RunTime:0.007245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518329 ORDER BY `minOrder` ASC [ RunTime:0.002654s ]
select * from pdf where partno='15250162601000' and brandshort='HARTING' limit 1 [ RunTime:0.002186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12673000 LIMIT 5 [ RunTime:0.007596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673000 ORDER BY `minOrder` ASC [ RunTime:0.000864s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12673000 ORDER BY `unit` DESC [ RunTime:0.003194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12673000 LIMIT 2 [ RunTime:0.018077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673000 ORDER BY `minOrder` ASC [ RunTime:0.009910s ]
select * from pdf where partno='15250102601000' and brandshort='HARTING' limit 1 [ RunTime:0.017658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672977 LIMIT 5 [ RunTime:0.014085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672977 ORDER BY `minOrder` ASC [ RunTime:0.007353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12672977 ORDER BY `unit` DESC [ RunTime:0.006067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12672977 LIMIT 2 [ RunTime:0.000562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12672977 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='15250082601000' and brandshort='HARTING' limit 1 [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066766 LIMIT 5 [ RunTime:0.013980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066766 ORDER BY `minOrder` ASC [ RunTime:0.005990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12066766 ORDER BY `unit` DESC [ RunTime:0.011382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12066766 LIMIT 2 [ RunTime:0.021149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12066766 ORDER BY `minOrder` ASC [ RunTime:0.011901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674232 LIMIT 5 [ RunTime:0.003489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674232 ORDER BY `minOrder` ASC [ RunTime:0.013265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12674232 ORDER BY `unit` DESC [ RunTime:0.011191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12674232 LIMIT 2 [ RunTime:0.022613s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12674232 ORDER BY `minOrder` ASC [ RunTime:0.003099s ]
select * from pdf where partno='15250182601000' and brandshort='HARTING' limit 1 [ RunTime:0.028107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11528180 LIMIT 5 [ RunTime:0.004243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11528180 ORDER BY `minOrder` ASC [ RunTime:0.004766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11528180 ORDER BY `unit` DESC [ RunTime:0.000808s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11528180 LIMIT 2 [ RunTime:0.019139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11528180 ORDER BY `minOrder` ASC [ RunTime:0.009562s ]
select * from pdf where partno='15250602601000' and brandshort='HARTING' limit 1 [ RunTime:0.012137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308339 LIMIT 5 [ RunTime:0.014383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308339 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17308339 ORDER BY `unit` DESC [ RunTime:0.004860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17308339 LIMIT 2 [ RunTime:0.019783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308339 ORDER BY `minOrder` ASC [ RunTime:0.009038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685488 LIMIT 5 [ RunTime:0.007637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685488 ORDER BY `minOrder` ASC [ RunTime:0.001746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12685488 ORDER BY `unit` DESC [ RunTime:0.002332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12685488 LIMIT 2 [ RunTime:0.008387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685488 ORDER BY `minOrder` ASC [ RunTime:0.005834s ]
select * from pdf where partno='15250342601000' and brandshort='HARTING' limit 1 [ RunTime:0.002031s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016863s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32207219 LIMIT 5 [ RunTime:0.000631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207219 ORDER BY `minOrder` ASC [ RunTime:0.012453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32207219 ORDER BY `unit` DESC [ RunTime:0.003791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32207219 LIMIT 2 [ RunTime:0.004647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32207219 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='1525a 0101000' and brandshort='belden wire & cable' limit 1 [ RunTime:0.008160s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525a 0101000' OR `brand` LIKE 'belden wire & cable%' ) ) LIMIT 1 [ RunTime:0.007613s ]
SELECT `id` FROM `stock` WHERE `id` <> 32207219 AND `partno` = '1525a 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden wire & cable%' ) [ RunTime:0.004805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269104 LIMIT 5 [ RunTime:0.004835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269104 ORDER BY `minOrder` ASC [ RunTime:0.003389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269104 ORDER BY `unit` DESC [ RunTime:0.002793s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269104 LIMIT 2 [ RunTime:0.011720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269104 ORDER BY `minOrder` ASC [ RunTime:0.011928s ]
select * from pdf where partno='15250062601000' and brandshort='harting' limit 1 [ RunTime:0.007021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250062601000' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.008302s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269104 AND `partno` = '15250062601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.003462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672504 [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269406 LIMIT 5 [ RunTime:0.007805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269406 ORDER BY `minOrder` ASC [ RunTime:0.011612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269406 ORDER BY `unit` DESC [ RunTime:0.003038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269406 LIMIT 2 [ RunTime:0.006336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269406 ORDER BY `minOrder` ASC [ RunTime:0.005668s ]
select * from pdf where partno='15250802601000' and brandshort='harting' limit 1 [ RunTime:0.002326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250802601000' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.003165s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269406 AND `partno` = '15250802601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.007656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59775552 [ RunTime:0.012037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32269405 LIMIT 5 [ RunTime:0.020738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269405 ORDER BY `minOrder` ASC [ RunTime:0.004418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32269405 ORDER BY `unit` DESC [ RunTime:0.009020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32269405 LIMIT 2 [ RunTime:0.008473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32269405 ORDER BY `minOrder` ASC [ RunTime:0.001102s ]
select * from pdf where partno='15250602601000' and brandshort='harting' limit 1 [ RunTime:0.001241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250602601000' OR `brand` LIKE 'harting%' ) ) LIMIT 1 [ RunTime:0.006611s ]
SELECT `id` FROM `stock` WHERE `id` <> 32269405 AND `partno` = '15250602601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.006018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11528180 [ RunTime:0.006544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32310843 LIMIT 5 [ RunTime:0.000551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310843 ORDER BY `minOrder` ASC [ RunTime:0.008031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32310843 ORDER BY `unit` DESC [ RunTime:0.002243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32310843 LIMIT 2 [ RunTime:0.002000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32310843 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
select * from pdf where partno='1525820000' and brandshort='weidmuller' limit 1 [ RunTime:0.002171s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525820000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.012726s ]
SELECT `id` FROM `stock` WHERE `id` <> 32310843 AND `partno` = '1525820000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.009673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182349 [ RunTime:0.007847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32308784 LIMIT 5 [ RunTime:0.000714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32308784 ORDER BY `minOrder` ASC [ RunTime:0.001332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32308784 ORDER BY `unit` DESC [ RunTime:0.002020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32308784 LIMIT 2 [ RunTime:0.012628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32308784 ORDER BY `minOrder` ASC [ RunTime:0.005121s ]
select * from pdf where partno='1525944' and brandshort='phoenix contact' limit 1 [ RunTime:0.002463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525944' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.006825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078747 LIMIT 5 [ RunTime:0.001585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078747 ORDER BY `minOrder` ASC [ RunTime:0.011526s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078747 ORDER BY `unit` DESC [ RunTime:0.006683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078747 LIMIT 2 [ RunTime:0.004453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078747 ORDER BY `minOrder` ASC [ RunTime:0.000720s ]
select * from pdf where partno='1525943' and brandshort='phoenix contact' limit 1 [ RunTime:0.001412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525943' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078511 LIMIT 5 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078511 ORDER BY `minOrder` ASC [ RunTime:0.008277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078511 ORDER BY `unit` DESC [ RunTime:0.012468s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078511 LIMIT 2 [ RunTime:0.019018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078511 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
select * from pdf where partno='1525945' and brandshort='phoenix contact' limit 1 [ RunTime:0.000990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525945' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078518 LIMIT 5 [ RunTime:0.002333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078518 ORDER BY `minOrder` ASC [ RunTime:0.000600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078518 ORDER BY `unit` DESC [ RunTime:0.017926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078518 LIMIT 2 [ RunTime:0.018893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078518 ORDER BY `minOrder` ASC [ RunTime:0.010377s ]
select * from pdf where partno='1525939' and brandshort='phoenix contact' limit 1 [ RunTime:0.015917s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525939' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.011396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51078504 LIMIT 5 [ RunTime:0.006274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078504 ORDER BY `minOrder` ASC [ RunTime:0.005642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51078504 ORDER BY `unit` DESC [ RunTime:0.009432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51078504 LIMIT 2 [ RunTime:0.021482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51078504 ORDER BY `minOrder` ASC [ RunTime:0.001561s ]
select * from pdf where partno='1525942' and brandshort='phoenix contact' limit 1 [ RunTime:0.002731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525942' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.006623s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63064362 LIMIT 5 [ RunTime:0.001599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064362 ORDER BY `minOrder` ASC [ RunTime:0.011605s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63064362 ORDER BY `unit` DESC [ RunTime:0.001404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63064362 LIMIT 2 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63064362 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='1525A 0101000' and brandshort='Belden Inc.' limit 1 [ RunTime:0.001235s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525A 0101000' OR `brand` LIKE 'Belden Inc.%' ) ) LIMIT 1 [ RunTime:0.006311s ]
SELECT `id` FROM `stock` WHERE `id` <> 63064362 AND `partno` = '1525A 0101000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%belden inc.%' ) [ RunTime:0.003167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16413648 [ RunTime:0.001288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753609 LIMIT 5 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753609 ORDER BY `minOrder` ASC [ RunTime:0.001900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753609 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753609 LIMIT 2 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753609 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='15250682601000' and brandshort='HARTING' limit 1 [ RunTime:0.002572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250682601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002810s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753609 AND `partno` = '15250682601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.003533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11528529 [ RunTime:0.013435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753166 LIMIT 5 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753166 ORDER BY `minOrder` ASC [ RunTime:0.013096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753166 ORDER BY `unit` DESC [ RunTime:0.020568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753166 LIMIT 2 [ RunTime:0.009649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753166 ORDER BY `minOrder` ASC [ RunTime:0.008358s ]
select * from pdf where partno='15250262601000' and brandshort='HARTING' limit 1 [ RunTime:0.003213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250262601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.003198s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753166 AND `partno` = '15250262601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.012672s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11526700 [ RunTime:0.006768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126890 LIMIT 5 [ RunTime:0.024564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126890 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126890 ORDER BY `unit` DESC [ RunTime:0.003005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126890 LIMIT 2 [ RunTime:0.005133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126890 ORDER BY `minOrder` ASC [ RunTime:0.001898s ]
select * from pdf where partno='15254F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15254F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004284s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126890 AND `partno` = '15254F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.013885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408415 [ RunTime:0.004607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126881 LIMIT 5 [ RunTime:0.001617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126881 ORDER BY `minOrder` ASC [ RunTime:0.002819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126881 ORDER BY `unit` DESC [ RunTime:0.006247s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126881 LIMIT 2 [ RunTime:0.009860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126881 ORDER BY `minOrder` ASC [ RunTime:0.001750s ]
select * from pdf where partno='15250F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.011741s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126881 AND `partno` = '15250F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.002151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538084 [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126845 LIMIT 5 [ RunTime:0.004835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126845 ORDER BY `minOrder` ASC [ RunTime:0.008828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126845 ORDER BY `unit` DESC [ RunTime:0.003245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126845 LIMIT 2 [ RunTime:0.004011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126845 ORDER BY `minOrder` ASC [ RunTime:0.000680s ]
select * from pdf where partno='15250B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.003715s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.008926s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126845 AND `partno` = '15250B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.002896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538079 [ RunTime:0.007102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126795 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126795 ORDER BY `minOrder` ASC [ RunTime:0.004385s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126795 ORDER BY `unit` DESC [ RunTime:0.000525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126795 LIMIT 2 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126795 ORDER BY `minOrder` ASC [ RunTime:0.001953s ]
select * from pdf where partno='15250' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001455s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004467s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126795 AND `partno` = '15250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.019548s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422539 [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126858 LIMIT 5 [ RunTime:0.011950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126858 ORDER BY `minOrder` ASC [ RunTime:0.002099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126858 ORDER BY `unit` DESC [ RunTime:0.003491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126858 LIMIT 2 [ RunTime:0.007986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126858 ORDER BY `minOrder` ASC [ RunTime:0.002559s ]
select * from pdf where partno='15254B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.011473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15254B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.004807s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126858 AND `partno` = '15254B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.004713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422542 [ RunTime:0.012827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126799 LIMIT 5 [ RunTime:0.007147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126799 ORDER BY `minOrder` ASC [ RunTime:0.018062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126799 ORDER BY `unit` DESC [ RunTime:0.012324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126799 LIMIT 2 [ RunTime:0.000788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126799 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
select * from pdf where partno='15254' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15254' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.006491s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126799 AND `partno` = '15254' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.008772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14408406 [ RunTime:0.000510s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752845 LIMIT 5 [ RunTime:0.009788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752845 ORDER BY `minOrder` ASC [ RunTime:0.002446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752845 ORDER BY `unit` DESC [ RunTime:0.020011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752845 LIMIT 2 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752845 ORDER BY `minOrder` ASC [ RunTime:0.005449s ]
select * from pdf where partno='15250062601000' and brandshort='HARTING' limit 1 [ RunTime:0.001719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250062601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011170s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752845 AND `partno` = '15250062601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.011768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672504 [ RunTime:0.009537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752932 LIMIT 5 [ RunTime:0.002519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752932 ORDER BY `minOrder` ASC [ RunTime:0.007415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752932 ORDER BY `unit` DESC [ RunTime:0.000656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752932 LIMIT 2 [ RunTime:0.002039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752932 ORDER BY `minOrder` ASC [ RunTime:0.004204s ]
select * from pdf where partno='15250102601000' and brandshort='HARTING' limit 1 [ RunTime:0.007376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250102601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001397s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752932 AND `partno` = '15250102601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.021256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12673000 [ RunTime:0.014436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752888 LIMIT 5 [ RunTime:0.008510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752888 ORDER BY `minOrder` ASC [ RunTime:0.005051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752888 ORDER BY `unit` DESC [ RunTime:0.008169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752888 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752888 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='15250082601000' and brandshort='HARTING' limit 1 [ RunTime:0.013719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250082601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.002884s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752888 AND `partno` = '15250082601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12672977 [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127829 LIMIT 5 [ RunTime:0.004085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127829 ORDER BY `minOrder` ASC [ RunTime:0.011949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127829 ORDER BY `unit` DESC [ RunTime:0.001100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127829 LIMIT 2 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127829 ORDER BY `minOrder` ASC [ RunTime:0.003189s ]
select * from pdf where partno='15258F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001072s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15258F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.021471s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127829 AND `partno` = '15258F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.008902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127797 LIMIT 5 [ RunTime:0.000875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127797 ORDER BY `minOrder` ASC [ RunTime:0.005442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127797 ORDER BY `unit` DESC [ RunTime:0.006636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127797 LIMIT 2 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127797 ORDER BY `minOrder` ASC [ RunTime:0.000325s ]
select * from pdf where partno='15258B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001345s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15258B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.001166s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127797 AND `partno` = '15258B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753084 LIMIT 5 [ RunTime:0.003993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753084 ORDER BY `minOrder` ASC [ RunTime:0.004986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753084 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753084 LIMIT 2 [ RunTime:0.004943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753084 ORDER BY `minOrder` ASC [ RunTime:0.002999s ]
select * from pdf where partno='15250182601000' and brandshort='HARTING' limit 1 [ RunTime:0.003654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250182601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008610s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753084 AND `partno` = '15250182601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.008310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674232 [ RunTime:0.010461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750791 LIMIT 5 [ RunTime:0.015638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750791 ORDER BY `minOrder` ASC [ RunTime:0.007300s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750791 ORDER BY `unit` DESC [ RunTime:0.004122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750791 LIMIT 2 [ RunTime:0.006927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750791 ORDER BY `minOrder` ASC [ RunTime:0.006566s ]
select * from pdf where partno='15250322601000' and brandshort='HARTING' limit 1 [ RunTime:0.004600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250322601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001328s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750791 AND `partno` = '15250322601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.009922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518772 [ RunTime:0.010835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64558932 LIMIT 5 [ RunTime:0.001478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558932 ORDER BY `minOrder` ASC [ RunTime:0.014512s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64558932 ORDER BY `unit` DESC [ RunTime:0.015630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64558932 LIMIT 2 [ RunTime:0.013742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64558932 ORDER BY `minOrder` ASC [ RunTime:0.003602s ]
select * from pdf where partno='1525CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007934s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1525CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.004129s ]
SELECT `id` FROM `stock` WHERE `id` <> 64558932 AND `partno` = '1525CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.004843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12066766 [ RunTime:0.007351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750654 LIMIT 5 [ RunTime:0.007367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750654 ORDER BY `minOrder` ASC [ RunTime:0.012486s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750654 ORDER BY `unit` DESC [ RunTime:0.023651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750654 LIMIT 2 [ RunTime:0.013849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750654 ORDER BY `minOrder` ASC [ RunTime:0.003131s ]
select * from pdf where partno='15250162601000' and brandshort='HARTING' limit 1 [ RunTime:0.000801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250162601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.008256s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750654 AND `partno` = '15250162601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.021436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518329 [ RunTime:0.022877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753557 LIMIT 5 [ RunTime:0.016290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753557 ORDER BY `minOrder` ASC [ RunTime:0.016248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753557 ORDER BY `unit` DESC [ RunTime:0.011797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753557 LIMIT 2 [ RunTime:0.012521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753557 ORDER BY `minOrder` ASC [ RunTime:0.002992s ]
select * from pdf where partno='15250602601000' and brandshort='HARTING' limit 1 [ RunTime:0.001978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250602601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.025087s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753557 AND `partno` = '15250602601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.015592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11528180 [ RunTime:0.008572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750890 LIMIT 5 [ RunTime:0.005715s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750890 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750890 ORDER BY `unit` DESC [ RunTime:0.008428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750890 LIMIT 2 [ RunTime:0.007306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750890 ORDER BY `minOrder` ASC [ RunTime:0.008669s ]
select * from pdf where partno='15250502601000' and brandshort='HARTING' limit 1 [ RunTime:0.002796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15250502601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001743s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750890 AND `partno` = '15250502601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.004271s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003427s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019612s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005301s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010916s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004653s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001836s ]
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 '1525%' OR `brand` LIKE '1525%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001988s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1525%' OR `brand` LIKE '1525%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007811s ]