SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002330s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026077s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591544 LIMIT 5 [ RunTime:0.008668s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591544 ORDER BY `minOrder` ASC [ RunTime:0.005077s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19591544 ORDER BY `unit` DESC [ RunTime:0.004501s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19591544 LIMIT 2 [ RunTime:0.013035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19591544 ORDER BY `minOrder` ASC [ RunTime:0.029661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300162 LIMIT 5 [ RunTime:0.029019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300162 ORDER BY `minOrder` ASC [ RunTime:0.013886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17300162 ORDER BY `unit` DESC [ RunTime:0.000491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17300162 LIMIT 2 [ RunTime:0.013791s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17300162 ORDER BY `minOrder` ASC [ RunTime:0.016769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593729 LIMIT 5 [ RunTime:0.009476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593729 ORDER BY `minOrder` ASC [ RunTime:0.021063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593729 ORDER BY `unit` DESC [ RunTime:0.004936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593729 LIMIT 2 [ RunTime:0.004421s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593729 ORDER BY `minOrder` ASC [ RunTime:0.000628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044727 LIMIT 5 [ RunTime:0.002104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044727 ORDER BY `minOrder` ASC [ RunTime:0.004629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17044727 ORDER BY `unit` DESC [ RunTime:0.000474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17044727 LIMIT 2 [ RunTime:0.000745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17044727 ORDER BY `minOrder` ASC [ RunTime:0.000478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884507 LIMIT 5 [ RunTime:0.003023s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884507 ORDER BY `minOrder` ASC [ RunTime:0.006029s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12884507 ORDER BY `unit` DESC [ RunTime:0.005196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12884507 LIMIT 2 [ RunTime:0.004214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12884507 ORDER BY `minOrder` ASC [ RunTime:0.000910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684468 LIMIT 5 [ RunTime:0.002204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684468 ORDER BY `minOrder` ASC [ RunTime:0.001066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11684468 ORDER BY `unit` DESC [ RunTime:0.000647s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11684468 LIMIT 2 [ RunTime:0.002533s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11684468 ORDER BY `minOrder` ASC [ RunTime:0.005186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482736 LIMIT 5 [ RunTime:0.003330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482736 ORDER BY `minOrder` ASC [ RunTime:0.010362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11482736 ORDER BY `unit` DESC [ RunTime:0.009784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11482736 LIMIT 2 [ RunTime:0.011201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11482736 ORDER BY `minOrder` ASC [ RunTime:0.008942s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001705s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51866532 LIMIT 5 [ RunTime:0.002540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866532 ORDER BY `minOrder` ASC [ RunTime:0.008470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51866532 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51866532 LIMIT 2 [ RunTime:0.001061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51866532 ORDER BY `minOrder` ASC [ RunTime:0.000448s ]
select * from pdf where partno='6095' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.001110s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000453s ]
SELECT `id` FROM `stock` WHERE `id` <> 51866532 AND `partno` = '6095' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.000989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53492247 LIMIT 5 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492247 ORDER BY `minOrder` ASC [ RunTime:0.010076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53492247 ORDER BY `unit` DESC [ RunTime:0.023334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53492247 LIMIT 2 [ RunTime:0.002389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492247 ORDER BY `minOrder` ASC [ RunTime:0.004788s ]
select * from pdf where partno='6095-1-00-15-00-00-38-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095-1-00-15-00-00-38-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.011573s ]
SELECT `id` FROM `stock` WHERE `id` <> 53492247 AND `partno` = '6095-1-00-15-00-00-38-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.012013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19591544 [ RunTime:0.007981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53492456 LIMIT 5 [ RunTime:0.011772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492456 ORDER BY `minOrder` ASC [ RunTime:0.002653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53492456 ORDER BY `unit` DESC [ RunTime:0.003645s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53492456 LIMIT 2 [ RunTime:0.008543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492456 ORDER BY `minOrder` ASC [ RunTime:0.007072s ]
select * from pdf where partno='6095-0-00-34-00-00-38-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095-0-00-34-00-00-38-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.007433s ]
SELECT `id` FROM `stock` WHERE `id` <> 53492456 AND `partno` = '6095-0-00-34-00-00-38-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.017093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17300162 [ RunTime:0.004854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53492995 LIMIT 5 [ RunTime:0.001417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492995 ORDER BY `minOrder` ASC [ RunTime:0.001311s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53492995 ORDER BY `unit` DESC [ RunTime:0.003894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53492995 LIMIT 2 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53492995 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
select * from pdf where partno='6095-2-00-38-00-00-38-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095-2-00-38-00-00-38-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.003723s ]
SELECT `id` FROM `stock` WHERE `id` <> 53492995 AND `partno` = '6095-2-00-38-00-00-38-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.013849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593729 [ RunTime:0.005948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51277544 LIMIT 5 [ RunTime:0.005018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51277544 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51277544 ORDER BY `unit` DESC [ RunTime:0.001296s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51277544 LIMIT 2 [ RunTime:0.014634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51277544 ORDER BY `minOrder` ASC [ RunTime:0.000587s ]
select * from pdf where partno='6095' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.000576s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095' OR `brand` LIKE 'Adafruit Industries LLC%' ) ) LIMIT 1 [ RunTime:0.000527s ]
SELECT `id` FROM `stock` WHERE `id` <> 51277544 AND `partno` = '6095' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%adafruit industries llc%' ) [ RunTime:0.001024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17044727 [ RunTime:0.001530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53557834 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53557834 ORDER BY `minOrder` ASC [ RunTime:0.006708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53557834 ORDER BY `unit` DESC [ RunTime:0.013188s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53557834 LIMIT 2 [ RunTime:0.001239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53557834 ORDER BY `minOrder` ASC [ RunTime:0.006397s ]
select * from pdf where partno='6095-1' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.003967s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095-1' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002184s ]
SELECT `id` FROM `stock` WHERE `id` <> 53557834 AND `partno` = '6095-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11684468 [ RunTime:0.009003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53557833 LIMIT 5 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53557833 ORDER BY `minOrder` ASC [ RunTime:0.010287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53557833 ORDER BY `unit` DESC [ RunTime:0.009551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53557833 LIMIT 2 [ RunTime:0.010893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53557833 ORDER BY `minOrder` ASC [ RunTime:0.004182s ]
select * from pdf where partno='6095-2' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.004572s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095-2' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.002388s ]
SELECT `id` FROM `stock` WHERE `id` <> 53557833 AND `partno` = '6095-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.005209s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12884507 [ RunTime:0.003095s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53530719 LIMIT 5 [ RunTime:0.005412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53530719 ORDER BY `minOrder` ASC [ RunTime:0.006166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53530719 ORDER BY `unit` DESC [ RunTime:0.004201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53530719 LIMIT 2 [ RunTime:0.005996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53530719 ORDER BY `minOrder` ASC [ RunTime:0.004363s ]
select * from pdf where partno='60951-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003201s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60951-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001014s ]
SELECT `id` FROM `stock` WHERE `id` <> 53530719 AND `partno` = '60951-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11482736 [ RunTime:0.004818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51696510 LIMIT 5 [ RunTime:0.001641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51696510 ORDER BY `minOrder` ASC [ RunTime:0.003803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51696510 ORDER BY `unit` DESC [ RunTime:0.000407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51696510 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51696510 ORDER BY `minOrder` ASC [ RunTime:0.001778s ]
select * from pdf where partno='6095' and brandshort='80/20, LLC' limit 1 [ RunTime:0.000740s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6095' OR `brand` LIKE '80/20, LLC%' ) ) LIMIT 1 [ RunTime:0.000436s ]
SELECT `id` FROM `stock` WHERE `id` <> 51696510 AND `partno` = '6095' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%80/20, llc%' ) [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42061297 LIMIT 5 [ RunTime:0.002975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061297 ORDER BY `minOrder` ASC [ RunTime:0.001058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42061297 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42061297 LIMIT 2 [ RunTime:0.000603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061297 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='609538P1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.001040s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609538P1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.000855s ]
SELECT `id` FROM `stock` WHERE `id` <> 42061297 AND `partno` = '609538P1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.000841s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42061296 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061296 ORDER BY `minOrder` ASC [ RunTime:0.001824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42061296 ORDER BY `unit` DESC [ RunTime:0.002309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42061296 LIMIT 2 [ RunTime:0.002675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061296 ORDER BY `minOrder` ASC [ RunTime:0.000684s ]
select * from pdf where partno='609537P1' and brandshort='Schneider Electric' limit 1 [ RunTime:0.001932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '609537P1' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.001027s ]
SELECT `id` FROM `stock` WHERE `id` <> 42061296 AND `partno` = '609537P1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.003589s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005021s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001196s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011449s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001725s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001637s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005073s ]
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 '6095%' OR `brand` LIKE '6095%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001381s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '6095%' OR `brand` LIKE '6095%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001262s ]