SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001499s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=PL15&search=1' [ RunTime:0.005353s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001185s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000484s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002853s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002134s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002333s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002033s ]
SELECT * FROM `stock_search` WHERE `partno` = 'PL15' LIMIT 1 [ RunTime:0.007484s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-11 00:53:38' WHERE `partno` = 'PL15' [ RunTime:0.033517s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003033s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039091s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934090 LIMIT 5 [ RunTime:0.031926s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934090 ORDER BY `minOrder` ASC [ RunTime:0.010342s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18934090 ORDER BY `unit` DESC [ RunTime:0.010331s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18934090 LIMIT 2 [ RunTime:0.000576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934090 ORDER BY `minOrder` ASC [ RunTime:0.000346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934088 LIMIT 5 [ RunTime:0.012890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934088 ORDER BY `minOrder` ASC [ RunTime:0.006429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18934088 ORDER BY `unit` DESC [ RunTime:0.025461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18934088 LIMIT 2 [ RunTime:0.021088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18934088 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681878 LIMIT 5 [ RunTime:0.010650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681878 ORDER BY `minOrder` ASC [ RunTime:0.002734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11681878 ORDER BY `unit` DESC [ RunTime:0.014219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11681878 LIMIT 2 [ RunTime:0.018261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11681878 ORDER BY `minOrder` ASC [ RunTime:0.005634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682850 LIMIT 5 [ RunTime:0.028372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682850 ORDER BY `minOrder` ASC [ RunTime:0.006099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682850 ORDER BY `unit` DESC [ RunTime:0.007150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682850 LIMIT 2 [ RunTime:0.019918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682850 ORDER BY `minOrder` ASC [ RunTime:0.024136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18986458 LIMIT 5 [ RunTime:0.030379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18986458 ORDER BY `minOrder` ASC [ RunTime:0.019118s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18986458 ORDER BY `unit` DESC [ RunTime:0.032756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18986458 LIMIT 2 [ RunTime:0.020974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18986458 ORDER BY `minOrder` ASC [ RunTime:0.005041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881218 LIMIT 5 [ RunTime:0.001853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881218 ORDER BY `minOrder` ASC [ RunTime:0.015269s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12881218 ORDER BY `unit` DESC [ RunTime:0.013626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12881218 LIMIT 2 [ RunTime:0.006790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12881218 ORDER BY `minOrder` ASC [ RunTime:0.007203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880926 LIMIT 5 [ RunTime:0.015538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880926 ORDER BY `minOrder` ASC [ RunTime:0.007252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880926 ORDER BY `unit` DESC [ RunTime:0.000351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880926 LIMIT 2 [ RunTime:0.016355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880926 ORDER BY `minOrder` ASC [ RunTime:0.000297s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880881 LIMIT 5 [ RunTime:0.014890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880881 ORDER BY `minOrder` ASC [ RunTime:0.003975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12880881 ORDER BY `unit` DESC [ RunTime:0.004644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12880881 LIMIT 2 [ RunTime:0.011043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12880881 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682094 LIMIT 5 [ RunTime:0.006038s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682094 ORDER BY `minOrder` ASC [ RunTime:0.007861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11682094 ORDER BY `unit` DESC [ RunTime:0.015542s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11682094 LIMIT 2 [ RunTime:0.023634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11682094 ORDER BY `minOrder` ASC [ RunTime:0.006589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18986072 LIMIT 5 [ RunTime:0.011803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18986072 ORDER BY `minOrder` ASC [ RunTime:0.003232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18986072 ORDER BY `unit` DESC [ RunTime:0.000620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18986072 LIMIT 2 [ RunTime:0.000530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18986072 ORDER BY `minOrder` ASC [ RunTime:0.007470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18932983 LIMIT 5 [ RunTime:0.016778s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932983 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18932983 ORDER BY `unit` DESC [ RunTime:0.010873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18932983 LIMIT 2 [ RunTime:0.000877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18932983 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15255342 LIMIT 5 [ RunTime:0.000903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15255342 ORDER BY `minOrder` ASC [ RunTime:0.000552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15255342 ORDER BY `unit` DESC [ RunTime:0.006815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15255342 LIMIT 2 [ RunTime:0.003359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15255342 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14197544 LIMIT 5 [ RunTime:0.000979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14197544 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14197544 ORDER BY `unit` DESC [ RunTime:0.019839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14197544 LIMIT 2 [ RunTime:0.001236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14197544 ORDER BY `minOrder` ASC [ RunTime:0.000531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12882217 LIMIT 5 [ RunTime:0.006937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882217 ORDER BY `minOrder` ASC [ RunTime:0.000615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12882217 ORDER BY `unit` DESC [ RunTime:0.003045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12882217 LIMIT 2 [ RunTime:0.011298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12882217 ORDER BY `minOrder` ASC [ RunTime:0.019893s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12876765 LIMIT 5 [ RunTime:0.007590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12876765 ORDER BY `minOrder` ASC [ RunTime:0.007374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12876765 ORDER BY `unit` DESC [ RunTime:0.000452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12876765 LIMIT 2 [ RunTime:0.013716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12876765 ORDER BY `minOrder` ASC [ RunTime:0.002200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12875722 LIMIT 5 [ RunTime:0.004949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875722 ORDER BY `minOrder` ASC [ RunTime:0.006212s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12875722 ORDER BY `unit` DESC [ RunTime:0.001408s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12875722 LIMIT 2 [ RunTime:0.000336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12875722 ORDER BY `minOrder` ASC [ RunTime:0.002469s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683105 LIMIT 5 [ RunTime:0.006486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683105 ORDER BY `minOrder` ASC [ RunTime:0.002139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683105 ORDER BY `unit` DESC [ RunTime:0.007008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683105 LIMIT 2 [ RunTime:0.004967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683105 ORDER BY `minOrder` ASC [ RunTime:0.022054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683103 LIMIT 5 [ RunTime:0.035731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683103 ORDER BY `minOrder` ASC [ RunTime:0.020285s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683103 ORDER BY `unit` DESC [ RunTime:0.004972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683103 LIMIT 2 [ RunTime:0.003690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683103 ORDER BY `minOrder` ASC [ RunTime:0.000534s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683102 LIMIT 5 [ RunTime:0.001359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683102 ORDER BY `minOrder` ASC [ RunTime:0.004688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683102 ORDER BY `unit` DESC [ RunTime:0.004365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683102 LIMIT 2 [ RunTime:0.012136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683102 ORDER BY `minOrder` ASC [ RunTime:0.004158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11683083 LIMIT 5 [ RunTime:0.009332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683083 ORDER BY `minOrder` ASC [ RunTime:0.003651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11683083 ORDER BY `unit` DESC [ RunTime:0.021593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11683083 LIMIT 2 [ RunTime:0.008158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11683083 ORDER BY `minOrder` ASC [ RunTime:0.014076s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302282 LIMIT 5 [ RunTime:0.016052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302282 ORDER BY `minOrder` ASC [ RunTime:0.011028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302282 ORDER BY `unit` DESC [ RunTime:0.014278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302282 LIMIT 2 [ RunTime:0.000677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302282 ORDER BY `minOrder` ASC [ RunTime:0.000457s ]
select * from pdf where partno='pl155ac-221' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.009859s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl155ac-221' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.002986s ]
SELECT `id` FROM `stock` WHERE `id` <> 32302282 AND `partno` = 'pl155ac-221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.002451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274160 [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274160 LIMIT 5 [ RunTime:0.002248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274160 ORDER BY `minOrder` ASC [ RunTime:0.008086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274160 ORDER BY `unit` DESC [ RunTime:0.009467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274160 LIMIT 2 [ RunTime:0.011646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274160 ORDER BY `minOrder` ASC [ RunTime:0.001600s ]
select * from pdf where partno='pl155ac-221' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.007650s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl155ac-221' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.012614s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274160 AND `partno` = 'pl155ac-221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.009699s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302282 [ RunTime:0.001178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302199 LIMIT 5 [ RunTime:0.000889s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302199 ORDER BY `minOrder` ASC [ RunTime:0.002754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302199 ORDER BY `unit` DESC [ RunTime:0.002395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302199 LIMIT 2 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302199 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
select * from pdf where partno='pl151' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.005491s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl151' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.001528s ]
SELECT `id` FROM `stock` WHERE `id` <> 32302199 AND `partno` = 'pl151' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.004743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274207 [ RunTime:0.002686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274207 LIMIT 5 [ RunTime:0.006004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274207 ORDER BY `minOrder` ASC [ RunTime:0.008343s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274207 ORDER BY `unit` DESC [ RunTime:0.012966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274207 LIMIT 2 [ RunTime:0.003318s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274207 ORDER BY `minOrder` ASC [ RunTime:0.000470s ]
select * from pdf where partno='pl151' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.000686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl151' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.000444s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274207 AND `partno` = 'pl151' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.009233s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302199 [ RunTime:0.016335s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302006 LIMIT 5 [ RunTime:0.011448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302006 ORDER BY `minOrder` ASC [ RunTime:0.014006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32302006 ORDER BY `unit` DESC [ RunTime:0.011949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32302006 LIMIT 2 [ RunTime:0.027590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32302006 ORDER BY `minOrder` ASC [ RunTime:0.014364s ]
select * from pdf where partno='pl155fl-29' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.001067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl155fl-29' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.008070s ]
SELECT `id` FROM `stock` WHERE `id` <> 32302006 AND `partno` = 'pl155fl-29' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.010984s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274017 [ RunTime:0.012494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32274017 LIMIT 5 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274017 ORDER BY `minOrder` ASC [ RunTime:0.007179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32274017 ORDER BY `unit` DESC [ RunTime:0.001794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32274017 LIMIT 2 [ RunTime:0.002151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32274017 ORDER BY `minOrder` ASC [ RunTime:0.007357s ]
select * from pdf where partno='pl155fl-29' and brandshort='trompeter / cinch connectivity solutions' limit 1 [ RunTime:0.003239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'pl155fl-29' OR `brand` LIKE 'trompeter / cinch connectivity solutions%' ) ) LIMIT 1 [ RunTime:0.009666s ]
SELECT `id` FROM `stock` WHERE `id` <> 32274017 AND `partno` = 'pl155fl-29' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%trompeter / cinch connectivity solutions%' ) [ RunTime:0.001047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32302006 [ RunTime:0.001869s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909813 LIMIT 5 [ RunTime:0.046852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909813 ORDER BY `minOrder` ASC [ RunTime:0.014461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909813 ORDER BY `unit` DESC [ RunTime:0.002960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909813 LIMIT 2 [ RunTime:0.007229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909813 ORDER BY `minOrder` ASC [ RunTime:0.000520s ]
select * from pdf where partno='PL155-47' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.003868s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155-47' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.005757s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909813 AND `partno` = 'PL155-47' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.015392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11681878 [ RunTime:0.007383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58138298 LIMIT 5 [ RunTime:0.011068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58138298 ORDER BY `minOrder` ASC [ RunTime:0.020080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58138298 ORDER BY `unit` DESC [ RunTime:0.005165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58138298 LIMIT 2 [ RunTime:0.008595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58138298 ORDER BY `minOrder` ASC [ RunTime:0.005130s ]
select * from pdf where partno='PL1590UN' and brandshort='Khatod North America LLC' limit 1 [ RunTime:0.013111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1590UN' OR `brand` LIKE 'Khatod North America LLC%' ) ) LIMIT 1 [ RunTime:0.001164s ]
SELECT `id` FROM `stock` WHERE `id` <> 58138298 AND `partno` = 'PL1590UN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%khatod north america llc%' ) [ RunTime:0.008284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934090 [ RunTime:0.007100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912804 LIMIT 5 [ RunTime:0.000488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912804 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912804 ORDER BY `unit` DESC [ RunTime:0.001976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912804 LIMIT 2 [ RunTime:0.000859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912804 ORDER BY `minOrder` ASC [ RunTime:0.000293s ]
select * from pdf where partno='PL155AC-201' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.004610s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155AC-201' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.000755s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912804 AND `partno` = 'PL155AC-201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.009438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58138299 LIMIT 5 [ RunTime:0.005022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58138299 ORDER BY `minOrder` ASC [ RunTime:0.004563s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58138299 ORDER BY `unit` DESC [ RunTime:0.003172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58138299 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58138299 ORDER BY `minOrder` ASC [ RunTime:0.000835s ]
select * from pdf where partno='PL1590ME' and brandshort='Khatod North America LLC' limit 1 [ RunTime:0.004493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1590ME' OR `brand` LIKE 'Khatod North America LLC%' ) ) LIMIT 1 [ RunTime:0.002095s ]
SELECT `id` FROM `stock` WHERE `id` <> 58138299 AND `partno` = 'PL1590ME' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%khatod north america llc%' ) [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18934088 [ RunTime:0.000501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61914306 LIMIT 5 [ RunTime:0.011924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914306 ORDER BY `minOrder` ASC [ RunTime:0.002570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61914306 ORDER BY `unit` DESC [ RunTime:0.009031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61914306 LIMIT 2 [ RunTime:0.002023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61914306 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='PL155AC-212' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.001468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155AC-212' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.001517s ]
SELECT `id` FROM `stock` WHERE `id` <> 61914306 AND `partno` = 'PL155AC-212' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.007473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12881218 [ RunTime:0.003455s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915398 LIMIT 5 [ RunTime:0.004976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915398 ORDER BY `minOrder` ASC [ RunTime:0.007552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915398 ORDER BY `unit` DESC [ RunTime:0.004775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915398 LIMIT 2 [ RunTime:0.005830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915398 ORDER BY `minOrder` ASC [ RunTime:0.005938s ]
select * from pdf where partno='PL155FL-33' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.001683s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155FL-33' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.001418s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915398 AND `partno` = 'PL155FL-33' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.000735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58593934 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58593934 ORDER BY `minOrder` ASC [ RunTime:0.006907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58593934 ORDER BY `unit` DESC [ RunTime:0.002095s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58593934 LIMIT 2 [ RunTime:0.002280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58593934 ORDER BY `minOrder` ASC [ RunTime:0.000270s ]
select * from pdf where partno='PL155' and brandshort='Apex Tool Group' limit 1 [ RunTime:0.007736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155' OR `brand` LIKE 'Apex Tool Group%' ) ) LIMIT 1 [ RunTime:0.003127s ]
SELECT `id` FROM `stock` WHERE `id` <> 58593934 AND `partno` = 'PL155' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apex tool group%' ) [ RunTime:0.002140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18986458 [ RunTime:0.004467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61912893 LIMIT 5 [ RunTime:0.005688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912893 ORDER BY `minOrder` ASC [ RunTime:0.014532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61912893 ORDER BY `unit` DESC [ RunTime:0.012399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61912893 LIMIT 2 [ RunTime:0.007108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61912893 ORDER BY `minOrder` ASC [ RunTime:0.009126s ]
select * from pdf where partno='PL155AC-303' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.004822s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155AC-303' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.010027s ]
SELECT `id` FROM `stock` WHERE `id` <> 61912893 AND `partno` = 'PL155AC-303' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.010921s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880926 [ RunTime:0.000814s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61916344 LIMIT 5 [ RunTime:0.007923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916344 ORDER BY `minOrder` ASC [ RunTime:0.003804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61916344 ORDER BY `unit` DESC [ RunTime:0.001921s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61916344 LIMIT 2 [ RunTime:0.002471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916344 ORDER BY `minOrder` ASC [ RunTime:0.000453s ]
select * from pdf where partno='PL155ACFL-201' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155ACFL-201' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.007152s ]
SELECT `id` FROM `stock` WHERE `id` <> 61916344 AND `partno` = 'PL155ACFL-201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.013060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682094 [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61916950 LIMIT 5 [ RunTime:0.011426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916950 ORDER BY `minOrder` ASC [ RunTime:0.020139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61916950 ORDER BY `unit` DESC [ RunTime:0.002690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61916950 LIMIT 2 [ RunTime:0.018903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61916950 ORDER BY `minOrder` ASC [ RunTime:0.000546s ]
select * from pdf where partno='PL155AC-221' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.018502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155AC-221' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.007982s ]
SELECT `id` FROM `stock` WHERE `id` <> 61916950 AND `partno` = 'PL155AC-221' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.015805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12880881 [ RunTime:0.002572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61915888 LIMIT 5 [ RunTime:0.010589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915888 ORDER BY `minOrder` ASC [ RunTime:0.007880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61915888 ORDER BY `unit` DESC [ RunTime:0.023625s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61915888 LIMIT 2 [ RunTime:0.000762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61915888 ORDER BY `minOrder` ASC [ RunTime:0.001335s ]
select * from pdf where partno='PL155-32' and brandshort='Cinch Connectivity Solutions Trompeter' limit 1 [ RunTime:0.003335s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL155-32' OR `brand` LIKE 'Cinch Connectivity Solutions Trompeter%' ) ) LIMIT 1 [ RunTime:0.000860s ]
SELECT `id` FROM `stock` WHERE `id` <> 61915888 AND `partno` = 'PL155-32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cinch connectivity solutions trompeter%' ) [ RunTime:0.000885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11682850 [ RunTime:0.007525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64684712 LIMIT 5 [ RunTime:0.008384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684712 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64684712 ORDER BY `unit` DESC [ RunTime:0.002774s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64684712 LIMIT 2 [ RunTime:0.017473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684712 ORDER BY `minOrder` ASC [ RunTime:0.005625s ]
select * from pdf where partno='PL1504' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.023884s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1504' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.003343s ]
SELECT `id` FROM `stock` WHERE `id` <> 64684712 AND `partno` = 'PL1504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.000965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64684711 LIMIT 5 [ RunTime:0.002996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684711 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64684711 ORDER BY `unit` DESC [ RunTime:0.000391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64684711 LIMIT 2 [ RunTime:0.000448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684711 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='PL1502' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.000568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1502' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.002778s ]
SELECT `id` FROM `stock` WHERE `id` <> 64684711 AND `partno` = 'PL1502' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.002887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64684707 LIMIT 5 [ RunTime:0.006013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684707 ORDER BY `minOrder` ASC [ RunTime:0.012706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64684707 ORDER BY `unit` DESC [ RunTime:0.004568s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64684707 LIMIT 2 [ RunTime:0.009201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64684707 ORDER BY `minOrder` ASC [ RunTime:0.008571s ]
select * from pdf where partno='PL1507' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.006814s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1507' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.004121s ]
SELECT `id` FROM `stock` WHERE `id` <> 64684707 AND `partno` = 'PL1507' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.012043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710387 LIMIT 5 [ RunTime:0.003039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710387 ORDER BY `minOrder` ASC [ RunTime:0.002883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710387 ORDER BY `unit` DESC [ RunTime:0.011336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710387 LIMIT 2 [ RunTime:0.006955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710387 ORDER BY `minOrder` ASC [ RunTime:0.007387s ]
select * from pdf where partno='PL1512' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.006069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1512' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.013320s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710387 AND `partno` = 'PL1512' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.002419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710386 LIMIT 5 [ RunTime:0.008183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710386 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710386 ORDER BY `unit` DESC [ RunTime:0.002884s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710386 LIMIT 2 [ RunTime:0.011377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710386 ORDER BY `minOrder` ASC [ RunTime:0.000493s ]
select * from pdf where partno='PL1543' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.003579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1543' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.013862s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710386 AND `partno` = 'PL1543' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.003355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710385 LIMIT 5 [ RunTime:0.000639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710385 ORDER BY `minOrder` ASC [ RunTime:0.005570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710385 ORDER BY `unit` DESC [ RunTime:0.001265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710385 LIMIT 2 [ RunTime:0.007681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710385 ORDER BY `minOrder` ASC [ RunTime:0.004830s ]
select * from pdf where partno='PL1506' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.003464s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1506' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.008391s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710385 AND `partno` = 'PL1506' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.004789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710384 LIMIT 5 [ RunTime:0.004996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710384 ORDER BY `minOrder` ASC [ RunTime:0.000743s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710384 ORDER BY `unit` DESC [ RunTime:0.000606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710384 LIMIT 2 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710384 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='PL1514' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.003692s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1514' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.000909s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710384 AND `partno` = 'PL1514' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.005124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710383 LIMIT 5 [ RunTime:0.003670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710383 ORDER BY `minOrder` ASC [ RunTime:0.001532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710383 ORDER BY `unit` DESC [ RunTime:0.004522s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710383 LIMIT 2 [ RunTime:0.004515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710383 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
select * from pdf where partno='PL1503' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.019320s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1503' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.002942s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710383 AND `partno` = 'PL1503' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.007138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64710382 LIMIT 5 [ RunTime:0.006313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710382 ORDER BY `minOrder` ASC [ RunTime:0.003355s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64710382 ORDER BY `unit` DESC [ RunTime:0.000889s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64710382 LIMIT 2 [ RunTime:0.000864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64710382 ORDER BY `minOrder` ASC [ RunTime:0.000500s ]
select * from pdf where partno='PL1523' and brandshort='ifm efector, inc.' limit 1 [ RunTime:0.000922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PL1523' OR `brand` LIKE 'ifm efector, inc.%' ) ) LIMIT 1 [ RunTime:0.001589s ]
SELECT `id` FROM `stock` WHERE `id` <> 64710382 AND `partno` = 'PL1523' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%ifm efector, inc.%' ) [ RunTime:0.013518s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010341s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003057s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011083s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006037s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001930s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006265s ]
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 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005305s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PL15%' OR `brand` LIKE 'PL15%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001556s ]