SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002876s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045847s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.027626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651335 LIMIT 5 [ RunTime:0.029225s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651335 ORDER BY `minOrder` ASC [ RunTime:0.011352s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651335 ORDER BY `unit` DESC [ RunTime:0.015235s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651335 LIMIT 2 [ RunTime:0.024734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651335 ORDER BY `minOrder` ASC [ RunTime:0.049215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637572 LIMIT 5 [ RunTime:0.006081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637572 ORDER BY `minOrder` ASC [ RunTime:0.015956s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637572 ORDER BY `unit` DESC [ RunTime:0.010248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637572 LIMIT 2 [ RunTime:0.025657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637572 ORDER BY `minOrder` ASC [ RunTime:0.011475s ]
select * from pdf where partno='2754000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637571 LIMIT 5 [ RunTime:0.044447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637571 ORDER BY `minOrder` ASC [ RunTime:0.052853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637571 ORDER BY `unit` DESC [ RunTime:0.005470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637571 LIMIT 2 [ RunTime:0.077867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637571 ORDER BY `minOrder` ASC [ RunTime:0.025492s ]
select * from pdf where partno='2754050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310972 LIMIT 5 [ RunTime:0.066272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310972 ORDER BY `minOrder` ASC [ RunTime:0.044732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310972 ORDER BY `unit` DESC [ RunTime:0.039125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310972 LIMIT 2 [ RunTime:0.031292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310972 ORDER BY `minOrder` ASC [ RunTime:0.046465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310971 LIMIT 5 [ RunTime:0.053217s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310971 ORDER BY `minOrder` ASC [ RunTime:0.046484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310971 ORDER BY `unit` DESC [ RunTime:0.039928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310971 LIMIT 2 [ RunTime:0.019668s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310971 ORDER BY `minOrder` ASC [ RunTime:0.028375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308135 LIMIT 5 [ RunTime:0.046667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308135 ORDER BY `minOrder` ASC [ RunTime:0.045918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17308135 ORDER BY `unit` DESC [ RunTime:0.039162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17308135 LIMIT 2 [ RunTime:0.058788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308135 ORDER BY `minOrder` ASC [ RunTime:0.054878s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308134 LIMIT 5 [ RunTime:0.050493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308134 ORDER BY `minOrder` ASC [ RunTime:0.054944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17308134 ORDER BY `unit` DESC [ RunTime:0.059626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17308134 LIMIT 2 [ RunTime:0.024445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17308134 ORDER BY `minOrder` ASC [ RunTime:0.005390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13513646 LIMIT 5 [ RunTime:0.057651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513646 ORDER BY `minOrder` ASC [ RunTime:0.049472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13513646 ORDER BY `unit` DESC [ RunTime:0.030798s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13513646 LIMIT 2 [ RunTime:0.038731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13513646 ORDER BY `minOrder` ASC [ RunTime:0.016968s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005836s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728634 LIMIT 5 [ RunTime:0.039862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728634 ORDER BY `minOrder` ASC [ RunTime:0.026471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728634 ORDER BY `unit` DESC [ RunTime:0.011944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728634 LIMIT 2 [ RunTime:0.009329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728634 ORDER BY `minOrder` ASC [ RunTime:0.009358s ]
select * from pdf where partno='2754090000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010721s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754090000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008465s ]
SELECT `id` FROM `stock` WHERE `id` <> 53728634 AND `partno` = '2754090000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.014128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310972 [ RunTime:0.010317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728633 LIMIT 5 [ RunTime:0.001222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728633 ORDER BY `minOrder` ASC [ RunTime:0.014143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728633 ORDER BY `unit` DESC [ RunTime:0.015058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728633 LIMIT 2 [ RunTime:0.012958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728633 ORDER BY `minOrder` ASC [ RunTime:0.005767s ]
select * from pdf where partno='2754010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016471s ]
SELECT `id` FROM `stock` WHERE `id` <> 53728633 AND `partno` = '2754010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.024181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310971 [ RunTime:0.020153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727726 LIMIT 5 [ RunTime:0.019750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727726 ORDER BY `minOrder` ASC [ RunTime:0.028990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727726 ORDER BY `unit` DESC [ RunTime:0.020312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727726 LIMIT 2 [ RunTime:0.021308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727726 ORDER BY `minOrder` ASC [ RunTime:0.045028s ]
select * from pdf where partno='2754070000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754070000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014053s ]
SELECT `id` FROM `stock` WHERE `id` <> 53727726 AND `partno` = '2754070000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651335 [ RunTime:0.035924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709246 LIMIT 5 [ RunTime:0.041147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709246 ORDER BY `minOrder` ASC [ RunTime:0.033792s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709246 ORDER BY `unit` DESC [ RunTime:0.037570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709246 LIMIT 2 [ RunTime:0.028964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709246 ORDER BY `minOrder` ASC [ RunTime:0.015355s ]
select * from pdf where partno='2754040000' and brandshort='Weidmüller' limit 1 [ RunTime:0.038009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754040000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024686s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709246 AND `partno` = '2754040000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.099828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308135 [ RunTime:0.036395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709245 LIMIT 5 [ RunTime:0.004293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709245 ORDER BY `minOrder` ASC [ RunTime:0.034479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709245 ORDER BY `unit` DESC [ RunTime:0.069610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709245 LIMIT 2 [ RunTime:0.061199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709245 ORDER BY `minOrder` ASC [ RunTime:0.002374s ]
select * from pdf where partno='2754020000' and brandshort='Weidmüller' limit 1 [ RunTime:0.023945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754020000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.023992s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709245 AND `partno` = '2754020000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.036562s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17308134 [ RunTime:0.029232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709244 LIMIT 5 [ RunTime:0.021028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709244 ORDER BY `minOrder` ASC [ RunTime:0.011991s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709244 ORDER BY `unit` DESC [ RunTime:0.038485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709244 LIMIT 2 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709244 ORDER BY `minOrder` ASC [ RunTime:0.012900s ]
select * from pdf where partno='2754000000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754000000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009612s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709244 AND `partno` = '2754000000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637572 [ RunTime:0.013491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53709243 LIMIT 5 [ RunTime:0.040250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709243 ORDER BY `minOrder` ASC [ RunTime:0.038756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53709243 ORDER BY `unit` DESC [ RunTime:0.032425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53709243 LIMIT 2 [ RunTime:0.049174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53709243 ORDER BY `minOrder` ASC [ RunTime:0.020852s ]
select * from pdf where partno='2754050000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000764s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2754050000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.071152s ]
SELECT `id` FROM `stock` WHERE `id` <> 53709243 AND `partno` = '2754050000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.021787s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637571 [ RunTime:0.048691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32600574 LIMIT 5 [ RunTime:0.065759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600574 ORDER BY `minOrder` ASC [ RunTime:0.011298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32600574 ORDER BY `unit` DESC [ RunTime:0.035124s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32600574 LIMIT 2 [ RunTime:0.028657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32600574 ORDER BY `minOrder` ASC [ RunTime:0.027087s ]
select * from pdf where partno='27540' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.012796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '27540' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.017868s ]
SELECT `id` FROM `stock` WHERE `id` <> 32600574 AND `partno` = '27540' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.044633s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063522s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059495s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.075549s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039083s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.066800s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055009s ]
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 '27540%' OR `brand` LIKE '27540%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.100883s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '27540%' OR `brand` LIKE '27540%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.030601s ]