SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001427s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010213s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.014325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562136 LIMIT 5 [ RunTime:0.014791s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562136 ORDER BY `minOrder` ASC [ RunTime:0.029189s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562136 ORDER BY `unit` DESC [ RunTime:0.003086s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562136 LIMIT 2 [ RunTime:0.010128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562136 ORDER BY `minOrder` ASC [ RunTime:0.009522s ]
select * from pdf where partno='202E344-51-0-CS5324' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.023637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562135 LIMIT 5 [ RunTime:0.021335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562135 ORDER BY `minOrder` ASC [ RunTime:0.019564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562135 ORDER BY `unit` DESC [ RunTime:0.023864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562135 LIMIT 2 [ RunTime:0.030576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562135 ORDER BY `minOrder` ASC [ RunTime:0.002794s ]
select * from pdf where partno='202E344-51-0-CS8568' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.030069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562115 LIMIT 5 [ RunTime:0.028650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562115 ORDER BY `minOrder` ASC [ RunTime:0.008702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13562115 ORDER BY `unit` DESC [ RunTime:0.012490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13562115 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13562115 ORDER BY `minOrder` ASC [ RunTime:0.003538s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015980s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49363220 LIMIT 5 [ RunTime:0.014036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49363220 ORDER BY `minOrder` ASC [ RunTime:0.010042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49363220 ORDER BY `unit` DESC [ RunTime:0.012545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49363220 LIMIT 2 [ RunTime:0.009703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49363220 ORDER BY `minOrder` ASC [ RunTime:0.004645s ]
select * from pdf where partno='202E344-51-0-CS8568' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.005350s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS8568' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.008661s ]
SELECT `id` FROM `stock` WHERE `id` <> 49363220 AND `partno` = '202E344-51-0-CS8568' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.011492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36555095 [ RunTime:0.022977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49363219 LIMIT 5 [ RunTime:0.020462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49363219 ORDER BY `minOrder` ASC [ RunTime:0.003298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49363219 ORDER BY `unit` DESC [ RunTime:0.016067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49363219 LIMIT 2 [ RunTime:0.012923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49363219 ORDER BY `minOrder` ASC [ RunTime:0.005179s ]
select * from pdf where partno='202E344-51-0-CS5324' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS5324' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.005521s ]
SELECT `id` FROM `stock` WHERE `id` <> 49363219 AND `partno` = '202E344-51-0-CS5324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36555094 [ RunTime:0.002525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49362620 LIMIT 5 [ RunTime:0.024350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362620 ORDER BY `minOrder` ASC [ RunTime:0.018844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49362620 ORDER BY `unit` DESC [ RunTime:0.017633s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49362620 LIMIT 2 [ RunTime:0.012420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362620 ORDER BY `minOrder` ASC [ RunTime:0.014909s ]
select * from pdf where partno='202E344-51-0-CS5324' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002003s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS5324' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.004682s ]
SELECT `id` FROM `stock` WHERE `id` <> 49362620 AND `partno` = '202E344-51-0-CS5324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.007658s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562136 [ RunTime:0.007560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49362619 LIMIT 5 [ RunTime:0.014976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362619 ORDER BY `minOrder` ASC [ RunTime:0.012517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49362619 ORDER BY `unit` DESC [ RunTime:0.016748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49362619 LIMIT 2 [ RunTime:0.020799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362619 ORDER BY `minOrder` ASC [ RunTime:0.000551s ]
select * from pdf where partno='202E344-51-0-CS8568' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002311s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS8568' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.003973s ]
SELECT `id` FROM `stock` WHERE `id` <> 49362619 AND `partno` = '202E344-51-0-CS8568' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.018460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562135 [ RunTime:0.023715s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49362544 LIMIT 5 [ RunTime:0.010510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362544 ORDER BY `minOrder` ASC [ RunTime:0.018022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49362544 ORDER BY `unit` DESC [ RunTime:0.013288s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49362544 LIMIT 2 [ RunTime:0.017541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49362544 ORDER BY `minOrder` ASC [ RunTime:0.005765s ]
select * from pdf where partno='202E344-51-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.008534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.018869s ]
SELECT `id` FROM `stock` WHERE `id` <> 49362544 AND `partno` = '202E344-51-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.009188s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36554427 [ RunTime:0.004577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49360990 LIMIT 5 [ RunTime:0.008947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49360990 ORDER BY `minOrder` ASC [ RunTime:0.008597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49360990 ORDER BY `unit` DESC [ RunTime:0.008599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49360990 LIMIT 2 [ RunTime:0.008921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49360990 ORDER BY `minOrder` ASC [ RunTime:0.003249s ]
select * from pdf where partno='202E344-51-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005931s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001688s ]
SELECT `id` FROM `stock` WHERE `id` <> 49360990 AND `partno` = '202E344-51-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.006259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562115 [ RunTime:0.028759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36555095 LIMIT 5 [ RunTime:0.010388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36555095 ORDER BY `minOrder` ASC [ RunTime:0.030746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36555095 ORDER BY `unit` DESC [ RunTime:0.017199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36555095 LIMIT 2 [ RunTime:0.006105s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36555095 ORDER BY `minOrder` ASC [ RunTime:0.008806s ]
select * from pdf where partno='202E344-51-0-CS8568' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.007763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS8568' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006224s ]
SELECT `id` FROM `stock` WHERE `id` <> 36555095 AND `partno` = '202E344-51-0-CS8568' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.007887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49363220 [ RunTime:0.028482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36555094 LIMIT 5 [ RunTime:0.001288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36555094 ORDER BY `minOrder` ASC [ RunTime:0.006226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36555094 ORDER BY `unit` DESC [ RunTime:0.002304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36555094 LIMIT 2 [ RunTime:0.003887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36555094 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
select * from pdf where partno='202E344-51-0-CS5324' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.000710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS5324' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002149s ]
SELECT `id` FROM `stock` WHERE `id` <> 36555094 AND `partno` = '202E344-51-0-CS5324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49363219 [ RunTime:0.004195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36554499 LIMIT 5 [ RunTime:0.002996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554499 ORDER BY `minOrder` ASC [ RunTime:0.001833s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36554499 ORDER BY `unit` DESC [ RunTime:0.008940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36554499 LIMIT 2 [ RunTime:0.003882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554499 ORDER BY `minOrder` ASC [ RunTime:0.002361s ]
select * from pdf where partno='202E344-51-0-CS5324' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.005825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS5324' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.005527s ]
SELECT `id` FROM `stock` WHERE `id` <> 36554499 AND `partno` = '202E344-51-0-CS5324' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.011336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562136 [ RunTime:0.005619s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36554498 LIMIT 5 [ RunTime:0.012362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554498 ORDER BY `minOrder` ASC [ RunTime:0.001860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36554498 ORDER BY `unit` DESC [ RunTime:0.022532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36554498 LIMIT 2 [ RunTime:0.019272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554498 ORDER BY `minOrder` ASC [ RunTime:0.003120s ]
select * from pdf where partno='202E344-51-0-CS8568' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0-CS8568' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000404s ]
SELECT `id` FROM `stock` WHERE `id` <> 36554498 AND `partno` = '202E344-51-0-CS8568' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.009245s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562135 [ RunTime:0.003061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36554427 LIMIT 5 [ RunTime:0.003379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554427 ORDER BY `minOrder` ASC [ RunTime:0.016342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36554427 ORDER BY `unit` DESC [ RunTime:0.001476s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36554427 LIMIT 2 [ RunTime:0.008090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36554427 ORDER BY `minOrder` ASC [ RunTime:0.002198s ]
select * from pdf where partno='202E344-51-0' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.009143s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006688s ]
SELECT `id` FROM `stock` WHERE `id` <> 36554427 AND `partno` = '202E344-51-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49362544 [ RunTime:0.013187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36552916 LIMIT 5 [ RunTime:0.007537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36552916 ORDER BY `minOrder` ASC [ RunTime:0.014737s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36552916 ORDER BY `unit` DESC [ RunTime:0.001539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36552916 LIMIT 2 [ RunTime:0.007592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36552916 ORDER BY `minOrder` ASC [ RunTime:0.009131s ]
select * from pdf where partno='202E344-51-0' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '202E344-51-0' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000587s ]
SELECT `id` FROM `stock` WHERE `id` <> 36552916 AND `partno` = '202E344-51-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.001807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13562115 [ RunTime:0.009451s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016903s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006986s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025011s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007514s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003494s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005348s ]
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 '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014643s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '202E344-51-0%' OR `brand` LIKE '202E344-51-0%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005190s ]