SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002371s ]
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=1536&search=1' [ RunTime:0.004260s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002572s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.001325s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001482s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.007472s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002408s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010673s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001505s ]
SELECT * FROM `stock_search` WHERE `partno` = '1536' LIMIT 1 [ RunTime:0.013396s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-25 02:59:52' WHERE `partno` = '1536' [ RunTime:0.006599s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.006730s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042046s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422543 LIMIT 5 [ RunTime:0.034079s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422543 ORDER BY `minOrder` ASC [ RunTime:0.018188s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.011389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422543 ORDER BY `unit` DESC [ RunTime:0.011823s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422543 LIMIT 2 [ RunTime:0.024339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422543 ORDER BY `minOrder` ASC [ RunTime:0.010346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422540 LIMIT 5 [ RunTime:0.022036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422540 ORDER BY `minOrder` ASC [ RunTime:0.024148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16422540 ORDER BY `unit` DESC [ RunTime:0.026961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16422540 LIMIT 2 [ RunTime:0.038562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16422540 ORDER BY `minOrder` ASC [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538086 LIMIT 5 [ RunTime:0.014666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538086 ORDER BY `minOrder` ASC [ RunTime:0.014689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538086 ORDER BY `unit` DESC [ RunTime:0.013055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538086 LIMIT 2 [ RunTime:0.029393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538086 ORDER BY `minOrder` ASC [ RunTime:0.038387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538085 LIMIT 5 [ RunTime:0.021436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538085 ORDER BY `minOrder` ASC [ RunTime:0.022757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538085 ORDER BY `unit` DESC [ RunTime:0.014387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538085 LIMIT 2 [ RunTime:0.048775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538085 ORDER BY `minOrder` ASC [ RunTime:0.009026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538081 LIMIT 5 [ RunTime:0.023821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538081 ORDER BY `minOrder` ASC [ RunTime:0.033597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538081 ORDER BY `unit` DESC [ RunTime:0.076474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538081 LIMIT 2 [ RunTime:0.039442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538081 ORDER BY `minOrder` ASC [ RunTime:0.015960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538076 LIMIT 5 [ RunTime:0.019786s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538076 ORDER BY `minOrder` ASC [ RunTime:0.023319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13538076 ORDER BY `unit` DESC [ RunTime:0.047195s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13538076 LIMIT 2 [ RunTime:0.027315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13538076 ORDER BY `minOrder` ASC [ RunTime:0.009305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13403046 LIMIT 5 [ RunTime:0.022644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403046 ORDER BY `minOrder` ASC [ RunTime:0.009420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13403046 ORDER BY `unit` DESC [ RunTime:0.017556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13403046 LIMIT 2 [ RunTime:0.028692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13403046 ORDER BY `minOrder` ASC [ RunTime:0.020829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13401197 LIMIT 5 [ RunTime:0.036508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401197 ORDER BY `minOrder` ASC [ RunTime:0.064153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13401197 ORDER BY `unit` DESC [ RunTime:0.002463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13401197 LIMIT 2 [ RunTime:0.015272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13401197 ORDER BY `minOrder` ASC [ RunTime:0.036349s ]
select * from pdf where partno='1536W' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.016119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16470459 LIMIT 5 [ RunTime:0.012375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16470459 ORDER BY `minOrder` ASC [ RunTime:0.003047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16470459 ORDER BY `unit` DESC [ RunTime:0.022759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16470459 LIMIT 2 [ RunTime:0.006969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16470459 ORDER BY `minOrder` ASC [ RunTime:0.006597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13422918 LIMIT 5 [ RunTime:0.022761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422918 ORDER BY `minOrder` ASC [ RunTime:0.009928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13422918 ORDER BY `unit` DESC [ RunTime:0.014374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13422918 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422918 ORDER BY `minOrder` ASC [ RunTime:0.009756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14314657 LIMIT 5 [ RunTime:0.003116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14314657 ORDER BY `minOrder` ASC [ RunTime:0.006675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14314657 ORDER BY `unit` DESC [ RunTime:0.007810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14314657 LIMIT 2 [ RunTime:0.019674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14314657 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14314589 LIMIT 5 [ RunTime:0.003271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14314589 ORDER BY `minOrder` ASC [ RunTime:0.005468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14314589 ORDER BY `unit` DESC [ RunTime:0.003578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14314589 LIMIT 2 [ RunTime:0.003154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14314589 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13422892 LIMIT 5 [ RunTime:0.005994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422892 ORDER BY `minOrder` ASC [ RunTime:0.003509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13422892 ORDER BY `unit` DESC [ RunTime:0.001062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13422892 LIMIT 2 [ RunTime:0.000796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13422892 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317416 LIMIT 5 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317416 ORDER BY `minOrder` ASC [ RunTime:0.000631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317416 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317416 LIMIT 2 [ RunTime:0.001132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317416 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='1536T' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317467 LIMIT 5 [ RunTime:0.007337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317467 ORDER BY `minOrder` ASC [ RunTime:0.008181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317467 ORDER BY `unit` DESC [ RunTime:0.001891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317467 LIMIT 2 [ RunTime:0.002952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317467 ORDER BY `minOrder` ASC [ RunTime:0.001665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317420 LIMIT 5 [ RunTime:0.000531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317420 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14317420 ORDER BY `unit` DESC [ RunTime:0.002800s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14317420 LIMIT 2 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14317420 ORDER BY `minOrder` ASC [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426683 LIMIT 5 [ RunTime:0.000831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426683 ORDER BY `minOrder` ASC [ RunTime:0.002158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13426683 ORDER BY `unit` DESC [ RunTime:0.003465s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13426683 LIMIT 2 [ RunTime:0.003688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426683 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426661 LIMIT 5 [ RunTime:0.002165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426661 ORDER BY `minOrder` ASC [ RunTime:0.002530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13426661 ORDER BY `unit` DESC [ RunTime:0.000589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13426661 LIMIT 2 [ RunTime:0.004304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13426661 ORDER BY `minOrder` ASC [ RunTime:0.005906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509107 LIMIT 5 [ RunTime:0.000893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509107 ORDER BY `minOrder` ASC [ RunTime:0.003969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17509107 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17509107 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17509107 ORDER BY `minOrder` ASC [ RunTime:0.000365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508733 LIMIT 5 [ RunTime:0.000929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508733 ORDER BY `minOrder` ASC [ RunTime:0.007396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17508733 ORDER BY `unit` DESC [ RunTime:0.005711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17508733 LIMIT 2 [ RunTime:0.005445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17508733 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32284677 LIMIT 5 [ RunTime:0.001572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284677 ORDER BY `minOrder` ASC [ RunTime:0.009649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32284677 ORDER BY `unit` DESC [ RunTime:0.011469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32284677 LIMIT 2 [ RunTime:0.004440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32284677 ORDER BY `minOrder` ASC [ RunTime:0.002736s ]
select * from pdf where partno='1536' and brandshort='keystone electronics' limit 1 [ RunTime:0.007048s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001418s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536' OR `brand` LIKE 'keystone electronics%' ) ) LIMIT 1 [ RunTime:0.006168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132523 LIMIT 5 [ RunTime:0.020682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132523 ORDER BY `minOrder` ASC [ RunTime:0.003179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132523 ORDER BY `unit` DESC [ RunTime:0.005759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132523 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132523 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='15366-0131' and brandshort='molex' limit 1 [ RunTime:0.001544s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0131' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.017770s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131796 LIMIT 5 [ RunTime:0.007609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131796 ORDER BY `minOrder` ASC [ RunTime:0.026852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131796 ORDER BY `unit` DESC [ RunTime:0.002983s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131796 LIMIT 2 [ RunTime:0.003925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131796 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
select * from pdf where partno='15366-0123' and brandshort='molex' limit 1 [ RunTime:0.005222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0123' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027909s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132293 LIMIT 5 [ RunTime:0.008350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132293 ORDER BY `minOrder` ASC [ RunTime:0.012713s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132293 ORDER BY `unit` DESC [ RunTime:0.003710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132293 LIMIT 2 [ RunTime:0.011711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132293 ORDER BY `minOrder` ASC [ RunTime:0.011918s ]
select * from pdf where partno='15366-0145' and brandshort='molex' limit 1 [ RunTime:0.000921s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0145' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32253841 LIMIT 5 [ RunTime:0.023875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253841 ORDER BY `minOrder` ASC [ RunTime:0.010612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32253841 ORDER BY `unit` DESC [ RunTime:0.010887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32253841 LIMIT 2 [ RunTime:0.003997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32253841 ORDER BY `minOrder` ASC [ RunTime:0.007291s ]
select * from pdf where partno='15366-0435' and brandshort='molex' limit 1 [ RunTime:0.012130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0435' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132524 LIMIT 5 [ RunTime:0.009881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132524 ORDER BY `minOrder` ASC [ RunTime:0.007894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132524 ORDER BY `unit` DESC [ RunTime:0.003667s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132524 LIMIT 2 [ RunTime:0.000532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132524 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
select * from pdf where partno='15366-0149' and brandshort='molex' limit 1 [ RunTime:0.001088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0149' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.008940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132380 LIMIT 5 [ RunTime:0.002246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132380 ORDER BY `minOrder` ASC [ RunTime:0.019210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132380 ORDER BY `unit` DESC [ RunTime:0.006502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132380 LIMIT 2 [ RunTime:0.010796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132380 ORDER BY `minOrder` ASC [ RunTime:0.002178s ]
select * from pdf where partno='15366-0175' and brandshort='molex' limit 1 [ RunTime:0.027531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0175' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.036766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131797 LIMIT 5 [ RunTime:0.017007s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131797 ORDER BY `minOrder` ASC [ RunTime:0.003347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131797 ORDER BY `unit` DESC [ RunTime:0.004107s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131797 LIMIT 2 [ RunTime:0.009079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131797 ORDER BY `minOrder` ASC [ RunTime:0.021180s ]
select * from pdf where partno='15366-0435' and brandshort='molex' limit 1 [ RunTime:0.003065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0435' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.003035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132379 LIMIT 5 [ RunTime:0.048309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132379 ORDER BY `minOrder` ASC [ RunTime:0.032073s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132379 ORDER BY `unit` DESC [ RunTime:0.021999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132379 LIMIT 2 [ RunTime:0.016459s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132379 ORDER BY `minOrder` ASC [ RunTime:0.009834s ]
select * from pdf where partno='15366-0153' and brandshort='molex' limit 1 [ RunTime:0.008832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0153' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132582 LIMIT 5 [ RunTime:0.038419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132582 ORDER BY `minOrder` ASC [ RunTime:0.015911s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132582 ORDER BY `unit` DESC [ RunTime:0.065308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132582 LIMIT 2 [ RunTime:0.002551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132582 ORDER BY `minOrder` ASC [ RunTime:0.009825s ]
select * from pdf where partno='15366-0171' and brandshort='molex' limit 1 [ RunTime:0.011669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0171' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.019673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132188 LIMIT 5 [ RunTime:0.014605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132188 ORDER BY `minOrder` ASC [ RunTime:0.022280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132188 ORDER BY `unit` DESC [ RunTime:0.012139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132188 LIMIT 2 [ RunTime:0.032226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132188 ORDER BY `minOrder` ASC [ RunTime:0.008713s ]
select * from pdf where partno='15366-0325' and brandshort='molex' limit 1 [ RunTime:0.010749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0325' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027506s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132581 LIMIT 5 [ RunTime:0.013643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132581 ORDER BY `minOrder` ASC [ RunTime:0.013511s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132581 ORDER BY `unit` DESC [ RunTime:0.007703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132581 LIMIT 2 [ RunTime:0.026788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132581 ORDER BY `minOrder` ASC [ RunTime:0.019574s ]
select * from pdf where partno='15366-0141' and brandshort='molex' limit 1 [ RunTime:0.017750s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0141' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.030371s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132187 LIMIT 5 [ RunTime:0.008210s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132187 ORDER BY `minOrder` ASC [ RunTime:0.029661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132187 ORDER BY `unit` DESC [ RunTime:0.023424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132187 LIMIT 2 [ RunTime:0.029987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132187 ORDER BY `minOrder` ASC [ RunTime:0.008916s ]
select * from pdf where partno='15366-0105' and brandshort='molex' limit 1 [ RunTime:0.017541s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0105' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.039417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132522 LIMIT 5 [ RunTime:0.006098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132522 ORDER BY `minOrder` ASC [ RunTime:0.023582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132522 ORDER BY `unit` DESC [ RunTime:0.017175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132522 LIMIT 2 [ RunTime:0.034055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132522 ORDER BY `minOrder` ASC [ RunTime:0.000398s ]
select * from pdf where partno='15366-0087' and brandshort='molex' limit 1 [ RunTime:0.002802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0087' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.032475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132043 LIMIT 5 [ RunTime:0.018965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132043 ORDER BY `minOrder` ASC [ RunTime:0.031087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132043 ORDER BY `unit` DESC [ RunTime:0.034482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132043 LIMIT 2 [ RunTime:0.031471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132043 ORDER BY `minOrder` ASC [ RunTime:0.015734s ]
select * from pdf where partno='15366-0057' and brandshort='molex' limit 1 [ RunTime:0.025334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0057' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254501 LIMIT 5 [ RunTime:0.040487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254501 ORDER BY `minOrder` ASC [ RunTime:0.031217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254501 ORDER BY `unit` DESC [ RunTime:0.004101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254501 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254501 ORDER BY `minOrder` ASC [ RunTime:0.006394s ]
select * from pdf where partno='15366-0057' and brandshort='molex' limit 1 [ RunTime:0.006972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0057' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.005570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131990 LIMIT 5 [ RunTime:0.015544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131990 ORDER BY `minOrder` ASC [ RunTime:0.003519s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131990 ORDER BY `unit` DESC [ RunTime:0.033235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131990 LIMIT 2 [ RunTime:0.013399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131990 ORDER BY `minOrder` ASC [ RunTime:0.017401s ]
select * from pdf where partno='15366-0329' and brandshort='molex' limit 1 [ RunTime:0.016551s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0329' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132580 LIMIT 5 [ RunTime:0.009648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132580 ORDER BY `minOrder` ASC [ RunTime:0.015152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132580 ORDER BY `unit` DESC [ RunTime:0.005918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132580 LIMIT 2 [ RunTime:0.027590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132580 ORDER BY `minOrder` ASC [ RunTime:0.037318s ]
select * from pdf where partno='15366-0065' and brandshort='molex' limit 1 [ RunTime:0.004091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0065' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.040216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132521 LIMIT 5 [ RunTime:0.022833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132521 ORDER BY `minOrder` ASC [ RunTime:0.018277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132521 ORDER BY `unit` DESC [ RunTime:0.016064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132521 LIMIT 2 [ RunTime:0.066818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132521 ORDER BY `minOrder` ASC [ RunTime:0.007364s ]
select * from pdf where partno='15366-0083' and brandshort='molex' limit 1 [ RunTime:0.011071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0083' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.052387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51132292 LIMIT 5 [ RunTime:0.017344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132292 ORDER BY `minOrder` ASC [ RunTime:0.060247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51132292 ORDER BY `unit` DESC [ RunTime:0.029448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51132292 LIMIT 2 [ RunTime:0.028185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51132292 ORDER BY `minOrder` ASC [ RunTime:0.008120s ]
select * from pdf where partno='15366-0109' and brandshort='molex' limit 1 [ RunTime:0.031915s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15366-0109' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.025943s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62248254 LIMIT 5 [ RunTime:0.021825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62248254 ORDER BY `minOrder` ASC [ RunTime:0.037079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62248254 ORDER BY `unit` DESC [ RunTime:0.046550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62248254 LIMIT 2 [ RunTime:0.037133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62248254 ORDER BY `minOrder` ASC [ RunTime:0.016342s ]
select * from pdf where partno='15364' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.045377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15364' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.044542s ]
SELECT `id` FROM `stock` WHERE `id` <> 62248254 AND `partno` = '15364' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.036856s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16470459 [ RunTime:0.072123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126893 LIMIT 5 [ RunTime:0.037077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126893 ORDER BY `minOrder` ASC [ RunTime:0.024527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126893 ORDER BY `unit` DESC [ RunTime:0.031494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126893 LIMIT 2 [ RunTime:0.062569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126893 ORDER BY `minOrder` ASC [ RunTime:0.017768s ]
select * from pdf where partno='15364F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.043220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15364F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.044288s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126893 AND `partno` = '15364F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.025317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538086 [ RunTime:0.015231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126887 LIMIT 5 [ RunTime:0.060461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126887 ORDER BY `minOrder` ASC [ RunTime:0.023454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126887 ORDER BY `unit` DESC [ RunTime:0.042771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126887 LIMIT 2 [ RunTime:0.062304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126887 ORDER BY `minOrder` ASC [ RunTime:0.004237s ]
select * from pdf where partno='15360F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.004925s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15360F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.074307s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126887 AND `partno` = '15360F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.005323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538085 [ RunTime:0.033569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126802 LIMIT 5 [ RunTime:0.023913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126802 ORDER BY `minOrder` ASC [ RunTime:0.032971s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126802 ORDER BY `unit` DESC [ RunTime:0.026688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126802 LIMIT 2 [ RunTime:0.027188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126802 ORDER BY `minOrder` ASC [ RunTime:0.020606s ]
select * from pdf where partno='15364' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.025062s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15364' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.030469s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126802 AND `partno` = '15364' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.043212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422540 [ RunTime:0.051292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126800 LIMIT 5 [ RunTime:0.015552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126800 ORDER BY `minOrder` ASC [ RunTime:0.067426s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126800 ORDER BY `unit` DESC [ RunTime:0.086181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126800 LIMIT 2 [ RunTime:0.033978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126800 ORDER BY `minOrder` ASC [ RunTime:0.007943s ]
select * from pdf where partno='15360' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.007374s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15360' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.044348s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126800 AND `partno` = '15360' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.017800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538076 [ RunTime:0.039962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126862 LIMIT 5 [ RunTime:0.016502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126862 ORDER BY `minOrder` ASC [ RunTime:0.046313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126862 ORDER BY `unit` DESC [ RunTime:0.033083s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126862 LIMIT 2 [ RunTime:0.034445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126862 ORDER BY `minOrder` ASC [ RunTime:0.012014s ]
select * from pdf where partno='15364B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.028467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15364B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.010540s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126862 AND `partno` = '15364B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.024995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16422543 [ RunTime:0.051654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63126850 LIMIT 5 [ RunTime:0.020717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126850 ORDER BY `minOrder` ASC [ RunTime:0.023287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63126850 ORDER BY `unit` DESC [ RunTime:0.056754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63126850 LIMIT 2 [ RunTime:0.031134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63126850 ORDER BY `minOrder` ASC [ RunTime:0.024175s ]
select * from pdf where partno='15360B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.017907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15360B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.013359s ]
SELECT `id` FROM `stock` WHERE `id` <> 63126850 AND `partno` = '15360B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.052484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13538081 [ RunTime:0.024075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127839 LIMIT 5 [ RunTime:0.009136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127839 ORDER BY `minOrder` ASC [ RunTime:0.030982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127839 ORDER BY `unit` DESC [ RunTime:0.014891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127839 LIMIT 2 [ RunTime:0.017645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127839 ORDER BY `minOrder` ASC [ RunTime:0.013477s ]
select * from pdf where partno='15368F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.016230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15368F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.020676s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127839 AND `partno` = '15368F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.022190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127799 LIMIT 5 [ RunTime:0.047776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127799 ORDER BY `minOrder` ASC [ RunTime:0.018390s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127799 ORDER BY `unit` DESC [ RunTime:0.044624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127799 LIMIT 2 [ RunTime:0.009790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127799 ORDER BY `minOrder` ASC [ RunTime:0.015740s ]
select * from pdf where partno='15368B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.016081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15368B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.015702s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127799 AND `partno` = '15368B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.017998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63127749 LIMIT 5 [ RunTime:0.013941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127749 ORDER BY `minOrder` ASC [ RunTime:0.013133s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63127749 ORDER BY `unit` DESC [ RunTime:0.010837s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63127749 LIMIT 2 [ RunTime:0.007170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63127749 ORDER BY `minOrder` ASC [ RunTime:0.006153s ]
select * from pdf where partno='15368' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.007405s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15368' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.012121s ]
SELECT `id` FROM `stock` WHERE `id` <> 63127749 AND `partno` = '15368' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.033196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40469118 LIMIT 5 [ RunTime:0.031078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40469118 ORDER BY `minOrder` ASC [ RunTime:0.025413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40469118 ORDER BY `unit` DESC [ RunTime:0.010809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40469118 LIMIT 2 [ RunTime:0.030612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40469118 ORDER BY `minOrder` ASC [ RunTime:0.003926s ]
select * from pdf where partno='1536X' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.028143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536X' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.043814s ]
SELECT `id` FROM `stock` WHERE `id` <> 40469118 AND `partno` = '1536X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.021402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13403046 [ RunTime:0.031620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60652742 LIMIT 5 [ RunTime:0.035203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60652742 ORDER BY `minOrder` ASC [ RunTime:0.031482s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60652742 ORDER BY `unit` DESC [ RunTime:0.010541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60652742 LIMIT 2 [ RunTime:0.013577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60652742 ORDER BY `minOrder` ASC [ RunTime:0.012831s ]
select * from pdf where partno='1536' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.020768s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.036404s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40492520 LIMIT 5 [ RunTime:0.037291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40492520 ORDER BY `minOrder` ASC [ RunTime:0.022219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40492520 ORDER BY `unit` DESC [ RunTime:0.009388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40492520 LIMIT 2 [ RunTime:0.005762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40492520 ORDER BY `minOrder` ASC [ RunTime:0.006505s ]
select * from pdf where partno='1536T' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.007350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536T' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.012145s ]
SELECT `id` FROM `stock` WHERE `id` <> 40492520 AND `partno` = '1536T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.032237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14317416 [ RunTime:0.009907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40492578 LIMIT 5 [ RunTime:0.030642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40492578 ORDER BY `minOrder` ASC [ RunTime:0.017789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40492578 ORDER BY `unit` DESC [ RunTime:0.013784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40492578 LIMIT 2 [ RunTime:0.019125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40492578 ORDER BY `minOrder` ASC [ RunTime:0.004440s ]
select * from pdf where partno='1536E' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.005703s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536E' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.007420s ]
SELECT `id` FROM `stock` WHERE `id` <> 40492578 AND `partno` = '1536E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.018943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14314657 [ RunTime:0.008019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40499274 LIMIT 5 [ RunTime:0.015281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499274 ORDER BY `minOrder` ASC [ RunTime:0.024278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40499274 ORDER BY `unit` DESC [ RunTime:0.012389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40499274 LIMIT 2 [ RunTime:0.016136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499274 ORDER BY `minOrder` ASC [ RunTime:0.002478s ]
select * from pdf where partno='1536L' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.022561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536L' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.006599s ]
SELECT `id` FROM `stock` WHERE `id` <> 40499274 AND `partno` = '1536L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.067699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14314589 [ RunTime:0.027086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40499393 LIMIT 5 [ RunTime:0.013862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499393 ORDER BY `minOrder` ASC [ RunTime:0.031530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40499393 ORDER BY `unit` DESC [ RunTime:0.025940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40499393 LIMIT 2 [ RunTime:0.020441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499393 ORDER BY `minOrder` ASC [ RunTime:0.006516s ]
select * from pdf where partno='1536F' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.018624s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536F' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.025531s ]
SELECT `id` FROM `stock` WHERE `id` <> 40499393 AND `partno` = '1536F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.013256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426683 [ RunTime:0.027918s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40499275 LIMIT 5 [ RunTime:0.020362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499275 ORDER BY `minOrder` ASC [ RunTime:0.039891s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40499275 ORDER BY `unit` DESC [ RunTime:0.010198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40499275 LIMIT 2 [ RunTime:0.020906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40499275 ORDER BY `minOrder` ASC [ RunTime:0.012686s ]
select * from pdf where partno='1536S' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.035056s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1536S' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.026838s ]
SELECT `id` FROM `stock` WHERE `id` <> 40499275 AND `partno` = '1536S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.025389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13426661 [ RunTime:0.007471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63376571 LIMIT 5 [ RunTime:0.020939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376571 ORDER BY `minOrder` ASC [ RunTime:0.013362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63376571 ORDER BY `unit` DESC [ RunTime:0.003652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63376571 LIMIT 2 [ RunTime:0.013634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376571 ORDER BY `minOrder` ASC [ RunTime:0.016022s ]
select * from pdf where partno='153668' and brandshort='Brady Corporation' limit 1 [ RunTime:0.035230s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153668' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.042354s ]
SELECT `id` FROM `stock` WHERE `id` <> 63376571 AND `partno` = '153668' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.056421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17509107 [ RunTime:0.022630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63376475 LIMIT 5 [ RunTime:0.031452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376475 ORDER BY `minOrder` ASC [ RunTime:0.047888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63376475 ORDER BY `unit` DESC [ RunTime:0.041058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63376475 LIMIT 2 [ RunTime:0.021830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376475 ORDER BY `minOrder` ASC [ RunTime:0.009122s ]
select * from pdf where partno='153672' and brandshort='Brady Corporation' limit 1 [ RunTime:0.028146s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153672' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.016085s ]
SELECT `id` FROM `stock` WHERE `id` <> 63376475 AND `partno` = '153672' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.037389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508733 [ RunTime:0.030200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63376470 LIMIT 5 [ RunTime:0.044978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376470 ORDER BY `minOrder` ASC [ RunTime:0.022183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63376470 ORDER BY `unit` DESC [ RunTime:0.014938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63376470 LIMIT 2 [ RunTime:0.015005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63376470 ORDER BY `minOrder` ASC [ RunTime:0.018076s ]
select * from pdf where partno='153680' and brandshort='Brady Corporation' limit 1 [ RunTime:0.033001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '153680' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.039360s ]
SELECT `id` FROM `stock` WHERE `id` <> 63376470 AND `partno` = '153680' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.032788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17508731 [ RunTime:0.015784s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053252s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013162s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036190s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062488s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047157s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019041s ]
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 '1536%' OR `brand` LIKE '1536%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036743s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '1536%' OR `brand` LIKE '1536%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.066073s ]