SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001823s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040315s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649553 LIMIT 5 [ RunTime:0.010323s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649553 ORDER BY `minOrder` ASC [ RunTime:0.006664s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649553 ORDER BY `unit` DESC [ RunTime:0.002187s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001030s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649553 LIMIT 2 [ RunTime:0.003658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649553 ORDER BY `minOrder` ASC [ RunTime:0.010588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982456 LIMIT 5 [ RunTime:0.007814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982456 ORDER BY `minOrder` ASC [ RunTime:0.008982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982456 ORDER BY `unit` DESC [ RunTime:0.028436s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982456 LIMIT 2 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982456 ORDER BY `minOrder` ASC [ RunTime:0.011676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982453 LIMIT 5 [ RunTime:0.012019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982453 ORDER BY `minOrder` ASC [ RunTime:0.016317s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18982453 ORDER BY `unit` DESC [ RunTime:0.027764s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18982453 LIMIT 2 [ RunTime:0.017898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18982453 ORDER BY `minOrder` ASC [ RunTime:0.012451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981260 LIMIT 5 [ RunTime:0.064150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981260 ORDER BY `minOrder` ASC [ RunTime:0.048032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18981260 ORDER BY `unit` DESC [ RunTime:0.037951s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18981260 LIMIT 2 [ RunTime:0.023569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18981260 ORDER BY `minOrder` ASC [ RunTime:0.028013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011024 LIMIT 5 [ RunTime:0.040699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011024 ORDER BY `minOrder` ASC [ RunTime:0.033176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17011024 ORDER BY `unit` DESC [ RunTime:0.052714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17011024 LIMIT 2 [ RunTime:0.037383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17011024 ORDER BY `minOrder` ASC [ RunTime:0.043231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266534 LIMIT 5 [ RunTime:0.014533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266534 ORDER BY `minOrder` ASC [ RunTime:0.005329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15266534 ORDER BY `unit` DESC [ RunTime:0.024434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15266534 LIMIT 2 [ RunTime:0.005643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15266534 ORDER BY `minOrder` ASC [ RunTime:0.005846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265041 LIMIT 5 [ RunTime:0.049987s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265041 ORDER BY `minOrder` ASC [ RunTime:0.030477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15265041 ORDER BY `unit` DESC [ RunTime:0.072567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15265041 LIMIT 2 [ RunTime:0.034055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15265041 ORDER BY `minOrder` ASC [ RunTime:0.011378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13525810 LIMIT 5 [ RunTime:0.040001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525810 ORDER BY `minOrder` ASC [ RunTime:0.027831s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13525810 ORDER BY `unit` DESC [ RunTime:0.025452s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13525810 LIMIT 2 [ RunTime:0.032134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13525810 ORDER BY `minOrder` ASC [ RunTime:0.000620s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014048s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006200s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986343 LIMIT 5 [ RunTime:0.014838s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986343 ORDER BY `minOrder` ASC [ RunTime:0.018370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986343 ORDER BY `unit` DESC [ RunTime:0.008172s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986343 LIMIT 2 [ RunTime:0.020335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986343 ORDER BY `minOrder` ASC [ RunTime:0.010710s ]
select * from pdf where partno='1036624' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001717s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036624' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007179s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986343 AND `partno` = '1036624' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.016199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15265041 [ RunTime:0.013417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57986152 LIMIT 5 [ RunTime:0.002335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986152 ORDER BY `minOrder` ASC [ RunTime:0.013660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57986152 ORDER BY `unit` DESC [ RunTime:0.013505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57986152 LIMIT 2 [ RunTime:0.009880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57986152 ORDER BY `minOrder` ASC [ RunTime:0.006865s ]
select * from pdf where partno='1036623' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036623' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025368s ]
SELECT `id` FROM `stock` WHERE `id` <> 57986152 AND `partno` = '1036623' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985694 LIMIT 5 [ RunTime:0.029952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985694 ORDER BY `minOrder` ASC [ RunTime:0.019404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985694 ORDER BY `unit` DESC [ RunTime:0.000812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985694 LIMIT 2 [ RunTime:0.034153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985694 ORDER BY `minOrder` ASC [ RunTime:0.010643s ]
select * from pdf where partno='1036622' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.014008s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036622' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030186s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985694 AND `partno` = '1036622' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982456 [ RunTime:0.014456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985369 LIMIT 5 [ RunTime:0.044825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985369 ORDER BY `minOrder` ASC [ RunTime:0.051272s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985369 ORDER BY `unit` DESC [ RunTime:0.021462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985369 LIMIT 2 [ RunTime:0.013804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985369 ORDER BY `minOrder` ASC [ RunTime:0.003311s ]
select * from pdf where partno='1036621' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036621' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020541s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985369 AND `partno` = '1036621' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18982453 [ RunTime:0.021991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57985368 LIMIT 5 [ RunTime:0.015366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985368 ORDER BY `minOrder` ASC [ RunTime:0.008582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57985368 ORDER BY `unit` DESC [ RunTime:0.002330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57985368 LIMIT 2 [ RunTime:0.020063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57985368 ORDER BY `minOrder` ASC [ RunTime:0.016987s ]
select * from pdf where partno='1036620' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.017054s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036620' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.017040s ]
SELECT `id` FROM `stock` WHERE `id` <> 57985368 AND `partno` = '1036620' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15266534 [ RunTime:0.007333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57983328 LIMIT 5 [ RunTime:0.039807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983328 ORDER BY `minOrder` ASC [ RunTime:0.052016s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57983328 ORDER BY `unit` DESC [ RunTime:0.048633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57983328 LIMIT 2 [ RunTime:0.072863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57983328 ORDER BY `minOrder` ASC [ RunTime:0.023657s ]
select * from pdf where partno='1036625' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.045243s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036625' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.097653s ]
SELECT `id` FROM `stock` WHERE `id` <> 57983328 AND `partno` = '1036625' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.140669s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18981260 [ RunTime:0.049380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53724284 LIMIT 5 [ RunTime:0.006672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53724284 ORDER BY `minOrder` ASC [ RunTime:0.012064s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53724284 ORDER BY `unit` DESC [ RunTime:0.007356s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53724284 LIMIT 2 [ RunTime:0.002707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53724284 ORDER BY `minOrder` ASC [ RunTime:0.028872s ]
select * from pdf where partno='1036620000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011087s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036620000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.019730s ]
SELECT `id` FROM `stock` WHERE `id` <> 53724284 AND `partno` = '1036620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.026579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649553 [ RunTime:0.013797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38514182 LIMIT 5 [ RunTime:0.029679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38514182 ORDER BY `minOrder` ASC [ RunTime:0.023777s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38514182 ORDER BY `unit` DESC [ RunTime:0.034011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38514182 LIMIT 2 [ RunTime:0.021565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38514182 ORDER BY `minOrder` ASC [ RunTime:0.011674s ]
select * from pdf where partno='1036628' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.045052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1036628' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.034111s ]
SELECT `id` FROM `stock` WHERE `id` <> 38514182 AND `partno` = '1036628' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.042019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17011024 [ RunTime:0.031712s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015907s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045477s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029810s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038627s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018380s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017622s ]
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 '103662%' OR `brand` LIKE '103662%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033211s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '103662%' OR `brand` LIKE '103662%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.027585s ]