SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003730s ]
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=15268&search=1' [ RunTime:0.003204s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002397s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003966s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001892s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.013541s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001768s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001739s ]
SELECT * FROM `stock_search` WHERE `partno` = '15268' LIMIT 1 [ RunTime:0.006352s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-21 14:20:55' WHERE `partno` = '15268' [ RunTime:0.009081s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002738s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013122s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19633541 LIMIT 5 [ RunTime:0.000822s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633541 ORDER BY `minOrder` ASC [ RunTime:0.000367s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19633541 ORDER BY `unit` DESC [ RunTime:0.010342s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.013452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19633541 LIMIT 2 [ RunTime:0.010675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19633541 ORDER BY `minOrder` ASC [ RunTime:0.009453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264826 LIMIT 5 [ RunTime:0.006721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264826 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19264826 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19264826 LIMIT 2 [ RunTime:0.003783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19264826 ORDER BY `minOrder` ASC [ RunTime:0.008844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17496886 LIMIT 5 [ RunTime:0.016431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496886 ORDER BY `minOrder` ASC [ RunTime:0.015162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17496886 ORDER BY `unit` DESC [ RunTime:0.000556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17496886 LIMIT 2 [ RunTime:0.002914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17496886 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17492560 LIMIT 5 [ RunTime:0.010368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17492560 ORDER BY `minOrder` ASC [ RunTime:0.005854s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17492560 ORDER BY `unit` DESC [ RunTime:0.011794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17492560 LIMIT 2 [ RunTime:0.002532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17492560 ORDER BY `minOrder` ASC [ RunTime:0.000352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17492559 LIMIT 5 [ RunTime:0.002989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17492559 ORDER BY `minOrder` ASC [ RunTime:0.002466s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17492559 ORDER BY `unit` DESC [ RunTime:0.016584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17492559 LIMIT 2 [ RunTime:0.004896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17492559 ORDER BY `minOrder` ASC [ RunTime:0.000306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17490727 LIMIT 5 [ RunTime:0.004158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490727 ORDER BY `minOrder` ASC [ RunTime:0.008918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17490727 ORDER BY `unit` DESC [ RunTime:0.005310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17490727 LIMIT 2 [ RunTime:0.004064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17490727 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17487643 LIMIT 5 [ RunTime:0.003120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487643 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17487643 ORDER BY `unit` DESC [ RunTime:0.006487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17487643 LIMIT 2 [ RunTime:0.000505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487643 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17487214 LIMIT 5 [ RunTime:0.003180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487214 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17487214 ORDER BY `unit` DESC [ RunTime:0.010395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17487214 LIMIT 2 [ RunTime:0.017270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17487214 ORDER BY `minOrder` ASC [ RunTime:0.007112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17486737 LIMIT 5 [ RunTime:0.002009s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486737 ORDER BY `minOrder` ASC [ RunTime:0.003117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17486737 ORDER BY `unit` DESC [ RunTime:0.001852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17486737 LIMIT 2 [ RunTime:0.010568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17486737 ORDER BY `minOrder` ASC [ RunTime:0.001764s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17485690 LIMIT 5 [ RunTime:0.002167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485690 ORDER BY `minOrder` ASC [ RunTime:0.004653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17485690 ORDER BY `unit` DESC [ RunTime:0.008184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17485690 LIMIT 2 [ RunTime:0.013115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17485690 ORDER BY `minOrder` ASC [ RunTime:0.001600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17483520 LIMIT 5 [ RunTime:0.005545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483520 ORDER BY `minOrder` ASC [ RunTime:0.003809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17483520 ORDER BY `unit` DESC [ RunTime:0.005599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17483520 LIMIT 2 [ RunTime:0.002287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483520 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17483025 LIMIT 5 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483025 ORDER BY `minOrder` ASC [ RunTime:0.003577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17483025 ORDER BY `unit` DESC [ RunTime:0.002931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17483025 LIMIT 2 [ RunTime:0.000583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483025 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17483024 LIMIT 5 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483024 ORDER BY `minOrder` ASC [ RunTime:0.000795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17483024 ORDER BY `unit` DESC [ RunTime:0.001544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17483024 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17483024 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17482464 LIMIT 5 [ RunTime:0.001147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17482464 ORDER BY `minOrder` ASC [ RunTime:0.008715s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17482464 ORDER BY `unit` DESC [ RunTime:0.015153s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17482464 LIMIT 2 [ RunTime:0.024093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17482464 ORDER BY `minOrder` ASC [ RunTime:0.002210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16615260 LIMIT 5 [ RunTime:0.019337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615260 ORDER BY `minOrder` ASC [ RunTime:0.014008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16615260 ORDER BY `unit` DESC [ RunTime:0.004932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16615260 LIMIT 2 [ RunTime:0.003287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16615260 ORDER BY `minOrder` ASC [ RunTime:0.003674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16614732 LIMIT 5 [ RunTime:0.011975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614732 ORDER BY `minOrder` ASC [ RunTime:0.007249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16614732 ORDER BY `unit` DESC [ RunTime:0.012925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16614732 LIMIT 2 [ RunTime:0.010810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16614732 ORDER BY `minOrder` ASC [ RunTime:0.000464s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16149354 LIMIT 5 [ RunTime:0.001138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149354 ORDER BY `minOrder` ASC [ RunTime:0.002043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16149354 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16149354 LIMIT 2 [ RunTime:0.006968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16149354 ORDER BY `minOrder` ASC [ RunTime:0.008432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15448317 LIMIT 5 [ RunTime:0.005733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448317 ORDER BY `minOrder` ASC [ RunTime:0.009338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15448317 ORDER BY `unit` DESC [ RunTime:0.008715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15448317 LIMIT 2 [ RunTime:0.002966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15448317 ORDER BY `minOrder` ASC [ RunTime:0.001439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14690935 LIMIT 5 [ RunTime:0.006393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690935 ORDER BY `minOrder` ASC [ RunTime:0.010258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14690935 ORDER BY `unit` DESC [ RunTime:0.005866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14690935 LIMIT 2 [ RunTime:0.009685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14690935 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14688895 LIMIT 5 [ RunTime:0.001101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14688895 ORDER BY `minOrder` ASC [ RunTime:0.003568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14688895 ORDER BY `unit` DESC [ RunTime:0.006646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14688895 LIMIT 2 [ RunTime:0.007504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14688895 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134495 LIMIT 5 [ RunTime:0.003638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134495 ORDER BY `minOrder` ASC [ RunTime:0.025542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134495 ORDER BY `unit` DESC [ RunTime:0.008525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134495 LIMIT 2 [ RunTime:0.012772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134495 ORDER BY `minOrder` ASC [ RunTime:0.008442s ]
select * from pdf where partno='1526866' and brandshort='phoenix contact' limit 1 [ RunTime:0.014676s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526866' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.042691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134409 LIMIT 5 [ RunTime:0.005003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134409 ORDER BY `minOrder` ASC [ RunTime:0.017150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134409 ORDER BY `unit` DESC [ RunTime:0.019702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134409 LIMIT 2 [ RunTime:0.018250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134409 ORDER BY `minOrder` ASC [ RunTime:0.015117s ]
select * from pdf where partno='1526878' and brandshort='phoenix contact' limit 1 [ RunTime:0.008929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526878' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.007273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134534 LIMIT 5 [ RunTime:0.003508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134534 ORDER BY `minOrder` ASC [ RunTime:0.004350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134534 ORDER BY `unit` DESC [ RunTime:0.005803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134534 LIMIT 2 [ RunTime:0.003168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134534 ORDER BY `minOrder` ASC [ RunTime:0.004031s ]
select * from pdf where partno='1526879' and brandshort='phoenix contact' limit 1 [ RunTime:0.002645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526879' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134533 LIMIT 5 [ RunTime:0.019772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134533 ORDER BY `minOrder` ASC [ RunTime:0.024471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134533 ORDER BY `unit` DESC [ RunTime:0.005144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134533 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134533 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='1526874' and brandshort='phoenix contact' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526874' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134496 LIMIT 5 [ RunTime:0.002368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134496 ORDER BY `minOrder` ASC [ RunTime:0.000971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134496 ORDER BY `unit` DESC [ RunTime:0.004960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134496 LIMIT 2 [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134496 ORDER BY `minOrder` ASC [ RunTime:0.000458s ]
select * from pdf where partno='1526872' and brandshort='phoenix contact' limit 1 [ RunTime:0.000914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526872' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134468 LIMIT 5 [ RunTime:0.000899s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134468 ORDER BY `minOrder` ASC [ RunTime:0.000898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134468 ORDER BY `unit` DESC [ RunTime:0.004576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134468 LIMIT 2 [ RunTime:0.001070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134468 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='1526886' and brandshort='phoenix contact' limit 1 [ RunTime:0.000804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526886' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.004146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134467 LIMIT 5 [ RunTime:0.001466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134467 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134467 ORDER BY `unit` DESC [ RunTime:0.005184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134467 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134467 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
select * from pdf where partno='1526882' and brandshort='phoenix contact' limit 1 [ RunTime:0.000749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526882' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134433 LIMIT 5 [ RunTime:0.002463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134433 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134433 ORDER BY `unit` DESC [ RunTime:0.006868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134433 LIMIT 2 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134433 ORDER BY `minOrder` ASC [ RunTime:0.001642s ]
select * from pdf where partno='1526891' and brandshort='phoenix contact' limit 1 [ RunTime:0.001081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526891' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134426 LIMIT 5 [ RunTime:0.002627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134426 ORDER BY `minOrder` ASC [ RunTime:0.005511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134426 ORDER BY `unit` DESC [ RunTime:0.001484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134426 LIMIT 2 [ RunTime:0.001978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134426 ORDER BY `minOrder` ASC [ RunTime:0.001811s ]
select * from pdf where partno='1526877' and brandshort='phoenix contact' limit 1 [ RunTime:0.000768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526877' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134425 LIMIT 5 [ RunTime:0.002130s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134425 ORDER BY `minOrder` ASC [ RunTime:0.005209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134425 ORDER BY `unit` DESC [ RunTime:0.001077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134425 LIMIT 2 [ RunTime:0.002524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134425 ORDER BY `minOrder` ASC [ RunTime:0.000393s ]
select * from pdf where partno='1526875' and brandshort='phoenix contact' limit 1 [ RunTime:0.001520s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526875' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.005831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134535 LIMIT 5 [ RunTime:0.004861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134535 ORDER BY `minOrder` ASC [ RunTime:0.004839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134535 ORDER BY `unit` DESC [ RunTime:0.000955s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134535 LIMIT 2 [ RunTime:0.004463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134535 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
select * from pdf where partno='1526885' and brandshort='phoenix contact' limit 1 [ RunTime:0.000783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526885' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32261999 LIMIT 5 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261999 ORDER BY `minOrder` ASC [ RunTime:0.002433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32261999 ORDER BY `unit` DESC [ RunTime:0.000484s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32261999 LIMIT 2 [ RunTime:0.009846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261999 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
select * from pdf where partno='1526873' and brandshort='phoenix contact' limit 1 [ RunTime:0.001759s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526873' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.001730s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32261052 LIMIT 5 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261052 ORDER BY `minOrder` ASC [ RunTime:0.000882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32261052 ORDER BY `unit` DESC [ RunTime:0.000425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32261052 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32261052 ORDER BY `minOrder` ASC [ RunTime:0.001405s ]
select * from pdf where partno='1526873' and brandshort='phoenix contact' limit 1 [ RunTime:0.000445s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526873' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.000323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32204983 LIMIT 5 [ RunTime:0.002591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204983 ORDER BY `minOrder` ASC [ RunTime:0.000888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32204983 ORDER BY `unit` DESC [ RunTime:0.000522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32204983 LIMIT 2 [ RunTime:0.001647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32204983 ORDER BY `minOrder` ASC [ RunTime:0.004316s ]
select * from pdf where partno='1526873' and brandshort='phoenix contact' limit 1 [ RunTime:0.000436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526873' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32167916 LIMIT 5 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167916 ORDER BY `minOrder` ASC [ RunTime:0.002408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32167916 ORDER BY `unit` DESC [ RunTime:0.002858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32167916 LIMIT 2 [ RunTime:0.003753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32167916 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='1526873' and brandshort='phoenix contact' limit 1 [ RunTime:0.000421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526873' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.000334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51134497 LIMIT 5 [ RunTime:0.000420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134497 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51134497 ORDER BY `unit` DESC [ RunTime:0.003508s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51134497 LIMIT 2 [ RunTime:0.000818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51134497 ORDER BY `minOrder` ASC [ RunTime:0.000323s ]
select * from pdf where partno='1526889' and brandshort='phoenix contact' limit 1 [ RunTime:0.000861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526889' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.001569s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127859 LIMIT 5 [ RunTime:0.006801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127859 ORDER BY `minOrder` ASC [ RunTime:0.000833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127859 ORDER BY `unit` DESC [ RunTime:0.004112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127859 LIMIT 2 [ RunTime:0.000702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127859 ORDER BY `minOrder` ASC [ RunTime:0.000353s ]
select * from pdf where partno='15268' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.001046s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15268' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000747s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127859 AND `partno` = '15268' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.000595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126998 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126998 ORDER BY `minOrder` ASC [ RunTime:0.002439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126998 ORDER BY `unit` DESC [ RunTime:0.000853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126998 LIMIT 2 [ RunTime:0.000450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126998 ORDER BY `minOrder` ASC [ RunTime:0.000284s ]
select * from pdf where partno='15268F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15268F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.000803s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126998 AND `partno` = '15268F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.001167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127901 LIMIT 5 [ RunTime:0.000801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127901 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127901 ORDER BY `unit` DESC [ RunTime:0.000558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127901 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127901 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='15268B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.000542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15268B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.006689s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127901 AND `partno` = '15268B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.007471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64438437 LIMIT 5 [ RunTime:0.004264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438437 ORDER BY `minOrder` ASC [ RunTime:0.009333s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64438437 ORDER BY `unit` DESC [ RunTime:0.002499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64438437 LIMIT 2 [ RunTime:0.001533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64438437 ORDER BY `minOrder` ASC [ RunTime:0.005218s ]
select * from pdf where partno='1526859' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526859' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64248456 LIMIT 5 [ RunTime:0.000692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248456 ORDER BY `minOrder` ASC [ RunTime:0.003209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64248456 ORDER BY `unit` DESC [ RunTime:0.002152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64248456 LIMIT 2 [ RunTime:0.002754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64248456 ORDER BY `minOrder` ASC [ RunTime:0.001130s ]
select * from pdf where partno='152686' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '152686' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000822s ]
SELECT `id` FROM `stock` WHERE `id` <> 64248456 AND `partno` = '152686' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19264826 [ RunTime:0.004308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62192954 LIMIT 5 [ RunTime:0.005426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192954 ORDER BY `minOrder` ASC [ RunTime:0.005007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62192954 ORDER BY `unit` DESC [ RunTime:0.001561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62192954 LIMIT 2 [ RunTime:0.003011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62192954 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='1526892' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526892' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62189789 LIMIT 5 [ RunTime:0.004019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62189789 ORDER BY `minOrder` ASC [ RunTime:0.001142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62189789 ORDER BY `unit` DESC [ RunTime:0.001213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62189789 LIMIT 2 [ RunTime:0.004655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62189789 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='1526891' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526891' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62187759 LIMIT 5 [ RunTime:0.014506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62187759 ORDER BY `minOrder` ASC [ RunTime:0.003829s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62187759 ORDER BY `unit` DESC [ RunTime:0.001020s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62187759 LIMIT 2 [ RunTime:0.004079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62187759 ORDER BY `minOrder` ASC [ RunTime:0.003868s ]
select * from pdf where partno='1526889' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526889' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62186903 LIMIT 5 [ RunTime:0.007752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62186903 ORDER BY `minOrder` ASC [ RunTime:0.005868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62186903 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62186903 LIMIT 2 [ RunTime:0.000389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62186903 ORDER BY `minOrder` ASC [ RunTime:0.006396s ]
select * from pdf where partno='1526887' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526887' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.007313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62185926 LIMIT 5 [ RunTime:0.005378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62185926 ORDER BY `minOrder` ASC [ RunTime:0.011570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62185926 ORDER BY `unit` DESC [ RunTime:0.005803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62185926 LIMIT 2 [ RunTime:0.008197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62185926 ORDER BY `minOrder` ASC [ RunTime:0.004376s ]
select * from pdf where partno='1526875' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526875' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.004435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62183177 LIMIT 5 [ RunTime:0.002194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183177 ORDER BY `minOrder` ASC [ RunTime:0.000819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62183177 ORDER BY `unit` DESC [ RunTime:0.000489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62183177 LIMIT 2 [ RunTime:0.000319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183177 ORDER BY `minOrder` ASC [ RunTime:0.001392s ]
select * from pdf where partno='1526886' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006166s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526886' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62183176 LIMIT 5 [ RunTime:0.002978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183176 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62183176 ORDER BY `unit` DESC [ RunTime:0.000353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62183176 LIMIT 2 [ RunTime:0.000344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183176 ORDER BY `minOrder` ASC [ RunTime:0.005851s ]
select * from pdf where partno='1526879' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526879' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.008697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62183073 LIMIT 5 [ RunTime:0.014683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183073 ORDER BY `minOrder` ASC [ RunTime:0.012101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62183073 ORDER BY `unit` DESC [ RunTime:0.006925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62183073 LIMIT 2 [ RunTime:0.010340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62183073 ORDER BY `minOrder` ASC [ RunTime:0.003967s ]
select * from pdf where partno='1526874' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526874' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179796 LIMIT 5 [ RunTime:0.009892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179796 ORDER BY `minOrder` ASC [ RunTime:0.006537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179796 ORDER BY `unit` DESC [ RunTime:0.000816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179796 LIMIT 2 [ RunTime:0.008286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179796 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='1526885' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526885' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179795 LIMIT 5 [ RunTime:0.005796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179795 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179795 ORDER BY `unit` DESC [ RunTime:0.006263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179795 LIMIT 2 [ RunTime:0.003056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179795 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
select * from pdf where partno='1526878' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526878' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179121 LIMIT 5 [ RunTime:0.000711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179121 ORDER BY `minOrder` ASC [ RunTime:0.007703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179121 ORDER BY `unit` DESC [ RunTime:0.003409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179121 LIMIT 2 [ RunTime:0.006683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179121 ORDER BY `minOrder` ASC [ RunTime:0.000749s ]
select * from pdf where partno='1526869' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526869' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.003462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62179120 LIMIT 5 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179120 ORDER BY `minOrder` ASC [ RunTime:0.020036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62179120 ORDER BY `unit` DESC [ RunTime:0.000833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62179120 LIMIT 2 [ RunTime:0.002402s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62179120 ORDER BY `minOrder` ASC [ RunTime:0.002850s ]
select * from pdf where partno='1526864' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526864' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62178398 LIMIT 5 [ RunTime:0.002560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62178398 ORDER BY `minOrder` ASC [ RunTime:0.001979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62178398 ORDER BY `unit` DESC [ RunTime:0.002776s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62178398 LIMIT 2 [ RunTime:0.003233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62178398 ORDER BY `minOrder` ASC [ RunTime:0.001358s ]
select * from pdf where partno='1526873' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526873' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62177026 LIMIT 5 [ RunTime:0.002008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62177026 ORDER BY `minOrder` ASC [ RunTime:0.002685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62177026 ORDER BY `unit` DESC [ RunTime:0.001639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62177026 LIMIT 2 [ RunTime:0.001938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62177026 ORDER BY `minOrder` ASC [ RunTime:0.007275s ]
select * from pdf where partno='1526872' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.002500s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526872' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62172822 LIMIT 5 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62172822 ORDER BY `minOrder` ASC [ RunTime:0.008632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62172822 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62172822 LIMIT 2 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62172822 ORDER BY `minOrder` ASC [ RunTime:0.001808s ]
select * from pdf where partno='1526867' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1526867' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.006835s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004532s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002463s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001188s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003702s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004909s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001280s ]
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 '15268%' OR `brand` LIKE '15268%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001182s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '15268%' OR `brand` LIKE '15268%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002278s ]