SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002339s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.153' , `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=pj12106&search=1' [ RunTime:0.002019s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001964s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002548s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.153' ) [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001795s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000288s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001976s ]
SELECT * FROM `stock_search` WHERE `partno` = 'pj12106' LIMIT 1 [ RunTime:0.008118s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-16 16:08:20' WHERE `partno` = 'pj12106' [ RunTime:0.019349s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001413s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003851s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060501 LIMIT 5 [ RunTime:0.000637s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060501 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060501 ORDER BY `unit` DESC [ RunTime:0.014510s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060501 LIMIT 2 [ RunTime:0.004924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060501 ORDER BY `minOrder` ASC [ RunTime:0.015627s ]
select * from pdf where partno='PJ12106H' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.009437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034151 LIMIT 5 [ RunTime:0.002443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034151 ORDER BY `minOrder` ASC [ RunTime:0.012611s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19034151 ORDER BY `unit` DESC [ RunTime:0.007418s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19034151 LIMIT 2 [ RunTime:0.002572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19034151 ORDER BY `minOrder` ASC [ RunTime:0.000655s ]
select * from pdf where partno='PJ12106' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276916 LIMIT 5 [ RunTime:0.002347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276916 ORDER BY `minOrder` ASC [ RunTime:0.001676s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15276916 ORDER BY `unit` DESC [ RunTime:0.009476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15276916 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15276916 ORDER BY `minOrder` ASC [ RunTime:0.000999s ]
select * from pdf where partno='PJ12106L' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.008960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036883 LIMIT 5 [ RunTime:0.007861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036883 ORDER BY `minOrder` ASC [ RunTime:0.005841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19036883 ORDER BY `unit` DESC [ RunTime:0.004319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19036883 LIMIT 2 [ RunTime:0.013896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19036883 ORDER BY `minOrder` ASC [ RunTime:0.004080s ]
select * from pdf where partno='PJ12106T' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060499 LIMIT 5 [ RunTime:0.000816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060499 ORDER BY `minOrder` ASC [ RunTime:0.005664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17060499 ORDER BY `unit` DESC [ RunTime:0.004357s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17060499 LIMIT 2 [ RunTime:0.014165s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17060499 ORDER BY `minOrder` ASC [ RunTime:0.002295s ]
select * from pdf where partno='PJ12106R' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027296 LIMIT 5 [ RunTime:0.001358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027296 ORDER BY `minOrder` ASC [ RunTime:0.015152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027296 ORDER BY `unit` DESC [ RunTime:0.006759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027296 LIMIT 2 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027296 ORDER BY `minOrder` ASC [ RunTime:0.000331s ]
select * from pdf where partno='PJ12106RLW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027261 LIMIT 5 [ RunTime:0.003256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027261 ORDER BY `minOrder` ASC [ RunTime:0.000412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027261 ORDER BY `unit` DESC [ RunTime:0.006098s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027261 LIMIT 2 [ RunTime:0.000329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027261 ORDER BY `minOrder` ASC [ RunTime:0.001304s ]
select * from pdf where partno='PJ12106TW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000928s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027260 LIMIT 5 [ RunTime:0.003274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027260 ORDER BY `minOrder` ASC [ RunTime:0.003541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027260 ORDER BY `unit` DESC [ RunTime:0.004251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027260 LIMIT 2 [ RunTime:0.002176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027260 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='PJ12106LW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027166 LIMIT 5 [ RunTime:0.000769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027166 ORDER BY `minOrder` ASC [ RunTime:0.000543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027166 ORDER BY `unit` DESC [ RunTime:0.000502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027166 LIMIT 2 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027166 ORDER BY `minOrder` ASC [ RunTime:0.002351s ]
select * from pdf where partno='PJ12106HW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027114 LIMIT 5 [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027114 ORDER BY `minOrder` ASC [ RunTime:0.000613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19027114 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19027114 LIMIT 2 [ RunTime:0.000486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19027114 ORDER BY `minOrder` ASC [ RunTime:0.002201s ]
select * from pdf where partno='PJ12106W' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026749 LIMIT 5 [ RunTime:0.000839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026749 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026749 ORDER BY `unit` DESC [ RunTime:0.000520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026749 LIMIT 2 [ RunTime:0.000487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026749 ORDER BY `minOrder` ASC [ RunTime:0.006270s ]
select * from pdf where partno='PJ12106HP20' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026609 LIMIT 5 [ RunTime:0.002529s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026609 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026609 ORDER BY `unit` DESC [ RunTime:0.001526s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026609 LIMIT 2 [ RunTime:0.000421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026609 ORDER BY `minOrder` ASC [ RunTime:0.001690s ]
select * from pdf where partno='PJ12106P16' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026554 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026554 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026554 ORDER BY `unit` DESC [ RunTime:0.002096s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026554 LIMIT 2 [ RunTime:0.000413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026554 ORDER BY `minOrder` ASC [ RunTime:0.001458s ]
select * from pdf where partno='PJ12106RT' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026553 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026553 ORDER BY `minOrder` ASC [ RunTime:0.006602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026553 ORDER BY `unit` DESC [ RunTime:0.003278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026553 LIMIT 2 [ RunTime:0.004117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026553 ORDER BY `minOrder` ASC [ RunTime:0.002056s ]
select * from pdf where partno='PJ12106RL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026374 LIMIT 5 [ RunTime:0.001115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026374 ORDER BY `minOrder` ASC [ RunTime:0.001165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19026374 ORDER BY `unit` DESC [ RunTime:0.003438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19026374 LIMIT 2 [ RunTime:0.003635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19026374 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='PJ12106RH' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274785 LIMIT 5 [ RunTime:0.002680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274785 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274785 ORDER BY `unit` DESC [ RunTime:0.003239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274785 LIMIT 2 [ RunTime:0.004347s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274785 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
select * from pdf where partno='PJ12106RTW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274747 LIMIT 5 [ RunTime:0.003136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274747 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274747 ORDER BY `unit` DESC [ RunTime:0.003287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274747 LIMIT 2 [ RunTime:0.006885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274747 ORDER BY `minOrder` ASC [ RunTime:0.000462s ]
select * from pdf where partno='PJ12106RHW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.004829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274737 LIMIT 5 [ RunTime:0.001044s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274737 ORDER BY `minOrder` ASC [ RunTime:0.000726s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274737 ORDER BY `unit` DESC [ RunTime:0.003302s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274737 LIMIT 2 [ RunTime:0.007972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274737 ORDER BY `minOrder` ASC [ RunTime:0.000451s ]
select * from pdf where partno='PJ12106RW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.003491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274573 LIMIT 5 [ RunTime:0.001251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274573 ORDER BY `minOrder` ASC [ RunTime:0.000647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15274573 ORDER BY `unit` DESC [ RunTime:0.000598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15274573 LIMIT 2 [ RunTime:0.003442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15274573 ORDER BY `minOrder` ASC [ RunTime:0.003417s ]
select * from pdf where partno='PJ12106P20' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203432 LIMIT 5 [ RunTime:0.001915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203432 ORDER BY `minOrder` ASC [ RunTime:0.005784s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14203432 ORDER BY `unit` DESC [ RunTime:0.009853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14203432 LIMIT 2 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14203432 ORDER BY `minOrder` ASC [ RunTime:0.007252s ]
select * from pdf where partno='PJ12106HP16' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.001329s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220970 LIMIT 5 [ RunTime:0.002042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220970 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220970 ORDER BY `unit` DESC [ RunTime:0.000618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220970 LIMIT 2 [ RunTime:0.003940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220970 ORDER BY `minOrder` ASC [ RunTime:0.000452s ]
select * from pdf where partno='pj12106t' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000943s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106t' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.003974s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220970 AND `partno` = 'pj12106t' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.002904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036883 [ RunTime:0.004343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220767 LIMIT 5 [ RunTime:0.003076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220767 ORDER BY `minOrder` ASC [ RunTime:0.009381s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220767 ORDER BY `unit` DESC [ RunTime:0.003288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220767 LIMIT 2 [ RunTime:0.000617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220767 ORDER BY `minOrder` ASC [ RunTime:0.002969s ]
select * from pdf where partno='pj12106h' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106h' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.002120s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220767 AND `partno` = 'pj12106h' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.003667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060501 [ RunTime:0.006278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220967 LIMIT 5 [ RunTime:0.002978s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220967 ORDER BY `minOrder` ASC [ RunTime:0.004410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220967 ORDER BY `unit` DESC [ RunTime:0.004348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220967 LIMIT 2 [ RunTime:0.004106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220967 ORDER BY `minOrder` ASC [ RunTime:0.006042s ]
select * from pdf where partno='pj12106l' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.015334s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106l' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.007421s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220967 AND `partno` = 'pj12106l' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.005112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276916 [ RunTime:0.002533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220966 LIMIT 5 [ RunTime:0.000990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220966 ORDER BY `minOrder` ASC [ RunTime:0.000707s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220966 ORDER BY `unit` DESC [ RunTime:0.003486s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220966 LIMIT 2 [ RunTime:0.008830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220966 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='pj12106' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.010032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.009565s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220966 AND `partno` = 'pj12106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.008594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034151 [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220768 LIMIT 5 [ RunTime:0.011959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220768 ORDER BY `minOrder` ASC [ RunTime:0.013039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220768 ORDER BY `unit` DESC [ RunTime:0.000637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220768 LIMIT 2 [ RunTime:0.000643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220768 ORDER BY `minOrder` ASC [ RunTime:0.003197s ]
select * from pdf where partno='pj12106rlw' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106rlw' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.011746s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220768 AND `partno` = 'pj12106rlw' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.004720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027296 [ RunTime:0.003355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220971 LIMIT 5 [ RunTime:0.009101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220971 ORDER BY `minOrder` ASC [ RunTime:0.004118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220971 ORDER BY `unit` DESC [ RunTime:0.002989s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220971 LIMIT 2 [ RunTime:0.001383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220971 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='pj12106tw' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.000973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106tw' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.009193s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220971 AND `partno` = 'pj12106tw' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.011370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027261 [ RunTime:0.003599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220969 LIMIT 5 [ RunTime:0.002065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220969 ORDER BY `minOrder` ASC [ RunTime:0.004194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220969 ORDER BY `unit` DESC [ RunTime:0.000653s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220969 LIMIT 2 [ RunTime:0.002798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220969 ORDER BY `minOrder` ASC [ RunTime:0.000758s ]
select * from pdf where partno='pj12106rtw' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106rtw' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.009719s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220969 AND `partno` = 'pj12106rtw' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.009735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274785 [ RunTime:0.000878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220968 LIMIT 5 [ RunTime:0.006705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220968 ORDER BY `minOrder` ASC [ RunTime:0.006800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220968 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220968 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220968 ORDER BY `minOrder` ASC [ RunTime:0.004140s ]
select * from pdf where partno='pj12106lw' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001629s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106lw' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.002610s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220968 AND `partno` = 'pj12106lw' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027260 [ RunTime:0.003964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220524 LIMIT 5 [ RunTime:0.001645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220524 ORDER BY `minOrder` ASC [ RunTime:0.001961s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220524 ORDER BY `unit` DESC [ RunTime:0.001663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220524 LIMIT 2 [ RunTime:0.004473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220524 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='pj12106rt' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.001205s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106rt' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.003709s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220524 AND `partno` = 'pj12106rt' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026554 [ RunTime:0.001989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32220523 LIMIT 5 [ RunTime:0.003920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220523 ORDER BY `minOrder` ASC [ RunTime:0.007241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32220523 ORDER BY `unit` DESC [ RunTime:0.001564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32220523 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32220523 ORDER BY `minOrder` ASC [ RunTime:0.004126s ]
select * from pdf where partno='pj12106rl' and brandshort='hammond manufacturing' limit 1 [ RunTime:0.006191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pj12106rl' OR `brand` LIKE 'hammond manufacturing%' ) ) LIMIT 1 [ RunTime:0.007141s ]
SELECT `id` FROM `stock` WHERE `id` <> 32220523 AND `partno` = 'pj12106rl' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.018947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026553 [ RunTime:0.001398s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63423667 LIMIT 5 [ RunTime:0.006888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423667 ORDER BY `minOrder` ASC [ RunTime:0.016995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63423667 ORDER BY `unit` DESC [ RunTime:0.004448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63423667 LIMIT 2 [ RunTime:0.010174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63423667 ORDER BY `minOrder` ASC [ RunTime:0.002509s ]
select * from pdf where partno='PJ12106L' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000570s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106L' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.008365s ]
SELECT `id` FROM `stock` WHERE `id` <> 63423667 AND `partno` = 'PJ12106L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.004598s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15276916 [ RunTime:0.005093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63426060 LIMIT 5 [ RunTime:0.007004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63426060 ORDER BY `minOrder` ASC [ RunTime:0.041010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63426060 ORDER BY `unit` DESC [ RunTime:0.008692s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63426060 LIMIT 2 [ RunTime:0.018042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63426060 ORDER BY `minOrder` ASC [ RunTime:0.026847s ]
select * from pdf where partno='PJ12106RL' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.006521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RL' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.018666s ]
SELECT `id` FROM `stock` WHERE `id` <> 63426060 AND `partno` = 'PJ12106RL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.043441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026553 [ RunTime:0.012234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63431291 LIMIT 5 [ RunTime:0.005374s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63431291 ORDER BY `minOrder` ASC [ RunTime:0.029914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63431291 ORDER BY `unit` DESC [ RunTime:0.014967s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63431291 LIMIT 2 [ RunTime:0.027301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63431291 ORDER BY `minOrder` ASC [ RunTime:0.014089s ]
select * from pdf where partno='PJ12106R' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.010559s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106R' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.020591s ]
SELECT `id` FROM `stock` WHERE `id` <> 63431291 AND `partno` = 'PJ12106R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.000970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060499 [ RunTime:0.004973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63428928 LIMIT 5 [ RunTime:0.000947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63428928 ORDER BY `minOrder` ASC [ RunTime:0.003022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63428928 ORDER BY `unit` DESC [ RunTime:0.024176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63428928 LIMIT 2 [ RunTime:0.001724s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63428928 ORDER BY `minOrder` ASC [ RunTime:0.006130s ]
select * from pdf where partno='PJ12106H' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.009275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106H' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.010899s ]
SELECT `id` FROM `stock` WHERE `id` <> 63428928 AND `partno` = 'PJ12106H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.022056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17060501 [ RunTime:0.013492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441638 LIMIT 5 [ RunTime:0.001962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441638 ORDER BY `minOrder` ASC [ RunTime:0.003826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441638 ORDER BY `unit` DESC [ RunTime:0.003296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441638 LIMIT 2 [ RunTime:0.000609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441638 ORDER BY `minOrder` ASC [ RunTime:0.015293s ]
select * from pdf where partno='PJ12106RTW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.006275s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RTW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.017195s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441638 AND `partno` = 'PJ12106RTW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.005213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274785 [ RunTime:0.010062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441637 LIMIT 5 [ RunTime:0.000770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441637 ORDER BY `minOrder` ASC [ RunTime:0.005452s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441637 ORDER BY `unit` DESC [ RunTime:0.002204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441637 LIMIT 2 [ RunTime:0.009612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441637 ORDER BY `minOrder` ASC [ RunTime:0.002251s ]
select * from pdf where partno='PJ12106RLW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002588s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RLW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.006739s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441637 AND `partno` = 'PJ12106RLW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.001012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027296 [ RunTime:0.003536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441522 LIMIT 5 [ RunTime:0.011033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441522 ORDER BY `minOrder` ASC [ RunTime:0.005099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441522 ORDER BY `unit` DESC [ RunTime:0.012447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441522 LIMIT 2 [ RunTime:0.007740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441522 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='PJ12106TW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106TW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.001331s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441522 AND `partno` = 'PJ12106TW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.013289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027261 [ RunTime:0.003381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441521 LIMIT 5 [ RunTime:0.011163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441521 ORDER BY `minOrder` ASC [ RunTime:0.008563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441521 ORDER BY `unit` DESC [ RunTime:0.021154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441521 LIMIT 2 [ RunTime:0.011037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441521 ORDER BY `minOrder` ASC [ RunTime:0.005146s ]
select * from pdf where partno='PJ12106LW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.004212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106LW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.002577s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441521 AND `partno` = 'PJ12106LW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.002798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027260 [ RunTime:0.003378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441366 LIMIT 5 [ RunTime:0.029531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441366 ORDER BY `minOrder` ASC [ RunTime:0.009153s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441366 ORDER BY `unit` DESC [ RunTime:0.018482s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441366 LIMIT 2 [ RunTime:0.010448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441366 ORDER BY `minOrder` ASC [ RunTime:0.010611s ]
select * from pdf where partno='PJ12106RHW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.004416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RHW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.003438s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441366 AND `partno` = 'PJ12106RHW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.011914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274747 [ RunTime:0.007485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441320 LIMIT 5 [ RunTime:0.005452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441320 ORDER BY `minOrder` ASC [ RunTime:0.017100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441320 ORDER BY `unit` DESC [ RunTime:0.008305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441320 LIMIT 2 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441320 ORDER BY `minOrder` ASC [ RunTime:0.009085s ]
select * from pdf where partno='PJ12106HW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002591s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106HW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.009224s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441320 AND `partno` = 'PJ12106HW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.004487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027166 [ RunTime:0.003085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441281 LIMIT 5 [ RunTime:0.032570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441281 ORDER BY `minOrder` ASC [ RunTime:0.014853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441281 ORDER BY `unit` DESC [ RunTime:0.007781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441281 LIMIT 2 [ RunTime:0.013829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441281 ORDER BY `minOrder` ASC [ RunTime:0.012216s ]
select * from pdf where partno='PJ12106RW' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.008511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RW' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.018279s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441281 AND `partno` = 'PJ12106RW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.018640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274737 [ RunTime:0.008733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63441182 LIMIT 5 [ RunTime:0.011866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441182 ORDER BY `minOrder` ASC [ RunTime:0.009741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63441182 ORDER BY `unit` DESC [ RunTime:0.014236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63441182 LIMIT 2 [ RunTime:0.007134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63441182 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
select * from pdf where partno='PJ12106W' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106W' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.003781s ]
SELECT `id` FROM `stock` WHERE `id` <> 63441182 AND `partno` = 'PJ12106W' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.008894s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19027114 [ RunTime:0.007835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440553 LIMIT 5 [ RunTime:0.012979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440553 ORDER BY `minOrder` ASC [ RunTime:0.010557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440553 ORDER BY `unit` DESC [ RunTime:0.014976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440553 LIMIT 2 [ RunTime:0.012785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440553 ORDER BY `minOrder` ASC [ RunTime:0.008897s ]
select * from pdf where partno='PJ12106HP20' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002014s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106HP20' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.000965s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440553 AND `partno` = 'PJ12106HP20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.010852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026749 [ RunTime:0.010758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440408 LIMIT 5 [ RunTime:0.009171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440408 ORDER BY `minOrder` ASC [ RunTime:0.003356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440408 ORDER BY `unit` DESC [ RunTime:0.014687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440408 LIMIT 2 [ RunTime:0.017521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440408 ORDER BY `minOrder` ASC [ RunTime:0.019286s ]
select * from pdf where partno='PJ12106P20' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002109s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106P20' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.016656s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440408 AND `partno` = 'PJ12106P20' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.010924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15274573 [ RunTime:0.008758s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440407 LIMIT 5 [ RunTime:0.015169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440407 ORDER BY `minOrder` ASC [ RunTime:0.020786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440407 ORDER BY `unit` DESC [ RunTime:0.012890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440407 LIMIT 2 [ RunTime:0.001387s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440407 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
select * from pdf where partno='PJ12106HP16' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.009007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106HP16' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.025190s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440407 AND `partno` = 'PJ12106HP16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.010533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14203432 [ RunTime:0.007273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440251 LIMIT 5 [ RunTime:0.001319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440251 ORDER BY `minOrder` ASC [ RunTime:0.011936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440251 ORDER BY `unit` DESC [ RunTime:0.032648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440251 LIMIT 2 [ RunTime:0.026299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440251 ORDER BY `minOrder` ASC [ RunTime:0.016349s ]
select * from pdf where partno='PJ12106P16' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.012684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106P16' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.006829s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440251 AND `partno` = 'PJ12106P16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.010057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026609 [ RunTime:0.002939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63440145 LIMIT 5 [ RunTime:0.013163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440145 ORDER BY `minOrder` ASC [ RunTime:0.021215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63440145 ORDER BY `unit` DESC [ RunTime:0.011006s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63440145 LIMIT 2 [ RunTime:0.001661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63440145 ORDER BY `minOrder` ASC [ RunTime:0.009031s ]
select * from pdf where partno='PJ12106RT' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.004900s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RT' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.016369s ]
SELECT `id` FROM `stock` WHERE `id` <> 63440145 AND `partno` = 'PJ12106RT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.006048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026554 [ RunTime:0.000469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439954 LIMIT 5 [ RunTime:0.007411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439954 ORDER BY `minOrder` ASC [ RunTime:0.000876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439954 ORDER BY `unit` DESC [ RunTime:0.004801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439954 LIMIT 2 [ RunTime:0.007650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439954 ORDER BY `minOrder` ASC [ RunTime:0.002474s ]
select * from pdf where partno='PJ12106T' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.006796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106T' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.027153s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439954 AND `partno` = 'PJ12106T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.039380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19036883 [ RunTime:0.016248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439813 LIMIT 5 [ RunTime:0.017145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439813 ORDER BY `minOrder` ASC [ RunTime:0.011609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439813 ORDER BY `unit` DESC [ RunTime:0.003779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439813 LIMIT 2 [ RunTime:0.016258s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439813 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
select * from pdf where partno='PJ12106RH' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.000589s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106RH' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.021726s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439813 AND `partno` = 'PJ12106RH' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.011998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19026374 [ RunTime:0.017237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63439414 LIMIT 5 [ RunTime:0.039091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439414 ORDER BY `minOrder` ASC [ RunTime:0.013483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63439414 ORDER BY `unit` DESC [ RunTime:0.046754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63439414 LIMIT 2 [ RunTime:0.028709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63439414 ORDER BY `minOrder` ASC [ RunTime:0.024327s ]
select * from pdf where partno='PJ12106' and brandshort='Hammond Manufacturing' limit 1 [ RunTime:0.002902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PJ12106' OR `brand` LIKE 'Hammond Manufacturing%' ) ) LIMIT 1 [ RunTime:0.028071s ]
SELECT `id` FROM `stock` WHERE `id` <> 63439414 AND `partno` = 'PJ12106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%hammond manufacturing%' ) [ RunTime:0.026523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19034151 [ RunTime:0.009716s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010371s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026703s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008290s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009358s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011306s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016353s ]
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 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012621s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'pj12106%' OR `brand` LIKE 'pj12106%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.017881s ]