SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002700s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020777s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816289 LIMIT 5 [ RunTime:0.003100s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816289 ORDER BY `minOrder` ASC [ RunTime:0.000768s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.000826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18816289 ORDER BY `unit` DESC [ RunTime:0.001730s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003292s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18816289 LIMIT 2 [ RunTime:0.002292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18816289 ORDER BY `minOrder` ASC [ RunTime:0.001596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814822 LIMIT 5 [ RunTime:0.002512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814822 ORDER BY `minOrder` ASC [ RunTime:0.009400s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18814822 ORDER BY `unit` DESC [ RunTime:0.001783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18814822 LIMIT 2 [ RunTime:0.006933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18814822 ORDER BY `minOrder` ASC [ RunTime:0.007635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017421 LIMIT 5 [ RunTime:0.009158s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017421 ORDER BY `minOrder` ASC [ RunTime:0.018422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17017421 ORDER BY `unit` DESC [ RunTime:0.008604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17017421 LIMIT 2 [ RunTime:0.007334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17017421 ORDER BY `minOrder` ASC [ RunTime:0.003329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231830 LIMIT 5 [ RunTime:0.011602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231830 ORDER BY `minOrder` ASC [ RunTime:0.002039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231830 ORDER BY `unit` DESC [ RunTime:0.009208s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231830 LIMIT 2 [ RunTime:0.002224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231830 ORDER BY `minOrder` ASC [ RunTime:0.013364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231829 LIMIT 5 [ RunTime:0.002541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231829 ORDER BY `minOrder` ASC [ RunTime:0.001944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231829 ORDER BY `unit` DESC [ RunTime:0.020604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231829 LIMIT 2 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231829 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231553 LIMIT 5 [ RunTime:0.006090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231553 ORDER BY `minOrder` ASC [ RunTime:0.022753s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231553 ORDER BY `unit` DESC [ RunTime:0.013127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231553 LIMIT 2 [ RunTime:0.026153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231553 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231361 LIMIT 5 [ RunTime:0.004124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231361 ORDER BY `minOrder` ASC [ RunTime:0.008906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231361 ORDER BY `unit` DESC [ RunTime:0.011730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231361 LIMIT 2 [ RunTime:0.012110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231361 ORDER BY `minOrder` ASC [ RunTime:0.005167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231232 LIMIT 5 [ RunTime:0.011421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231232 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15231232 ORDER BY `unit` DESC [ RunTime:0.004681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15231232 LIMIT 2 [ RunTime:0.014167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15231232 ORDER BY `minOrder` ASC [ RunTime:0.018587s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022655s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861219 LIMIT 5 [ RunTime:0.005547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861219 ORDER BY `minOrder` ASC [ RunTime:0.008734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861219 ORDER BY `unit` DESC [ RunTime:0.021733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861219 LIMIT 2 [ RunTime:0.027735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861219 ORDER BY `minOrder` ASC [ RunTime:0.010656s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-RCP-ST8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.022722s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-RCP-ST8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.037806s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861219 AND `partno` = 'PGE20-150PSIG-1-2-DL-RCP-ST8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.017345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861185 LIMIT 5 [ RunTime:0.034369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861185 ORDER BY `minOrder` ASC [ RunTime:0.024653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861185 ORDER BY `unit` DESC [ RunTime:0.018871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861185 LIMIT 2 [ RunTime:0.017034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861185 ORDER BY `minOrder` ASC [ RunTime:0.003358s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-RCP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.024713s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-RCP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.031458s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861185 AND `partno` = 'PGE20-150PSIG-1-2-DL-RCP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.018705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18816289 [ RunTime:0.064731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861138 LIMIT 5 [ RunTime:0.031534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861138 ORDER BY `minOrder` ASC [ RunTime:0.056050s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861138 ORDER BY `unit` DESC [ RunTime:0.029449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861138 LIMIT 2 [ RunTime:0.009851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861138 ORDER BY `minOrder` ASC [ RunTime:0.010310s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-ST8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.028387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-ST8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007486s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861138 AND `partno` = 'PGE20-150PSIG-1-2-DL-ST8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.003396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861099 LIMIT 5 [ RunTime:0.020002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861099 ORDER BY `minOrder` ASC [ RunTime:0.005358s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861099 ORDER BY `unit` DESC [ RunTime:0.003772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861099 LIMIT 2 [ RunTime:0.008690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861099 ORDER BY `minOrder` ASC [ RunTime:0.019269s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.013190s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007312s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861099 AND `partno` = 'PGE20-150PSIG-1-2-DL-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.006270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231830 [ RunTime:0.005985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861051 LIMIT 5 [ RunTime:0.009081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861051 ORDER BY `minOrder` ASC [ RunTime:0.008446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861051 ORDER BY `unit` DESC [ RunTime:0.005608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861051 LIMIT 2 [ RunTime:0.014969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861051 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-RCP-ST8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.001267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-RCP-ST8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011162s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861051 AND `partno` = 'PGE20-150PSIG-1-2-DL-RCP-ST8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.045271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57861019 LIMIT 5 [ RunTime:0.014925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861019 ORDER BY `minOrder` ASC [ RunTime:0.024266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57861019 ORDER BY `unit` DESC [ RunTime:0.013932s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57861019 LIMIT 2 [ RunTime:0.031519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57861019 ORDER BY `minOrder` ASC [ RunTime:0.009490s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.002252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011340s ]
SELECT `id` FROM `stock` WHERE `id` <> 57861019 AND `partno` = 'PGE20-150PSIG-1-2-DL-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.002082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231829 [ RunTime:0.000799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57860969 LIMIT 5 [ RunTime:0.000863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860969 ORDER BY `minOrder` ASC [ RunTime:0.006718s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57860969 ORDER BY `unit` DESC [ RunTime:0.006755s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57860969 LIMIT 2 [ RunTime:0.015838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860969 ORDER BY `minOrder` ASC [ RunTime:0.016467s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL-ST8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.007528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL-ST8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.011753s ]
SELECT `id` FROM `stock` WHERE `id` <> 57860969 AND `partno` = 'PGE20-150PSIG-1-2-DL-ST8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.010636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57860936 LIMIT 5 [ RunTime:0.013719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860936 ORDER BY `minOrder` ASC [ RunTime:0.016721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57860936 ORDER BY `unit` DESC [ RunTime:0.015207s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57860936 LIMIT 2 [ RunTime:0.018682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860936 ORDER BY `minOrder` ASC [ RunTime:0.005149s ]
select * from pdf where partno='PGE20-150PSIG-1-2-DL' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.029201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-DL' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012523s ]
SELECT `id` FROM `stock` WHERE `id` <> 57860936 AND `partno` = 'PGE20-150PSIG-1-2-DL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.032433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17017421 [ RunTime:0.002902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57860811 LIMIT 5 [ RunTime:0.003495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860811 ORDER BY `minOrder` ASC [ RunTime:0.014766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57860811 ORDER BY `unit` DESC [ RunTime:0.017441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57860811 LIMIT 2 [ RunTime:0.034596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860811 ORDER BY `minOrder` ASC [ RunTime:0.022742s ]
select * from pdf where partno='PGE20-150PSIG-1-2-RCP-ST8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-RCP-ST8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021653s ]
SELECT `id` FROM `stock` WHERE `id` <> 57860811 AND `partno` = 'PGE20-150PSIG-1-2-RCP-ST8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.029581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57860755 LIMIT 5 [ RunTime:0.007612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860755 ORDER BY `minOrder` ASC [ RunTime:0.026755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57860755 ORDER BY `unit` DESC [ RunTime:0.015934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57860755 LIMIT 2 [ RunTime:0.013730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860755 ORDER BY `minOrder` ASC [ RunTime:0.003446s ]
select * from pdf where partno='PGE20-150PSIG-1-2-RCP-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.021226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-RCP-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023578s ]
SELECT `id` FROM `stock` WHERE `id` <> 57860755 AND `partno` = 'PGE20-150PSIG-1-2-RCP-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.013812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18814822 [ RunTime:0.010106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57860194 LIMIT 5 [ RunTime:0.026568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860194 ORDER BY `minOrder` ASC [ RunTime:0.015755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57860194 ORDER BY `unit` DESC [ RunTime:0.028528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57860194 LIMIT 2 [ RunTime:0.015687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57860194 ORDER BY `minOrder` ASC [ RunTime:0.010149s ]
select * from pdf where partno='PGE20-150PSIG-1-2-ST8-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.003697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-ST8-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.019204s ]
SELECT `id` FROM `stock` WHERE `id` <> 57860194 AND `partno` = 'PGE20-150PSIG-1-2-ST8-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.011474s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57859787 LIMIT 5 [ RunTime:0.012589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859787 ORDER BY `minOrder` ASC [ RunTime:0.034171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57859787 ORDER BY `unit` DESC [ RunTime:0.020609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57859787 LIMIT 2 [ RunTime:0.034589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859787 ORDER BY `minOrder` ASC [ RunTime:0.015624s ]
select * from pdf where partno='PGE20-150PSIG-1-2-CC' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.028437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-CC' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.028313s ]
SELECT `id` FROM `stock` WHERE `id` <> 57859787 AND `partno` = 'PGE20-150PSIG-1-2-CC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.059725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231553 [ RunTime:0.037028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57859410 LIMIT 5 [ RunTime:0.039103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859410 ORDER BY `minOrder` ASC [ RunTime:0.053498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57859410 ORDER BY `unit` DESC [ RunTime:0.039024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57859410 LIMIT 2 [ RunTime:0.052607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859410 ORDER BY `minOrder` ASC [ RunTime:0.015049s ]
select * from pdf where partno='PGE20-150PSIG-1-2-RCP-ST8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.076675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-RCP-ST8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.067252s ]
SELECT `id` FROM `stock` WHERE `id` <> 57859410 AND `partno` = 'PGE20-150PSIG-1-2-RCP-ST8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.049585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57859120 LIMIT 5 [ RunTime:0.029514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859120 ORDER BY `minOrder` ASC [ RunTime:0.034496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57859120 ORDER BY `unit` DESC [ RunTime:0.032961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57859120 LIMIT 2 [ RunTime:0.040227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57859120 ORDER BY `minOrder` ASC [ RunTime:0.012440s ]
select * from pdf where partno='PGE20-150PSIG-1-2-RCP' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.027025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-RCP' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.053722s ]
SELECT `id` FROM `stock` WHERE `id` <> 57859120 AND `partno` = 'PGE20-150PSIG-1-2-RCP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.070443s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231361 [ RunTime:0.031634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57855417 LIMIT 5 [ RunTime:0.053224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57855417 ORDER BY `minOrder` ASC [ RunTime:0.036800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57855417 ORDER BY `unit` DESC [ RunTime:0.055041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57855417 LIMIT 2 [ RunTime:0.019011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57855417 ORDER BY `minOrder` ASC [ RunTime:0.011021s ]
select * from pdf where partno='PGE20-150PSIG-1-2-ST8' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.050417s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2-ST8' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.045786s ]
SELECT `id` FROM `stock` WHERE `id` <> 57855417 AND `partno` = 'PGE20-150PSIG-1-2-ST8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.043403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57854344 LIMIT 5 [ RunTime:0.006170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57854344 ORDER BY `minOrder` ASC [ RunTime:0.002507s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57854344 ORDER BY `unit` DESC [ RunTime:0.015183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57854344 LIMIT 2 [ RunTime:0.017086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57854344 ORDER BY `minOrder` ASC [ RunTime:0.008559s ]
select * from pdf where partno='PGE20-150PSIG-1-2' and brandshort='NOSHOK, Inc.' limit 1 [ RunTime:0.010966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PGE20-150PSIG-1-2' OR `brand` LIKE 'NOSHOK, Inc.%' ) ) LIMIT 1 [ RunTime:0.032021s ]
SELECT `id` FROM `stock` WHERE `id` <> 57854344 AND `partno` = 'PGE20-150PSIG-1-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%noshok, inc.%' ) [ RunTime:0.060453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15231232 [ RunTime:0.008524s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024658s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018734s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017327s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021841s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020997s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020047s ]
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 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007393s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'PGE20-150PSIG-1-2%' OR `brand` LIKE 'PGE20-150PSIG-1-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018271s ]