SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001611s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.116' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=1418&search=1' [ RunTime:0.016339s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001501s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005392s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001287s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.116' ) [ RunTime:0.021752s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001371s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.040225s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001855s ]
SELECT * FROM `stock_search` WHERE `partno` = '1418' LIMIT 1 [ RunTime:0.066306s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-24 01:17:53' WHERE `partno` = '1418' [ RunTime:0.041390s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003932s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.141694s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.082639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609219 LIMIT 5 [ RunTime:0.027742s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609219 ORDER BY `minOrder` ASC [ RunTime:0.007824s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011368s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609219 ORDER BY `unit` DESC [ RunTime:0.015023s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609219 LIMIT 2 [ RunTime:0.005487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609219 ORDER BY `minOrder` ASC [ RunTime:0.009139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609058 LIMIT 5 [ RunTime:0.007210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609058 ORDER BY `minOrder` ASC [ RunTime:0.001541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609058 ORDER BY `unit` DESC [ RunTime:0.006866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609058 LIMIT 2 [ RunTime:0.000663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609058 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519058 LIMIT 5 [ RunTime:0.010599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519058 ORDER BY `minOrder` ASC [ RunTime:0.021314s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519058 ORDER BY `unit` DESC [ RunTime:0.001791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519058 LIMIT 2 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519058 ORDER BY `minOrder` ASC [ RunTime:0.003328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519030 LIMIT 5 [ RunTime:0.001601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519030 ORDER BY `minOrder` ASC [ RunTime:0.014663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12519030 ORDER BY `unit` DESC [ RunTime:0.017078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12519030 LIMIT 2 [ RunTime:0.019808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12519030 ORDER BY `minOrder` ASC [ RunTime:0.006503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596485 LIMIT 5 [ RunTime:0.008784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596485 ORDER BY `minOrder` ASC [ RunTime:0.022779s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19596485 ORDER BY `unit` DESC [ RunTime:0.034138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19596485 LIMIT 2 [ RunTime:0.009484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19596485 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609146 LIMIT 5 [ RunTime:0.001604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609146 ORDER BY `minOrder` ASC [ RunTime:0.002672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609146 ORDER BY `unit` DESC [ RunTime:0.008585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609146 LIMIT 2 [ RunTime:0.001541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609146 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609229 LIMIT 5 [ RunTime:0.001877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609229 ORDER BY `minOrder` ASC [ RunTime:0.009819s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609229 ORDER BY `unit` DESC [ RunTime:0.021013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609229 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609229 ORDER BY `minOrder` ASC [ RunTime:0.002247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11486671 LIMIT 5 [ RunTime:0.006718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486671 ORDER BY `minOrder` ASC [ RunTime:0.014801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11486671 ORDER BY `unit` DESC [ RunTime:0.007005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11486671 LIMIT 2 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11486671 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610559 LIMIT 5 [ RunTime:0.001804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610559 ORDER BY `minOrder` ASC [ RunTime:0.007488s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610559 ORDER BY `unit` DESC [ RunTime:0.003285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610559 LIMIT 2 [ RunTime:0.004934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610559 ORDER BY `minOrder` ASC [ RunTime:0.000444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628404 LIMIT 5 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628404 ORDER BY `minOrder` ASC [ RunTime:0.000634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12628404 ORDER BY `unit` DESC [ RunTime:0.011113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12628404 LIMIT 2 [ RunTime:0.006838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12628404 ORDER BY `minOrder` ASC [ RunTime:0.006106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610649 LIMIT 5 [ RunTime:0.004533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610649 ORDER BY `minOrder` ASC [ RunTime:0.016326s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610649 ORDER BY `unit` DESC [ RunTime:0.001303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610649 LIMIT 2 [ RunTime:0.001036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610649 ORDER BY `minOrder` ASC [ RunTime:0.000376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11413981 LIMIT 5 [ RunTime:0.004065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413981 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11413981 ORDER BY `unit` DESC [ RunTime:0.001556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11413981 LIMIT 2 [ RunTime:0.002457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11413981 ORDER BY `minOrder` ASC [ RunTime:0.003820s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609744 LIMIT 5 [ RunTime:0.002711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609744 ORDER BY `minOrder` ASC [ RunTime:0.005392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609744 ORDER BY `unit` DESC [ RunTime:0.003451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609744 LIMIT 2 [ RunTime:0.000951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609744 ORDER BY `minOrder` ASC [ RunTime:0.000907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481246 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481246 ORDER BY `minOrder` ASC [ RunTime:0.002345s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481246 ORDER BY `unit` DESC [ RunTime:0.001474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481246 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481246 ORDER BY `minOrder` ASC [ RunTime:0.004040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12612920 LIMIT 5 [ RunTime:0.001064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612920 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12612920 ORDER BY `unit` DESC [ RunTime:0.006872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12612920 LIMIT 2 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12612920 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12611673 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611673 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12611673 ORDER BY `unit` DESC [ RunTime:0.000968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12611673 LIMIT 2 [ RunTime:0.000973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12611673 ORDER BY `minOrder` ASC [ RunTime:0.002739s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482101 LIMIT 5 [ RunTime:0.008450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482101 ORDER BY `minOrder` ASC [ RunTime:0.003893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482101 ORDER BY `unit` DESC [ RunTime:0.003787s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482101 LIMIT 2 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482101 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418323 LIMIT 5 [ RunTime:0.001014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418323 ORDER BY `minOrder` ASC [ RunTime:0.000775s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11418323 ORDER BY `unit` DESC [ RunTime:0.000944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11418323 LIMIT 2 [ RunTime:0.003930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11418323 ORDER BY `minOrder` ASC [ RunTime:0.002198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20082011 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20082011 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20082011 ORDER BY `unit` DESC [ RunTime:0.000472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20082011 LIMIT 2 [ RunTime:0.009560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20082011 ORDER BY `minOrder` ASC [ RunTime:0.011103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18689810 LIMIT 5 [ RunTime:0.000989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689810 ORDER BY `minOrder` ASC [ RunTime:0.004762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18689810 ORDER BY `unit` DESC [ RunTime:0.001214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18689810 LIMIT 2 [ RunTime:0.003081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18689810 ORDER BY `minOrder` ASC [ RunTime:0.016175s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252378 LIMIT 5 [ RunTime:0.001756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252378 ORDER BY `minOrder` ASC [ RunTime:0.013295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252378 ORDER BY `unit` DESC [ RunTime:0.006049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252378 LIMIT 2 [ RunTime:0.015137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252378 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='1418784' and brandshort='phoenix contact' limit 1 [ RunTime:0.001422s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418784' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224358 LIMIT 5 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224358 ORDER BY `minOrder` ASC [ RunTime:0.000849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224358 ORDER BY `unit` DESC [ RunTime:0.001644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224358 LIMIT 2 [ RunTime:0.000463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224358 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
select * from pdf where partno='1418n4ssc6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ssc6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.014541s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224358 AND `partno` = '1418n4ssc6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037023 [ RunTime:0.003757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086560 LIMIT 5 [ RunTime:0.001232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086560 ORDER BY `minOrder` ASC [ RunTime:0.003211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086560 ORDER BY `unit` DESC [ RunTime:0.007237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086560 LIMIT 2 [ RunTime:0.012558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086560 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
select * from pdf where partno='1418052' and brandshort='phoenix contact' limit 1 [ RunTime:0.001489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418052' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.002109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224313 LIMIT 5 [ RunTime:0.000495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224313 ORDER BY `minOrder` ASC [ RunTime:0.000629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224313 ORDER BY `unit` DESC [ RunTime:0.002471s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224313 LIMIT 2 [ RunTime:0.012077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224313 ORDER BY `minOrder` ASC [ RunTime:0.005550s ]
select * from pdf where partno='1418n4ssb8' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001211s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ssb8' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.005336s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224313 AND `partno` = '1418n4ssb8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.014761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15275348 [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224357 LIMIT 5 [ RunTime:0.003413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224357 ORDER BY `minOrder` ASC [ RunTime:0.000927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224357 ORDER BY `unit` DESC [ RunTime:0.000754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224357 LIMIT 2 [ RunTime:0.004426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224357 ORDER BY `minOrder` ASC [ RunTime:0.006419s ]
select * from pdf where partno='1418n4ssb6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.004680s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ssb6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.013365s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224357 AND `partno` = '1418n4ssb6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203783 [ RunTime:0.017677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224355 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224355 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224355 ORDER BY `unit` DESC [ RunTime:0.007090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224355 LIMIT 2 [ RunTime:0.021036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224355 ORDER BY `minOrder` ASC [ RunTime:0.019815s ]
select * from pdf where partno='1418n4s16cr6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.016971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4s16cr6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.099221s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224355 AND `partno` = '1418n4s16cr6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.104849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029433 [ RunTime:0.045642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224354 LIMIT 5 [ RunTime:0.039261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224354 ORDER BY `minOrder` ASC [ RunTime:0.060873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224354 ORDER BY `unit` DESC [ RunTime:0.048318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224354 LIMIT 2 [ RunTime:0.079389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224354 ORDER BY `minOrder` ASC [ RunTime:0.002206s ]
select * from pdf where partno='1418n4s16b8' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.037926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4s16b8' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.044882s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224354 AND `partno` = '1418n4s16b8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.094920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276958 [ RunTime:0.048012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224359 LIMIT 5 [ RunTime:0.092334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224359 ORDER BY `minOrder` ASC [ RunTime:0.024395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224359 ORDER BY `unit` DESC [ RunTime:0.053960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224359 LIMIT 2 [ RunTime:0.023982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224359 ORDER BY `minOrder` ASC [ RunTime:0.039354s ]
select * from pdf where partno='1418n4sscr6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.094596s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4sscr6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.074348s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224359 AND `partno` = '1418n4sscr6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.023404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16016326 [ RunTime:0.062031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32218258 LIMIT 5 [ RunTime:0.017479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218258 ORDER BY `minOrder` ASC [ RunTime:0.014252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32218258 ORDER BY `unit` DESC [ RunTime:0.002768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32218258 LIMIT 2 [ RunTime:0.006164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32218258 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='1418bcs' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418bcs' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.003150s ]
SELECT `id` FROM `stock` WHERE `id` <> 32218258 AND `partno` = '1418bcs' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.016067s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14201179 [ RunTime:0.008389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224353 LIMIT 5 [ RunTime:0.002318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224353 ORDER BY `minOrder` ASC [ RunTime:0.003260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224353 ORDER BY `unit` DESC [ RunTime:0.010109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224353 LIMIT 2 [ RunTime:0.004744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224353 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
select * from pdf where partno='1418n4s16b6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.007918s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4s16b6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000725s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224353 AND `partno` = '1418n4s16b6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.010055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037015 [ RunTime:0.006017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224351 LIMIT 5 [ RunTime:0.010828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224351 ORDER BY `minOrder` ASC [ RunTime:0.002912s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224351 ORDER BY `unit` DESC [ RunTime:0.007737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224351 LIMIT 2 [ RunTime:0.003238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224351 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
select * from pdf where partno='1418jb7' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.005472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418jb7' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.001033s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224351 AND `partno` = '1418jb7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027820 [ RunTime:0.012934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224310 LIMIT 5 [ RunTime:0.004444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224310 ORDER BY `minOrder` ASC [ RunTime:0.000794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224310 ORDER BY `unit` DESC [ RunTime:0.000670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224310 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224310 ORDER BY `minOrder` ASC [ RunTime:0.001779s ]
select * from pdf where partno='1418jc7' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.003892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418jc7' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000848s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224310 AND `partno` = '1418jc7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17058698 [ RunTime:0.009769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224356 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224356 ORDER BY `minOrder` ASC [ RunTime:0.000885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224356 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224356 LIMIT 2 [ RunTime:0.002685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224356 ORDER BY `minOrder` ASC [ RunTime:0.006738s ]
select * from pdf where partno='1418n4s16g6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.004830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4s16g6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.001276s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224356 AND `partno` = '1418n4s16g6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029241 [ RunTime:0.004314s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224352 LIMIT 5 [ RunTime:0.000721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224352 ORDER BY `minOrder` ASC [ RunTime:0.000742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224352 ORDER BY `unit` DESC [ RunTime:0.011082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224352 LIMIT 2 [ RunTime:0.003754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224352 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='1418n4ale6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.004127s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ale6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.001275s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224352 AND `partno` = '1418n4ale6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001217s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15273908 [ RunTime:0.005146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224312 LIMIT 5 [ RunTime:0.007068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224312 ORDER BY `minOrder` ASC [ RunTime:0.003537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224312 ORDER BY `unit` DESC [ RunTime:0.002888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224312 LIMIT 2 [ RunTime:0.007541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224312 ORDER BY `minOrder` ASC [ RunTime:0.001328s ]
select * from pdf where partno='1418n4s16c6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.007709s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4s16c6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.009459s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224312 AND `partno` = '1418n4s16c6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.005149s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14205008 [ RunTime:0.010207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224311 LIMIT 5 [ RunTime:0.005071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224311 ORDER BY `minOrder` ASC [ RunTime:0.020096s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224311 ORDER BY `unit` DESC [ RunTime:0.012562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224311 LIMIT 2 [ RunTime:0.018636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224311 ORDER BY `minOrder` ASC [ RunTime:0.002242s ]
select * from pdf where partno='1418n4alc6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.004647s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4alc6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.016343s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224311 AND `partno` = '1418n4alc6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.005281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19023177 [ RunTime:0.004011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224360 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224360 ORDER BY `minOrder` ASC [ RunTime:0.000704s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224360 ORDER BY `unit` DESC [ RunTime:0.005478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224360 LIMIT 2 [ RunTime:0.001801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224360 ORDER BY `minOrder` ASC [ RunTime:0.003125s ]
select * from pdf where partno='1418n4ssg6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ssg6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.006298s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224360 AND `partno` = '1418n4ssg6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.030395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19029009 [ RunTime:0.027001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224261 LIMIT 5 [ RunTime:0.002814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224261 ORDER BY `minOrder` ASC [ RunTime:0.000989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224261 ORDER BY `unit` DESC [ RunTime:0.003686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224261 LIMIT 2 [ RunTime:0.016450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224261 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
select * from pdf where partno='1418n4alb6' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.007853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4alb6' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000888s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224261 AND `partno` = '1418n4alb6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.005215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15275477 [ RunTime:0.001150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32223810 LIMIT 5 [ RunTime:0.015631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223810 ORDER BY `minOrder` ASC [ RunTime:0.004548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32223810 ORDER BY `unit` DESC [ RunTime:0.001369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32223810 LIMIT 2 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32223810 ORDER BY `minOrder` ASC [ RunTime:0.000449s ]
select * from pdf where partno='1418n4ssc8' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418n4ssc8' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.003390s ]
SELECT `id` FROM `stock` WHERE `id` <> 32223810 AND `partno` = '1418n4ssc8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.004472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19037030 [ RunTime:0.007484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32224350 LIMIT 5 [ RunTime:0.001965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224350 ORDER BY `minOrder` ASC [ RunTime:0.001435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32224350 ORDER BY `unit` DESC [ RunTime:0.000751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32224350 LIMIT 2 [ RunTime:0.004932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32224350 ORDER BY `minOrder` ASC [ RunTime:0.006939s ]
select * from pdf where partno='1418ca8' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.003796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418ca8' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.000815s ]
SELECT `id` FROM `stock` WHERE `id` <> 32224350 AND `partno` = '1418ca8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.011122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16016317 [ RunTime:0.006112s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526552 LIMIT 5 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526552 ORDER BY `minOrder` ASC [ RunTime:0.001018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526552 ORDER BY `unit` DESC [ RunTime:0.001108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526552 LIMIT 2 [ RunTime:0.002378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526552 ORDER BY `minOrder` ASC [ RunTime:0.004557s ]
select * from pdf where partno='1418844-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008746s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418844-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.022581s ]
SELECT `id` FROM `stock` WHERE `id` <> 53526552 AND `partno` = '1418844-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609219 [ RunTime:0.005286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526368 LIMIT 5 [ RunTime:0.002907s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526368 ORDER BY `minOrder` ASC [ RunTime:0.008040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526368 ORDER BY `unit` DESC [ RunTime:0.001157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526368 LIMIT 2 [ RunTime:0.000780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526368 ORDER BY `minOrder` ASC [ RunTime:0.000342s ]
select * from pdf where partno='1418850-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004144s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418850-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003595s ]
SELECT `id` FROM `stock` WHERE `id` <> 53526368 AND `partno` = '1418850-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609744 [ RunTime:0.006294s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526559 LIMIT 5 [ RunTime:0.001850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526559 ORDER BY `minOrder` ASC [ RunTime:0.016544s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526559 ORDER BY `unit` DESC [ RunTime:0.000628s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526559 LIMIT 2 [ RunTime:0.002449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526559 ORDER BY `minOrder` ASC [ RunTime:0.005833s ]
select * from pdf where partno='1418850-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.002861s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418850-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000820s ]
SELECT `id` FROM `stock` WHERE `id` <> 53526559 AND `partno` = '1418850-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481246 [ RunTime:0.002770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817846 LIMIT 5 [ RunTime:0.006306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817846 ORDER BY `minOrder` ASC [ RunTime:0.005381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817846 ORDER BY `unit` DESC [ RunTime:0.004728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817846 LIMIT 2 [ RunTime:0.004651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817846 ORDER BY `minOrder` ASC [ RunTime:0.000359s ]
select * from pdf where partno='141879-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003402s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '141879-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002063s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817846 AND `partno` = '141879-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519058 [ RunTime:0.000727s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817805 LIMIT 5 [ RunTime:0.004439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817805 ORDER BY `minOrder` ASC [ RunTime:0.002784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817805 ORDER BY `unit` DESC [ RunTime:0.000289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817805 LIMIT 2 [ RunTime:0.000406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817805 ORDER BY `minOrder` ASC [ RunTime:0.000174s ]
select * from pdf where partno='141879-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '141879-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004501s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817805 AND `partno` = '141879-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.003396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12519030 [ RunTime:0.000535s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526432 LIMIT 5 [ RunTime:0.000379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526432 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526432 ORDER BY `unit` DESC [ RunTime:0.000314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526432 LIMIT 2 [ RunTime:0.003106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526432 ORDER BY `minOrder` ASC [ RunTime:0.003726s ]
select * from pdf where partno='1418762-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000637s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418762-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000431s ]
SELECT `id` FROM `stock` WHERE `id` <> 53526432 AND `partno` = '1418762-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609146 [ RunTime:0.002740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53495700 LIMIT 5 [ RunTime:0.002015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53495700 ORDER BY `minOrder` ASC [ RunTime:0.002988s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53495700 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53495700 LIMIT 2 [ RunTime:0.000249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53495700 ORDER BY `minOrder` ASC [ RunTime:0.000209s ]
select * from pdf where partno='1418' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000754s ]
SELECT `id` FROM `stock` WHERE `id` <> 53495700 AND `partno` = '1418' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002772s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596485 [ RunTime:0.001816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526598 LIMIT 5 [ RunTime:0.004032s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526598 ORDER BY `minOrder` ASC [ RunTime:0.001843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526598 ORDER BY `unit` DESC [ RunTime:0.000342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526598 LIMIT 2 [ RunTime:0.002462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526598 ORDER BY `minOrder` ASC [ RunTime:0.006928s ]
select * from pdf where partno='1418408-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418408-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002026s ]
SELECT `id` FROM `stock` WHERE `id` <> 53526598 AND `partno` = '1418408-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000493s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609229 [ RunTime:0.000349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53525484 LIMIT 5 [ RunTime:0.006859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525484 ORDER BY `minOrder` ASC [ RunTime:0.010392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53525484 ORDER BY `unit` DESC [ RunTime:0.003034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53525484 LIMIT 2 [ RunTime:0.003595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53525484 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
select * from pdf where partno='1418884-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418884-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53526217 LIMIT 5 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526217 ORDER BY `minOrder` ASC [ RunTime:0.000712s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53526217 ORDER BY `unit` DESC [ RunTime:0.009033s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53526217 LIMIT 2 [ RunTime:0.023417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53526217 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='1418844-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418844-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53078130 LIMIT 5 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53078130 ORDER BY `minOrder` ASC [ RunTime:0.003586s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53078130 ORDER BY `unit` DESC [ RunTime:0.000465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53078130 LIMIT 2 [ RunTime:0.001027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53078130 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='1418994-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418994-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000805s ]
SELECT `id` FROM `stock` WHERE `id` <> 53078130 AND `partno` = '1418994-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12628404 [ RunTime:0.001987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53532556 LIMIT 5 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53532556 ORDER BY `minOrder` ASC [ RunTime:0.001364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53532556 ORDER BY `unit` DESC [ RunTime:0.001578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53532556 LIMIT 2 [ RunTime:0.000538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53532556 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
select * from pdf where partno='1418786' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001108s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418786' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009480s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53529065 LIMIT 5 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529065 ORDER BY `minOrder` ASC [ RunTime:0.000899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53529065 ORDER BY `unit` DESC [ RunTime:0.000429s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53529065 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53529065 ORDER BY `minOrder` ASC [ RunTime:0.005457s ]
select * from pdf where partno='1418850-3' and brandshort='TE Connectivity' limit 1 [ RunTime:0.004477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418850-3' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.013381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52536558 LIMIT 5 [ RunTime:0.010324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52536558 ORDER BY `minOrder` ASC [ RunTime:0.001858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52536558 ORDER BY `unit` DESC [ RunTime:0.002517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52536558 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52536558 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='1418916-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.000836s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418916-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.002853s ]
SELECT `id` FROM `stock` WHERE `id` <> 52536558 AND `partno` = '1418916-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.000638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20082011 [ RunTime:0.000522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53528988 LIMIT 5 [ RunTime:0.001409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528988 ORDER BY `minOrder` ASC [ RunTime:0.001567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53528988 ORDER BY `unit` DESC [ RunTime:0.003140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53528988 LIMIT 2 [ RunTime:0.005524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53528988 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
select * from pdf where partno='1418578-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001050s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418578-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.003045s ]
SELECT `id` FROM `stock` WHERE `id` <> 53528988 AND `partno` = '1418578-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53817986 LIMIT 5 [ RunTime:0.010863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817986 ORDER BY `minOrder` ASC [ RunTime:0.005106s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53817986 ORDER BY `unit` DESC [ RunTime:0.001541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53817986 LIMIT 2 [ RunTime:0.014486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53817986 ORDER BY `minOrder` ASC [ RunTime:0.002619s ]
select * from pdf where partno='141878-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008373s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '141878-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000910s ]
SELECT `id` FROM `stock` WHERE `id` <> 53817986 AND `partno` = '141878-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11418323 [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53087758 LIMIT 5 [ RunTime:0.002579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087758 ORDER BY `minOrder` ASC [ RunTime:0.015288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53087758 ORDER BY `unit` DESC [ RunTime:0.009552s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53087758 LIMIT 2 [ RunTime:0.006992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53087758 ORDER BY `minOrder` ASC [ RunTime:0.010707s ]
select * from pdf where partno='1418789-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.001399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418789-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.011318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53546730 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53546730 ORDER BY `minOrder` ASC [ RunTime:0.001965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53546730 ORDER BY `unit` DESC [ RunTime:0.005843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53546730 LIMIT 2 [ RunTime:0.003233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53546730 ORDER BY `minOrder` ASC [ RunTime:0.003433s ]
select * from pdf where partno='1418882-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.006812s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1418882-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001900s ]
SELECT `id` FROM `stock` WHERE `id` <> 53546730 AND `partno` = '1418882-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50452538 LIMIT 5 [ RunTime:0.000454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452538 ORDER BY `minOrder` ASC [ RunTime:0.003395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50452538 ORDER BY `unit` DESC [ RunTime:0.007440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50452538 LIMIT 2 [ RunTime:0.002746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50452538 ORDER BY `minOrder` ASC [ RunTime:0.001213s ]
select * from pdf where partno='141815143000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001162s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '141815143000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004780s ]
SELECT `id` FROM `stock` WHERE `id` <> 50452538 AND `partno` = '141815143000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.009766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203497 [ RunTime:0.002811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37649899 LIMIT 5 [ RunTime:0.000485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649899 ORDER BY `minOrder` ASC [ RunTime:0.001077s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37649899 ORDER BY `unit` DESC [ RunTime:0.004377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37649899 LIMIT 2 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37649899 ORDER BY `minOrder` ASC [ RunTime:0.007691s ]
select * from pdf where partno='141815143000' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '141815143000' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.002463s ]
SELECT `id` FROM `stock` WHERE `id` <> 37649899 AND `partno` = '141815143000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15203497 [ RunTime:0.011414s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011207s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014603s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003472s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017419s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019242s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011145s ]
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 '1418%' OR `brand` LIKE '1418%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003936s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1418%' OR `brand` LIKE '1418%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013027s ]