SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001866s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.056799s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.025445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074824 LIMIT 5 [ RunTime:0.054954s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.026759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074824 ORDER BY `minOrder` ASC [ RunTime:0.037752s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.022217s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074824 ORDER BY `unit` DESC [ RunTime:0.021616s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.022074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074824 LIMIT 2 [ RunTime:0.025333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074824 ORDER BY `minOrder` ASC [ RunTime:0.031997s ]
select * from pdf where partno='RJHSE538M08' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.130718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074073 LIMIT 5 [ RunTime:0.065398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074073 ORDER BY `minOrder` ASC [ RunTime:0.138800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20074073 ORDER BY `unit` DESC [ RunTime:0.179885s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20074073 LIMIT 2 [ RunTime:0.030442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20074073 ORDER BY `minOrder` ASC [ RunTime:0.033482s ]
select * from pdf where partno='RJHSE538M04' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.105145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072748 LIMIT 5 [ RunTime:0.058301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072748 ORDER BY `minOrder` ASC [ RunTime:0.041880s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20072748 ORDER BY `unit` DESC [ RunTime:0.030920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20072748 LIMIT 2 [ RunTime:0.034915s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20072748 ORDER BY `minOrder` ASC [ RunTime:0.042336s ]
select * from pdf where partno='RJHSE538M' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.018419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355355 LIMIT 5 [ RunTime:0.120388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355355 ORDER BY `minOrder` ASC [ RunTime:0.129793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16355355 ORDER BY `unit` DESC [ RunTime:0.076469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16355355 LIMIT 2 [ RunTime:0.032824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16355355 ORDER BY `minOrder` ASC [ RunTime:0.071483s ]
select * from pdf where partno='RJHSE538M06' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.029588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354780 LIMIT 5 [ RunTime:0.087021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354780 ORDER BY `minOrder` ASC [ RunTime:0.077460s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16354780 ORDER BY `unit` DESC [ RunTime:0.075044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16354780 LIMIT 2 [ RunTime:0.103229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16354780 ORDER BY `minOrder` ASC [ RunTime:0.021321s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546762 LIMIT 5 [ RunTime:0.035604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546762 ORDER BY `minOrder` ASC [ RunTime:0.008763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15546762 ORDER BY `unit` DESC [ RunTime:0.018728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15546762 LIMIT 2 [ RunTime:0.005550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15546762 ORDER BY `minOrder` ASC [ RunTime:0.026627s ]
select * from pdf where partno='RJHSE538MA1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.012786s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021177s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60425021 LIMIT 5 [ RunTime:0.021132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425021 ORDER BY `minOrder` ASC [ RunTime:0.025577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60425021 ORDER BY `unit` DESC [ RunTime:0.020457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60425021 LIMIT 2 [ RunTime:0.021131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60425021 ORDER BY `minOrder` ASC [ RunTime:0.018479s ]
select * from pdf where partno='RJHSE538M08' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.016569s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538M08' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.035510s ]
SELECT `id` FROM `stock` WHERE `id` <> 60425021 AND `partno` = 'RJHSE538M08' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.013884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074824 [ RunTime:0.052191s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60424152 LIMIT 5 [ RunTime:0.037203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60424152 ORDER BY `minOrder` ASC [ RunTime:0.040733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60424152 ORDER BY `unit` DESC [ RunTime:0.043505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60424152 LIMIT 2 [ RunTime:0.013118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60424152 ORDER BY `minOrder` ASC [ RunTime:0.065437s ]
select * from pdf where partno='RJHSE538M06' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.011172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538M06' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.045076s ]
SELECT `id` FROM `stock` WHERE `id` <> 60424152 AND `partno` = 'RJHSE538M06' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.036339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16355355 [ RunTime:0.015661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60423726 LIMIT 5 [ RunTime:0.009654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423726 ORDER BY `minOrder` ASC [ RunTime:0.024529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60423726 ORDER BY `unit` DESC [ RunTime:0.009834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60423726 LIMIT 2 [ RunTime:0.004977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60423726 ORDER BY `minOrder` ASC [ RunTime:0.016047s ]
select * from pdf where partno='RJHSE538M04' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.000961s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538M04' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.006492s ]
SELECT `id` FROM `stock` WHERE `id` <> 60423726 AND `partno` = 'RJHSE538M04' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.025215s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20074073 [ RunTime:0.016422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421290 LIMIT 5 [ RunTime:0.018266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421290 ORDER BY `minOrder` ASC [ RunTime:0.039187s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421290 ORDER BY `unit` DESC [ RunTime:0.039501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421290 LIMIT 2 [ RunTime:0.033992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421290 ORDER BY `minOrder` ASC [ RunTime:0.031353s ]
select * from pdf where partno='RJHSE538MH1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.053312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538MH1' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.044043s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421290 AND `partno` = 'RJHSE538MH1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.046476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16354780 [ RunTime:0.004265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421259 LIMIT 5 [ RunTime:0.065412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421259 ORDER BY `minOrder` ASC [ RunTime:0.087372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421259 ORDER BY `unit` DESC [ RunTime:0.035981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421259 LIMIT 2 [ RunTime:0.023018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421259 ORDER BY `minOrder` ASC [ RunTime:0.021713s ]
select * from pdf where partno='RJHSE538MA1' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.065328s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538MA1' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.044994s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421259 AND `partno` = 'RJHSE538MA1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.046916s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15546762 [ RunTime:0.038034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60421258 LIMIT 5 [ RunTime:0.047749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421258 ORDER BY `minOrder` ASC [ RunTime:0.067571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60421258 ORDER BY `unit` DESC [ RunTime:0.027537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60421258 LIMIT 2 [ RunTime:0.005796s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60421258 ORDER BY `minOrder` ASC [ RunTime:0.029348s ]
select * from pdf where partno='RJHSE538M' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.020067s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538M' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.035776s ]
SELECT `id` FROM `stock` WHERE `id` <> 60421258 AND `partno` = 'RJHSE538M' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.045657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20072748 [ RunTime:0.012578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53604937 LIMIT 5 [ RunTime:0.020894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53604937 ORDER BY `minOrder` ASC [ RunTime:0.003801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53604937 ORDER BY `unit` DESC [ RunTime:0.052863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53604937 LIMIT 2 [ RunTime:0.016398s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53604937 ORDER BY `minOrder` ASC [ RunTime:0.012378s ]
select * from pdf where partno='RJHSE538MA8' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.050781s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538MA8' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.045125s ]
SELECT `id` FROM `stock` WHERE `id` <> 53604937 AND `partno` = 'RJHSE538MA8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.015558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53603582 LIMIT 5 [ RunTime:0.073420s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603582 ORDER BY `minOrder` ASC [ RunTime:0.029886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53603582 ORDER BY `unit` DESC [ RunTime:0.017543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53603582 LIMIT 2 [ RunTime:0.015071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53603582 ORDER BY `minOrder` ASC [ RunTime:0.008695s ]
select * from pdf where partno='RJHSE538MA4' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.025534s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538MA4' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.050167s ]
SELECT `id` FROM `stock` WHERE `id` <> 53603582 AND `partno` = 'RJHSE538MA4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.042106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53602513 LIMIT 5 [ RunTime:0.019509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602513 ORDER BY `minOrder` ASC [ RunTime:0.006733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53602513 ORDER BY `unit` DESC [ RunTime:0.021591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53602513 LIMIT 2 [ RunTime:0.027867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602513 ORDER BY `minOrder` ASC [ RunTime:0.011399s ]
select * from pdf where partno='RJHSE538MA2' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.015892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538MA2' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.026931s ]
SELECT `id` FROM `stock` WHERE `id` <> 53602513 AND `partno` = 'RJHSE538MA2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.008973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53602471 LIMIT 5 [ RunTime:0.000567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602471 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53602471 ORDER BY `unit` DESC [ RunTime:0.002012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53602471 LIMIT 2 [ RunTime:0.005085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53602471 ORDER BY `minOrder` ASC [ RunTime:0.055148s ]
select * from pdf where partno='RJHSE538M02' and brandshort='Amphenol ICC Commercial Products' limit 1 [ RunTime:0.022386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJHSE538M02' OR `brand` LIKE 'Amphenol ICC (Commercial Products)%' ) ) LIMIT 1 [ RunTime:0.012076s ]
SELECT `id` FROM `stock` WHERE `id` <> 53602471 AND `partno` = 'RJHSE538M02' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.017094s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041666s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005089s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001687s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007719s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020160s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012650s ]
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 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002706s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'RJHSE538M%' OR `brand` LIKE 'RJHSE538M%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.005284s ]