SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001300s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=25-901-2.5-bar%2Fpsi-G1%2F4&search=1' [ RunTime:0.006229s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002049s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.008477s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002804s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.032502s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002682s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.011549s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002376s ]
SELECT * FROM `stock_search` WHERE `partno` = '25-901-2.5-bar/psi-G1/4' LIMIT 1 [ RunTime:0.022889s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 03:00:28' WHERE `partno` = '25-901-2.5-bar/psi-G1/4' [ RunTime:0.008445s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002849s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032939s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.010879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860714 LIMIT 5 [ RunTime:0.016242s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860714 ORDER BY `minOrder` ASC [ RunTime:0.030896s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860714 ORDER BY `unit` DESC [ RunTime:0.010324s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008843s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860714 LIMIT 2 [ RunTime:0.009731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860714 ORDER BY `minOrder` ASC [ RunTime:0.016065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860446 LIMIT 5 [ RunTime:0.021355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860446 ORDER BY `minOrder` ASC [ RunTime:0.055648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860446 ORDER BY `unit` DESC [ RunTime:0.038298s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860446 LIMIT 2 [ RunTime:0.055629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860446 ORDER BY `minOrder` ASC [ RunTime:0.021465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860394 LIMIT 5 [ RunTime:0.037411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860394 ORDER BY `minOrder` ASC [ RunTime:0.061187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860394 ORDER BY `unit` DESC [ RunTime:0.016388s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860394 LIMIT 2 [ RunTime:0.027064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860394 ORDER BY `minOrder` ASC [ RunTime:0.004538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860229 LIMIT 5 [ RunTime:0.010348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860229 ORDER BY `minOrder` ASC [ RunTime:0.027154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860229 ORDER BY `unit` DESC [ RunTime:0.044078s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860229 LIMIT 2 [ RunTime:0.034757s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860229 ORDER BY `minOrder` ASC [ RunTime:0.033806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860212 LIMIT 5 [ RunTime:0.075370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860212 ORDER BY `minOrder` ASC [ RunTime:0.060906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860212 ORDER BY `unit` DESC [ RunTime:0.034963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860212 LIMIT 2 [ RunTime:0.014598s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860212 ORDER BY `minOrder` ASC [ RunTime:0.013596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860198 LIMIT 5 [ RunTime:0.030558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860198 ORDER BY `minOrder` ASC [ RunTime:0.041198s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860198 ORDER BY `unit` DESC [ RunTime:0.047489s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860198 LIMIT 2 [ RunTime:0.079089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860198 ORDER BY `minOrder` ASC [ RunTime:0.023709s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860178 LIMIT 5 [ RunTime:0.055957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860178 ORDER BY `minOrder` ASC [ RunTime:0.034881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18860178 ORDER BY `unit` DESC [ RunTime:0.033252s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18860178 LIMIT 2 [ RunTime:0.022051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18860178 ORDER BY `minOrder` ASC [ RunTime:0.009345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859754 LIMIT 5 [ RunTime:0.023738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859754 ORDER BY `minOrder` ASC [ RunTime:0.051116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859754 ORDER BY `unit` DESC [ RunTime:0.042480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859754 LIMIT 2 [ RunTime:0.052851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859754 ORDER BY `minOrder` ASC [ RunTime:0.008219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859375 LIMIT 5 [ RunTime:0.029576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859375 ORDER BY `minOrder` ASC [ RunTime:0.019880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859375 ORDER BY `unit` DESC [ RunTime:0.031203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859375 LIMIT 2 [ RunTime:0.001801s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859375 ORDER BY `minOrder` ASC [ RunTime:0.007498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859349 LIMIT 5 [ RunTime:0.006335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859349 ORDER BY `minOrder` ASC [ RunTime:0.012808s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859349 ORDER BY `unit` DESC [ RunTime:0.014162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859349 LIMIT 2 [ RunTime:0.021145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859349 ORDER BY `minOrder` ASC [ RunTime:0.002941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859064 LIMIT 5 [ RunTime:0.009247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859064 ORDER BY `minOrder` ASC [ RunTime:0.035579s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18859064 ORDER BY `unit` DESC [ RunTime:0.008004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18859064 LIMIT 2 [ RunTime:0.001413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18859064 ORDER BY `minOrder` ASC [ RunTime:0.003191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858749 LIMIT 5 [ RunTime:0.001114s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858749 ORDER BY `minOrder` ASC [ RunTime:0.001475s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858749 ORDER BY `unit` DESC [ RunTime:0.004722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858749 LIMIT 2 [ RunTime:0.002468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858749 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858717 LIMIT 5 [ RunTime:0.009221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858717 ORDER BY `minOrder` ASC [ RunTime:0.010010s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858717 ORDER BY `unit` DESC [ RunTime:0.005448s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858717 LIMIT 2 [ RunTime:0.001357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858717 ORDER BY `minOrder` ASC [ RunTime:0.002010s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858580 LIMIT 5 [ RunTime:0.004774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858580 ORDER BY `minOrder` ASC [ RunTime:0.008610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858580 ORDER BY `unit` DESC [ RunTime:0.006728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858580 LIMIT 2 [ RunTime:0.005085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858580 ORDER BY `minOrder` ASC [ RunTime:0.005204s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858556 LIMIT 5 [ RunTime:0.007372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858556 ORDER BY `minOrder` ASC [ RunTime:0.001207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858556 ORDER BY `unit` DESC [ RunTime:0.000529s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858556 LIMIT 2 [ RunTime:0.002734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858556 ORDER BY `minOrder` ASC [ RunTime:0.009846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858555 LIMIT 5 [ RunTime:0.008093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858555 ORDER BY `minOrder` ASC [ RunTime:0.003549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18858555 ORDER BY `unit` DESC [ RunTime:0.003434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18858555 LIMIT 2 [ RunTime:0.001186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18858555 ORDER BY `minOrder` ASC [ RunTime:0.007575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025787 LIMIT 5 [ RunTime:0.004190s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025787 ORDER BY `minOrder` ASC [ RunTime:0.005045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025787 ORDER BY `unit` DESC [ RunTime:0.002605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025787 LIMIT 2 [ RunTime:0.002379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025787 ORDER BY `minOrder` ASC [ RunTime:0.004526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025629 LIMIT 5 [ RunTime:0.001422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025629 ORDER BY `minOrder` ASC [ RunTime:0.004596s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17025629 ORDER BY `unit` DESC [ RunTime:0.005562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17025629 LIMIT 2 [ RunTime:0.003346s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17025629 ORDER BY `minOrder` ASC [ RunTime:0.005991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240782 LIMIT 5 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240782 ORDER BY `minOrder` ASC [ RunTime:0.000578s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240782 ORDER BY `unit` DESC [ RunTime:0.004758s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240782 LIMIT 2 [ RunTime:0.006091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240782 ORDER BY `minOrder` ASC [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240747 LIMIT 5 [ RunTime:0.007456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240747 ORDER BY `minOrder` ASC [ RunTime:0.000838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15240747 ORDER BY `unit` DESC [ RunTime:0.000463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15240747 LIMIT 2 [ RunTime:0.000433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15240747 ORDER BY `minOrder` ASC [ RunTime:0.000275s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008457s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57279191 LIMIT 5 [ RunTime:0.015011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279191 ORDER BY `minOrder` ASC [ RunTime:0.020453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57279191 ORDER BY `unit` DESC [ RunTime:0.009184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57279191 LIMIT 2 [ RunTime:0.002832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57279191 ORDER BY `minOrder` ASC [ RunTime:0.013768s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-MIP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007707s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-MIP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005324s ]
SELECT `id` FROM `stock` WHERE `id` <> 57279191 AND `partno` = '25-901-2.5-bar/psi-G1/4-MIP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.005139s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860714 [ RunTime:0.006074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276832 LIMIT 5 [ RunTime:0.008594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276832 ORDER BY `minOrder` ASC [ RunTime:0.007716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276832 ORDER BY `unit` DESC [ RunTime:0.002779s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276832 LIMIT 2 [ RunTime:0.008960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276832 ORDER BY `minOrder` ASC [ RunTime:0.003480s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.021562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004336s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276832 AND `partno` = '25-901-2.5-bar/psi-G1/4-SP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859375 [ RunTime:0.008135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57276831 LIMIT 5 [ RunTime:0.006498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276831 ORDER BY `minOrder` ASC [ RunTime:0.017366s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57276831 ORDER BY `unit` DESC [ RunTime:0.028125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57276831 LIMIT 2 [ RunTime:0.019052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57276831 ORDER BY `minOrder` ASC [ RunTime:0.015587s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-MIP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.028337s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-MIP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007822s ]
SELECT `id` FROM `stock` WHERE `id` <> 57276831 AND `partno` = '25-901-2.5-bar/psi-G1/4-MIP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025787 [ RunTime:0.024134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089723 LIMIT 5 [ RunTime:0.013963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089723 ORDER BY `minOrder` ASC [ RunTime:0.015313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089723 ORDER BY `unit` DESC [ RunTime:0.004802s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089723 LIMIT 2 [ RunTime:0.015942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089723 ORDER BY `minOrder` ASC [ RunTime:0.002526s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SG-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014902s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SG-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004629s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089723 AND `partno` = '25-901-2.5-bar/psi-G1/4-SG-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.015666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860446 [ RunTime:0.003734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089687 LIMIT 5 [ RunTime:0.014491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089687 ORDER BY `minOrder` ASC [ RunTime:0.039630s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089687 ORDER BY `unit` DESC [ RunTime:0.009933s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089687 LIMIT 2 [ RunTime:0.017075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089687 ORDER BY `minOrder` ASC [ RunTime:0.009506s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SG-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.051521s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SG-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019171s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089687 AND `partno` = '25-901-2.5-bar/psi-G1/4-SG-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.021419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860394 [ RunTime:0.034013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089571 LIMIT 5 [ RunTime:0.019435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089571 ORDER BY `minOrder` ASC [ RunTime:0.053028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089571 ORDER BY `unit` DESC [ RunTime:0.072656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089571 LIMIT 2 [ RunTime:0.018578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089571 ORDER BY `minOrder` ASC [ RunTime:0.027828s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-GY40-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.026104s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-GY40-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016181s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089571 AND `partno` = '25-901-2.5-bar/psi-G1/4-GY40-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.020033s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860229 [ RunTime:0.029102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089553 LIMIT 5 [ RunTime:0.032796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089553 ORDER BY `minOrder` ASC [ RunTime:0.072154s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089553 ORDER BY `unit` DESC [ RunTime:0.053447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089553 LIMIT 2 [ RunTime:0.012223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089553 ORDER BY `minOrder` ASC [ RunTime:0.020425s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-GY40-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.033522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-GY40-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025546s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089553 AND `partno` = '25-901-2.5-bar/psi-G1/4-GY40-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.042836s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860212 [ RunTime:0.056876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089545 LIMIT 5 [ RunTime:0.031952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089545 ORDER BY `minOrder` ASC [ RunTime:0.031688s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089545 ORDER BY `unit` DESC [ RunTime:0.040293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089545 LIMIT 2 [ RunTime:0.047111s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089545 ORDER BY `minOrder` ASC [ RunTime:0.019898s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-BP3-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006853s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-BP3-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.046432s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089545 AND `partno` = '25-901-2.5-bar/psi-G1/4-BP3-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.041636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860198 [ RunTime:0.039872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089530 LIMIT 5 [ RunTime:0.026177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089530 ORDER BY `minOrder` ASC [ RunTime:0.036364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089530 ORDER BY `unit` DESC [ RunTime:0.029888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089530 LIMIT 2 [ RunTime:0.027918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089530 ORDER BY `minOrder` ASC [ RunTime:0.071356s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.018190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.005596s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089530 AND `partno` = '25-901-2.5-bar/psi-G1/4-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.016196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18860178 [ RunTime:0.035870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64089230 LIMIT 5 [ RunTime:0.017129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089230 ORDER BY `minOrder` ASC [ RunTime:0.041615s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64089230 ORDER BY `unit` DESC [ RunTime:0.010780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64089230 LIMIT 2 [ RunTime:0.014152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64089230 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-DRY-RCP-O2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-DRY-RCP-O2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008906s ]
SELECT `id` FROM `stock` WHERE `id` <> 64089230 AND `partno` = '25-901-2.5-bar/psi-G1/4-DRY-RCP-O2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859754 [ RunTime:0.005282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088886 LIMIT 5 [ RunTime:0.003089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088886 ORDER BY `minOrder` ASC [ RunTime:0.014225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088886 ORDER BY `unit` DESC [ RunTime:0.003948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088886 LIMIT 2 [ RunTime:0.000556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088886 ORDER BY `minOrder` ASC [ RunTime:0.003833s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-DRY-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.014498s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-DRY-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009406s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088886 AND `partno` = '25-901-2.5-bar/psi-G1/4-DRY-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859349 [ RunTime:0.015594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088586 LIMIT 5 [ RunTime:0.017021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088586 ORDER BY `minOrder` ASC [ RunTime:0.021380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088586 ORDER BY `unit` DESC [ RunTime:0.007224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088586 LIMIT 2 [ RunTime:0.006680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088586 ORDER BY `minOrder` ASC [ RunTime:0.000636s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SL' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.006537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SL' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007969s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088586 AND `partno` = '25-901-2.5-bar/psi-G1/4-SL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.031131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18859064 [ RunTime:0.006546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088145 LIMIT 5 [ RunTime:0.014876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088145 ORDER BY `minOrder` ASC [ RunTime:0.005754s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088145 ORDER BY `unit` DESC [ RunTime:0.000857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088145 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088145 ORDER BY `minOrder` ASC [ RunTime:0.003901s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-DRY' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010047s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-DRY' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004909s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088145 AND `partno` = '25-901-2.5-bar/psi-G1/4-DRY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858749 [ RunTime:0.009098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088120 LIMIT 5 [ RunTime:0.005323s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088120 ORDER BY `minOrder` ASC [ RunTime:0.008631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088120 ORDER BY `unit` DESC [ RunTime:0.000705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088120 LIMIT 2 [ RunTime:0.005399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088120 ORDER BY `minOrder` ASC [ RunTime:0.003782s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SG-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.005037s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SG-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.022012s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088120 AND `partno` = '25-901-2.5-bar/psi-G1/4-SG-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.042817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240782 [ RunTime:0.038779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64088079 LIMIT 5 [ RunTime:0.038241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088079 ORDER BY `minOrder` ASC [ RunTime:0.033282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64088079 ORDER BY `unit` DESC [ RunTime:0.030872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64088079 LIMIT 2 [ RunTime:0.015968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64088079 ORDER BY `minOrder` ASC [ RunTime:0.024791s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-SG' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.037204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-SG' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.059763s ]
SELECT `id` FROM `stock` WHERE `id` <> 64088079 AND `partno` = '25-901-2.5-bar/psi-G1/4-SG' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.027554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858717 [ RunTime:0.085846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64087925 LIMIT 5 [ RunTime:0.047497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087925 ORDER BY `minOrder` ASC [ RunTime:0.037129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64087925 ORDER BY `unit` DESC [ RunTime:0.085491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64087925 LIMIT 2 [ RunTime:0.056292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087925 ORDER BY `minOrder` ASC [ RunTime:0.028426s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-GY40-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.040199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-GY40-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018528s ]
SELECT `id` FROM `stock` WHERE `id` <> 64087925 AND `partno` = '25-901-2.5-bar/psi-G1/4-GY40-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.052191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858580 [ RunTime:0.018193s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64087899 LIMIT 5 [ RunTime:0.030892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087899 ORDER BY `minOrder` ASC [ RunTime:0.086346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64087899 ORDER BY `unit` DESC [ RunTime:0.029780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64087899 LIMIT 2 [ RunTime:0.039393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087899 ORDER BY `minOrder` ASC [ RunTime:0.017169s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-GY40' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.015247s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-GY40' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.060509s ]
SELECT `id` FROM `stock` WHERE `id` <> 64087899 AND `partno` = '25-901-2.5-bar/psi-G1/4-GY40' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.047037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15240747 [ RunTime:0.028767s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64087882 LIMIT 5 [ RunTime:0.065759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087882 ORDER BY `minOrder` ASC [ RunTime:0.035329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64087882 ORDER BY `unit` DESC [ RunTime:0.010727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64087882 LIMIT 2 [ RunTime:0.068200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087882 ORDER BY `minOrder` ASC [ RunTime:0.015154s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-BT3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-BT3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028477s ]
SELECT `id` FROM `stock` WHERE `id` <> 64087882 AND `partno` = '25-901-2.5-bar/psi-G1/4-BT3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.028736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858556 [ RunTime:0.028237s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64087880 LIMIT 5 [ RunTime:0.006479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087880 ORDER BY `minOrder` ASC [ RunTime:0.015409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64087880 ORDER BY `unit` DESC [ RunTime:0.002045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64087880 LIMIT 2 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087880 ORDER BY `minOrder` ASC [ RunTime:0.006871s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4-BP3' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007833s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4-BP3' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018297s ]
SELECT `id` FROM `stock` WHERE `id` <> 64087880 AND `partno` = '25-901-2.5-bar/psi-G1/4-BP3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.009953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18858555 [ RunTime:0.023158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64087842 LIMIT 5 [ RunTime:0.007138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087842 ORDER BY `minOrder` ASC [ RunTime:0.038223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64087842 ORDER BY `unit` DESC [ RunTime:0.001753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64087842 LIMIT 2 [ RunTime:0.020158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64087842 ORDER BY `minOrder` ASC [ RunTime:0.009205s ]
select * from pdf where partno='25-901-2.5-bar/psi-G1/4' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.040783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25-901-2.5-bar/psi-G1/4' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019533s ]
SELECT `id` FROM `stock` WHERE `id` <> 64087842 AND `partno` = '25-901-2.5-bar/psi-G1/4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.004296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17025629 [ RunTime:0.048957s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005889s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015155s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014305s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023594s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042771s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022376s ]
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 '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013719s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25-901-2.5-bar/psi-G1/4%' OR `brand` LIKE '25-901-2.5-bar/psi-G1/4%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.054327s ]