SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002871s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036314s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265489 LIMIT 5 [ RunTime:0.023843s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265489 ORDER BY `minOrder` ASC [ RunTime:0.073366s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265489 ORDER BY `unit` DESC [ RunTime:0.054538s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.034503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265489 LIMIT 2 [ RunTime:0.028127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265489 ORDER BY `minOrder` ASC [ RunTime:0.028516s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265676 LIMIT 5 [ RunTime:0.010244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265676 ORDER BY `minOrder` ASC [ RunTime:0.035419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19265676 ORDER BY `unit` DESC [ RunTime:0.032500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19265676 LIMIT 2 [ RunTime:0.039985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19265676 ORDER BY `minOrder` ASC [ RunTime:0.012128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287723 LIMIT 5 [ RunTime:0.049972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287723 ORDER BY `minOrder` ASC [ RunTime:0.054268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19287723 ORDER BY `unit` DESC [ RunTime:0.054077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19287723 LIMIT 2 [ RunTime:0.058251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287723 ORDER BY `minOrder` ASC [ RunTime:0.051693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287722 LIMIT 5 [ RunTime:0.044421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287722 ORDER BY `minOrder` ASC [ RunTime:0.199276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19287722 ORDER BY `unit` DESC [ RunTime:0.112943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19287722 LIMIT 2 [ RunTime:0.063938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287722 ORDER BY `minOrder` ASC [ RunTime:0.102212s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287721 LIMIT 5 [ RunTime:0.029166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287721 ORDER BY `minOrder` ASC [ RunTime:0.109621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19287721 ORDER BY `unit` DESC [ RunTime:0.055553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19287721 LIMIT 2 [ RunTime:0.050758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287721 ORDER BY `minOrder` ASC [ RunTime:0.006159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287720 LIMIT 5 [ RunTime:0.036971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287720 ORDER BY `minOrder` ASC [ RunTime:0.120175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19287720 ORDER BY `unit` DESC [ RunTime:0.036742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19287720 LIMIT 2 [ RunTime:0.084680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19287720 ORDER BY `minOrder` ASC [ RunTime:0.048020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12071277 LIMIT 5 [ RunTime:0.081910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12071277 ORDER BY `minOrder` ASC [ RunTime:0.034019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12071277 ORDER BY `unit` DESC [ RunTime:0.040251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12071277 LIMIT 2 [ RunTime:0.054134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12071277 ORDER BY `minOrder` ASC [ RunTime:0.032719s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046703s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082056 LIMIT 5 [ RunTime:0.019687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082056 ORDER BY `minOrder` ASC [ RunTime:0.010498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082056 ORDER BY `unit` DESC [ RunTime:0.013654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082056 LIMIT 2 [ RunTime:0.013065s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082056 ORDER BY `minOrder` ASC [ RunTime:0.021008s ]
select * from pdf where partno='us-101' and brandshort='brainboxes' limit 1 [ RunTime:0.012667s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'us-101' OR `brand` LIKE 'brainboxes%' ) ) LIMIT 1 [ RunTime:0.010342s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082056 AND `partno` = 'us-101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brainboxes%' ) [ RunTime:0.034117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265489 [ RunTime:0.039045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082057 LIMIT 5 [ RunTime:0.008132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082057 ORDER BY `minOrder` ASC [ RunTime:0.041740s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082057 ORDER BY `unit` DESC [ RunTime:0.046995s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082057 LIMIT 2 [ RunTime:0.010077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082057 ORDER BY `minOrder` ASC [ RunTime:0.005628s ]
select * from pdf where partno='us-159' and brandshort='brainboxes' limit 1 [ RunTime:0.028830s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'us-159' OR `brand` LIKE 'brainboxes%' ) ) LIMIT 1 [ RunTime:0.025324s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082057 AND `partno` = 'us-159' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brainboxes%' ) [ RunTime:0.041955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265676 [ RunTime:0.048008s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51087972 LIMIT 5 [ RunTime:0.039466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087972 ORDER BY `minOrder` ASC [ RunTime:0.027160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51087972 ORDER BY `unit` DESC [ RunTime:0.068844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51087972 LIMIT 2 [ RunTime:0.055247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51087972 ORDER BY `minOrder` ASC [ RunTime:0.018149s ]
select * from pdf where partno='us-11' and brandshort='altech' limit 1 [ RunTime:0.047375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'us-11' OR `brand` LIKE 'altech%' ) ) LIMIT 1 [ RunTime:0.038631s ]
SELECT `id` FROM `stock` WHERE `id` <> 51087972 AND `partno` = 'us-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech%' ) [ RunTime:0.059778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287720 [ RunTime:0.085845s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438045 LIMIT 5 [ RunTime:0.019855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438045 ORDER BY `minOrder` ASC [ RunTime:0.068060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438045 ORDER BY `unit` DESC [ RunTime:0.048454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438045 LIMIT 2 [ RunTime:0.068487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438045 ORDER BY `minOrder` ASC [ RunTime:0.004238s ]
select * from pdf where partno='US-101' and brandshort='Brainboxes' limit 1 [ RunTime:0.046873s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-101' OR `brand` LIKE 'Brainboxes%' ) ) LIMIT 1 [ RunTime:0.020648s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438045 AND `partno` = 'US-101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brainboxes%' ) [ RunTime:0.043831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265489 [ RunTime:0.019656s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57438542 LIMIT 5 [ RunTime:0.047923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438542 ORDER BY `minOrder` ASC [ RunTime:0.068439s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57438542 ORDER BY `unit` DESC [ RunTime:0.023591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57438542 LIMIT 2 [ RunTime:0.030393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57438542 ORDER BY `minOrder` ASC [ RunTime:0.015339s ]
select * from pdf where partno='US-159' and brandshort='Brainboxes' limit 1 [ RunTime:0.028942s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-159' OR `brand` LIKE 'Brainboxes%' ) ) LIMIT 1 [ RunTime:0.065822s ]
SELECT `id` FROM `stock` WHERE `id` <> 57438542 AND `partno` = 'US-159' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brainboxes%' ) [ RunTime:0.049370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19265676 [ RunTime:0.000591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57315431 LIMIT 5 [ RunTime:0.018104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57315431 ORDER BY `minOrder` ASC [ RunTime:0.017955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57315431 ORDER BY `unit` DESC [ RunTime:0.026493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57315431 LIMIT 2 [ RunTime:0.030632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57315431 ORDER BY `minOrder` ASC [ RunTime:0.001954s ]
select * from pdf where partno='US-1' and brandshort='Altech Corporation' limit 1 [ RunTime:0.033929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-1' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.033762s ]
SELECT `id` FROM `stock` WHERE `id` <> 57315431 AND `partno` = 'US-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.071642s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12071277 [ RunTime:0.026940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51437709 LIMIT 5 [ RunTime:0.032444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437709 ORDER BY `minOrder` ASC [ RunTime:0.078561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51437709 ORDER BY `unit` DESC [ RunTime:0.034410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51437709 LIMIT 2 [ RunTime:0.088982s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437709 ORDER BY `minOrder` ASC [ RunTime:0.057479s ]
select * from pdf where partno='US-14' and brandshort='Altech Corporation' limit 1 [ RunTime:0.040233s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-14' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.067521s ]
SELECT `id` FROM `stock` WHERE `id` <> 51437709 AND `partno` = 'US-14' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.035756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287723 [ RunTime:0.048990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51437708 LIMIT 5 [ RunTime:0.018069s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437708 ORDER BY `minOrder` ASC [ RunTime:0.069029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51437708 ORDER BY `unit` DESC [ RunTime:0.033981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51437708 LIMIT 2 [ RunTime:0.040075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437708 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
select * from pdf where partno='US-13' and brandshort='Altech Corporation' limit 1 [ RunTime:0.023160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-13' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.021874s ]
SELECT `id` FROM `stock` WHERE `id` <> 51437708 AND `partno` = 'US-13' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.007090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287722 [ RunTime:0.037644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51437707 LIMIT 5 [ RunTime:0.032237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437707 ORDER BY `minOrder` ASC [ RunTime:0.020293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51437707 ORDER BY `unit` DESC [ RunTime:0.022039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51437707 LIMIT 2 [ RunTime:0.052011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437707 ORDER BY `minOrder` ASC [ RunTime:0.032611s ]
select * from pdf where partno='US-12' and brandshort='Altech Corporation' limit 1 [ RunTime:0.036209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-12' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.105836s ]
SELECT `id` FROM `stock` WHERE `id` <> 51437707 AND `partno` = 'US-12' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.099654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287721 [ RunTime:0.065627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51437706 LIMIT 5 [ RunTime:0.055714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437706 ORDER BY `minOrder` ASC [ RunTime:0.093041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51437706 ORDER BY `unit` DESC [ RunTime:0.021624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51437706 LIMIT 2 [ RunTime:0.031929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51437706 ORDER BY `minOrder` ASC [ RunTime:0.031455s ]
select * from pdf where partno='US-11' and brandshort='Altech Corporation' limit 1 [ RunTime:0.053251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-11' OR `brand` LIKE 'Altech Corporation%' ) ) LIMIT 1 [ RunTime:0.044038s ]
SELECT `id` FROM `stock` WHERE `id` <> 51437706 AND `partno` = 'US-11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%altech corporation%' ) [ RunTime:0.083005s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19287720 [ RunTime:0.050120s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32559557 LIMIT 5 [ RunTime:0.043743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32559557 ORDER BY `minOrder` ASC [ RunTime:0.053902s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32559557 ORDER BY `unit` DESC [ RunTime:0.014754s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32559557 LIMIT 2 [ RunTime:0.009281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32559557 ORDER BY `minOrder` ASC [ RunTime:0.020883s ]
select * from pdf where partno='US-10315-030' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.044023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-10315-030' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.076909s ]
SELECT `id` FROM `stock` WHERE `id` <> 32559557 AND `partno` = 'US-10315-030' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.053825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32366429 LIMIT 5 [ RunTime:0.011454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32366429 ORDER BY `minOrder` ASC [ RunTime:0.016990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32366429 ORDER BY `unit` DESC [ RunTime:0.080171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32366429 LIMIT 2 [ RunTime:0.082283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32366429 ORDER BY `minOrder` ASC [ RunTime:0.016309s ]
select * from pdf where partno='US-12481-CARD' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.098949s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'US-12481-CARD' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.063628s ]
SELECT `id` FROM `stock` WHERE `id` <> 32366429 AND `partno` = 'US-12481-CARD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.023097s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018357s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051214s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047138s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.074668s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037936s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061618s ]
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 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038400s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'US-1%' OR `brand` LIKE 'US-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.049646s ]