SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002209s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020951s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11431622 LIMIT 5 [ RunTime:0.010721s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11431622 ORDER BY `minOrder` ASC [ RunTime:0.034030s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002574s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11431622 ORDER BY `unit` DESC [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11431622 LIMIT 2 [ RunTime:0.039997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11431622 ORDER BY `minOrder` ASC [ RunTime:0.012167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12539273 LIMIT 5 [ RunTime:0.014781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12539273 ORDER BY `minOrder` ASC [ RunTime:0.012494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12539273 ORDER BY `unit` DESC [ RunTime:0.062972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12539273 LIMIT 2 [ RunTime:0.018348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12539273 ORDER BY `minOrder` ASC [ RunTime:0.021287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12537161 LIMIT 5 [ RunTime:0.049770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537161 ORDER BY `minOrder` ASC [ RunTime:0.106694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12537161 ORDER BY `unit` DESC [ RunTime:0.052457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12537161 LIMIT 2 [ RunTime:0.049218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537161 ORDER BY `minOrder` ASC [ RunTime:0.010494s ]
select * from pdf where partno='GFTSAX-19' and brandshort='Curtis Industries' limit 1 [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12537131 LIMIT 5 [ RunTime:0.068061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537131 ORDER BY `minOrder` ASC [ RunTime:0.128657s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12537131 ORDER BY `unit` DESC [ RunTime:0.071775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12537131 LIMIT 2 [ RunTime:0.075708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12537131 ORDER BY `minOrder` ASC [ RunTime:0.031253s ]
select * from pdf where partno='GFTSAX-18' and brandshort='Curtis Industries' limit 1 [ RunTime:0.024077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433069 LIMIT 5 [ RunTime:0.031671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433069 ORDER BY `minOrder` ASC [ RunTime:0.038313s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11433069 ORDER BY `unit` DESC [ RunTime:0.063167s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11433069 LIMIT 2 [ RunTime:0.027031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433069 ORDER BY `minOrder` ASC [ RunTime:0.013956s ]
select * from pdf where partno='GFTSAX-1' and brandshort='Curtis Industries' limit 1 [ RunTime:0.026944s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430214 LIMIT 5 [ RunTime:0.055618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430214 ORDER BY `minOrder` ASC [ RunTime:0.034516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11430214 ORDER BY `unit` DESC [ RunTime:0.041606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11430214 LIMIT 2 [ RunTime:0.036834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430214 ORDER BY `minOrder` ASC [ RunTime:0.005896s ]
select * from pdf where partno='GFTSAX-17' and brandshort='Curtis Industries' limit 1 [ RunTime:0.025608s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430189 LIMIT 5 [ RunTime:0.014863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430189 ORDER BY `minOrder` ASC [ RunTime:0.003127s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11430189 ORDER BY `unit` DESC [ RunTime:0.005713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11430189 LIMIT 2 [ RunTime:0.010736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430189 ORDER BY `minOrder` ASC [ RunTime:0.002604s ]
select * from pdf where partno='GFTSAX-16' and brandshort='Curtis Industries' limit 1 [ RunTime:0.021435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430123 LIMIT 5 [ RunTime:0.013135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430123 ORDER BY `minOrder` ASC [ RunTime:0.026115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11430123 ORDER BY `unit` DESC [ RunTime:0.001319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11430123 LIMIT 2 [ RunTime:0.018376s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11430123 ORDER BY `minOrder` ASC [ RunTime:0.007250s ]
select * from pdf where partno='GFTSAX-14' and brandshort='Curtis Industries' limit 1 [ RunTime:0.015203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11429982 LIMIT 5 [ RunTime:0.010315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11429982 ORDER BY `minOrder` ASC [ RunTime:0.015422s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11429982 ORDER BY `unit` DESC [ RunTime:0.013501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11429982 LIMIT 2 [ RunTime:0.004282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11429982 ORDER BY `minOrder` ASC [ RunTime:0.010640s ]
select * from pdf where partno='GFTSAX-11' and brandshort='Curtis Industries' limit 1 [ RunTime:0.003318s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026860s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60428767 LIMIT 5 [ RunTime:0.009353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428767 ORDER BY `minOrder` ASC [ RunTime:0.019703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60428767 ORDER BY `unit` DESC [ RunTime:0.002181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60428767 LIMIT 2 [ RunTime:0.016643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428767 ORDER BY `minOrder` ASC [ RunTime:0.010697s ]
select * from pdf where partno='GFTSAX-10' and brandshort='Curtis Industries' limit 1 [ RunTime:0.007062s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002420s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-10' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.012645s ]
SELECT `id` FROM `stock` WHERE `id` <> 60428767 AND `partno` = 'GFTSAX-10' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.003976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11431622 [ RunTime:0.006345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60428774 LIMIT 5 [ RunTime:0.007756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428774 ORDER BY `minOrder` ASC [ RunTime:0.013216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60428774 ORDER BY `unit` DESC [ RunTime:0.007354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60428774 LIMIT 2 [ RunTime:0.013738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60428774 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='GFTSAX-12' and brandshort='Curtis Industries' limit 1 [ RunTime:0.023225s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-12' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.035643s ]
SELECT `id` FROM `stock` WHERE `id` <> 60428774 AND `partno` = 'GFTSAX-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.019206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12539273 [ RunTime:0.014552s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60467226 LIMIT 5 [ RunTime:0.014771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467226 ORDER BY `minOrder` ASC [ RunTime:0.033279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60467226 ORDER BY `unit` DESC [ RunTime:0.031769s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60467226 LIMIT 2 [ RunTime:0.012751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467226 ORDER BY `minOrder` ASC [ RunTime:0.007600s ]
select * from pdf where partno='GFTSAX-19' and brandshort='Curtis Industries' limit 1 [ RunTime:0.006241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-19' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.016357s ]
SELECT `id` FROM `stock` WHERE `id` <> 60467226 AND `partno` = 'GFTSAX-19' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.032736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12537161 [ RunTime:0.035847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60467168 LIMIT 5 [ RunTime:0.024087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467168 ORDER BY `minOrder` ASC [ RunTime:0.035446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60467168 ORDER BY `unit` DESC [ RunTime:0.015395s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60467168 LIMIT 2 [ RunTime:0.029499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467168 ORDER BY `minOrder` ASC [ RunTime:0.023068s ]
select * from pdf where partno='GFTSAX-18' and brandshort='Curtis Industries' limit 1 [ RunTime:0.007967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-18' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.010028s ]
SELECT `id` FROM `stock` WHERE `id` <> 60467168 AND `partno` = 'GFTSAX-18' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.026653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12537131 [ RunTime:0.029056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60467096 LIMIT 5 [ RunTime:0.052296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467096 ORDER BY `minOrder` ASC [ RunTime:0.014246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60467096 ORDER BY `unit` DESC [ RunTime:0.018137s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60467096 LIMIT 2 [ RunTime:0.025424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467096 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
select * from pdf where partno='GFTSAX-17' and brandshort='Curtis Industries' limit 1 [ RunTime:0.001539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-17' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.023196s ]
SELECT `id` FROM `stock` WHERE `id` <> 60467096 AND `partno` = 'GFTSAX-17' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.028081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430214 [ RunTime:0.032499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60467005 LIMIT 5 [ RunTime:0.014256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467005 ORDER BY `minOrder` ASC [ RunTime:0.008877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60467005 ORDER BY `unit` DESC [ RunTime:0.017058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60467005 LIMIT 2 [ RunTime:0.012950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60467005 ORDER BY `minOrder` ASC [ RunTime:0.020377s ]
select * from pdf where partno='GFTSAX-16' and brandshort='Curtis Industries' limit 1 [ RunTime:0.007895s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-16' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.016061s ]
SELECT `id` FROM `stock` WHERE `id` <> 60467005 AND `partno` = 'GFTSAX-16' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.064818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430189 [ RunTime:0.066637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60466909 LIMIT 5 [ RunTime:0.016596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466909 ORDER BY `minOrder` ASC [ RunTime:0.051476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60466909 ORDER BY `unit` DESC [ RunTime:0.032780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60466909 LIMIT 2 [ RunTime:0.015928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466909 ORDER BY `minOrder` ASC [ RunTime:0.017726s ]
select * from pdf where partno='GFTSAX-15' and brandshort='Curtis Industries' limit 1 [ RunTime:0.028096s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-15' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.000948s ]
SELECT `id` FROM `stock` WHERE `id` <> 60466909 AND `partno` = 'GFTSAX-15' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.018505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60466794 LIMIT 5 [ RunTime:0.004477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466794 ORDER BY `minOrder` ASC [ RunTime:0.027020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60466794 ORDER BY `unit` DESC [ RunTime:0.029892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60466794 LIMIT 2 [ RunTime:0.009085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466794 ORDER BY `minOrder` ASC [ RunTime:0.008756s ]
select * from pdf where partno='GFTSAX-14' and brandshort='Curtis Industries' limit 1 [ RunTime:0.068080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-14' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.031361s ]
SELECT `id` FROM `stock` WHERE `id` <> 60466794 AND `partno` = 'GFTSAX-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.085735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11430123 [ RunTime:0.112376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60466669 LIMIT 5 [ RunTime:0.019741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466669 ORDER BY `minOrder` ASC [ RunTime:0.046905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60466669 ORDER BY `unit` DESC [ RunTime:0.019041s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60466669 LIMIT 2 [ RunTime:0.015313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466669 ORDER BY `minOrder` ASC [ RunTime:0.041921s ]
select * from pdf where partno='GFTSAX-13' and brandshort='Curtis Industries' limit 1 [ RunTime:0.046250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-13' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.019106s ]
SELECT `id` FROM `stock` WHERE `id` <> 60466669 AND `partno` = 'GFTSAX-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.031962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60466390 LIMIT 5 [ RunTime:0.058828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466390 ORDER BY `minOrder` ASC [ RunTime:0.008144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60466390 ORDER BY `unit` DESC [ RunTime:0.001334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60466390 LIMIT 2 [ RunTime:0.010848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60466390 ORDER BY `minOrder` ASC [ RunTime:0.024936s ]
select * from pdf where partno='GFTSAX-11' and brandshort='Curtis Industries' limit 1 [ RunTime:0.005276s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-11' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.012478s ]
SELECT `id` FROM `stock` WHERE `id` <> 60466390 AND `partno` = 'GFTSAX-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.016444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11429982 [ RunTime:0.005649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60439025 LIMIT 5 [ RunTime:0.024482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60439025 ORDER BY `minOrder` ASC [ RunTime:0.064768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60439025 ORDER BY `unit` DESC [ RunTime:0.055176s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60439025 LIMIT 2 [ RunTime:0.054683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60439025 ORDER BY `minOrder` ASC [ RunTime:0.020289s ]
select * from pdf where partno='GFTSAX-1' and brandshort='Curtis Industries' limit 1 [ RunTime:0.001038s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GFTSAX-1' OR `brand` LIKE 'Curtis Industries%' ) ) LIMIT 1 [ RunTime:0.062268s ]
SELECT `id` FROM `stock` WHERE `id` <> 60439025 AND `partno` = 'GFTSAX-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%curtis industries%' ) [ RunTime:0.023645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433069 [ RunTime:0.034228s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026526s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020844s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028763s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032042s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083442s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037943s ]
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 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026635s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'GFTSAX-1%' OR `brand` LIKE 'GFTSAX-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.023708s ]