SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001347s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034929s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19805159 LIMIT 5 [ RunTime:0.026150s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19805159 ORDER BY `minOrder` ASC [ RunTime:0.035673s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19805159 ORDER BY `unit` DESC [ RunTime:0.017693s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19805159 LIMIT 2 [ RunTime:0.007812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19805159 ORDER BY `minOrder` ASC [ RunTime:0.005161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19793813 LIMIT 5 [ RunTime:0.031586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793813 ORDER BY `minOrder` ASC [ RunTime:0.022056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19793813 ORDER BY `unit` DESC [ RunTime:0.020900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19793813 LIMIT 2 [ RunTime:0.020818s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19793813 ORDER BY `minOrder` ASC [ RunTime:0.021152s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15482172 LIMIT 5 [ RunTime:0.067953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15482172 ORDER BY `minOrder` ASC [ RunTime:0.025379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15482172 ORDER BY `unit` DESC [ RunTime:0.015616s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15482172 LIMIT 2 [ RunTime:0.044926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15482172 ORDER BY `minOrder` ASC [ RunTime:0.020039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15480995 LIMIT 5 [ RunTime:0.026453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15480995 ORDER BY `minOrder` ASC [ RunTime:0.024561s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15480995 ORDER BY `unit` DESC [ RunTime:0.054382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15480995 LIMIT 2 [ RunTime:0.088584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15480995 ORDER BY `minOrder` ASC [ RunTime:0.050206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14345323 LIMIT 5 [ RunTime:0.064599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345323 ORDER BY `minOrder` ASC [ RunTime:0.131337s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14345323 ORDER BY `unit` DESC [ RunTime:0.035184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14345323 LIMIT 2 [ RunTime:0.080412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14345323 ORDER BY `minOrder` ASC [ RunTime:0.033135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12771811 LIMIT 5 [ RunTime:0.178013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12771811 ORDER BY `minOrder` ASC [ RunTime:0.107246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12771811 ORDER BY `unit` DESC [ RunTime:0.128370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12771811 LIMIT 2 [ RunTime:0.112368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12771811 ORDER BY `minOrder` ASC [ RunTime:0.041992s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730185 LIMIT 5 [ RunTime:0.132456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730185 ORDER BY `minOrder` ASC [ RunTime:0.159564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12730185 ORDER BY `unit` DESC [ RunTime:0.049939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12730185 LIMIT 2 [ RunTime:0.148865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12730185 ORDER BY `minOrder` ASC [ RunTime:0.092098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12725508 LIMIT 5 [ RunTime:0.143260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12725508 ORDER BY `minOrder` ASC [ RunTime:0.052797s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12725508 ORDER BY `unit` DESC [ RunTime:0.117688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12725508 LIMIT 2 [ RunTime:0.079847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12725508 ORDER BY `minOrder` ASC [ RunTime:0.060741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12724011 LIMIT 5 [ RunTime:0.121495s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12724011 ORDER BY `minOrder` ASC [ RunTime:0.056151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12724011 ORDER BY `unit` DESC [ RunTime:0.099911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12724011 LIMIT 2 [ RunTime:0.107465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12724011 ORDER BY `minOrder` ASC [ RunTime:0.035178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12715109 LIMIT 5 [ RunTime:0.084264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12715109 ORDER BY `minOrder` ASC [ RunTime:0.030394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12715109 ORDER BY `unit` DESC [ RunTime:0.164219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12715109 LIMIT 2 [ RunTime:0.142397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12715109 ORDER BY `minOrder` ASC [ RunTime:0.019004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11559482 LIMIT 5 [ RunTime:0.029677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11559482 ORDER BY `minOrder` ASC [ RunTime:0.007545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11559482 ORDER BY `unit` DESC [ RunTime:0.019756s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11559482 LIMIT 2 [ RunTime:0.035306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11559482 ORDER BY `minOrder` ASC [ RunTime:0.004985s ]
select * from pdf where partno='87382-226HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.031721s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018204s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52802242 LIMIT 5 [ RunTime:0.017956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802242 ORDER BY `minOrder` ASC [ RunTime:0.039410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52802242 ORDER BY `unit` DESC [ RunTime:0.025999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52802242 LIMIT 2 [ RunTime:0.012305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52802242 ORDER BY `minOrder` ASC [ RunTime:0.015348s ]
select * from pdf where partno='87382-172HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.004640s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.004011s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-172HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.004683s ]
SELECT `id` FROM `stock` WHERE `id` <> 52802242 AND `partno` = '87382-172HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.041252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15482172 [ RunTime:0.034140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52794043 LIMIT 5 [ RunTime:0.042312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52794043 ORDER BY `minOrder` ASC [ RunTime:0.022342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52794043 ORDER BY `unit` DESC [ RunTime:0.026324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52794043 LIMIT 2 [ RunTime:0.016035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52794043 ORDER BY `minOrder` ASC [ RunTime:0.012467s ]
select * from pdf where partno='87382-272H' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013221s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-272H' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.051304s ]
SELECT `id` FROM `stock` WHERE `id` <> 52794043 AND `partno` = '87382-272H' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.033108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15480995 [ RunTime:0.058397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52766468 LIMIT 5 [ RunTime:0.040024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52766468 ORDER BY `minOrder` ASC [ RunTime:0.020021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52766468 ORDER BY `unit` DESC [ RunTime:0.080205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52766468 LIMIT 2 [ RunTime:0.059000s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52766468 ORDER BY `minOrder` ASC [ RunTime:0.022431s ]
select * from pdf where partno='87382-234' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.046457s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-234' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.015101s ]
SELECT `id` FROM `stock` WHERE `id` <> 52766468 AND `partno` = '87382-234' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.030503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12730185 [ RunTime:0.032960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52758437 LIMIT 5 [ RunTime:0.033695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52758437 ORDER BY `minOrder` ASC [ RunTime:0.016156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52758437 ORDER BY `unit` DESC [ RunTime:0.061028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52758437 LIMIT 2 [ RunTime:0.027808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52758437 ORDER BY `minOrder` ASC [ RunTime:0.018933s ]
select * from pdf where partno='87382-234HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.013236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-234HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.059212s ]
SELECT `id` FROM `stock` WHERE `id` <> 52758437 AND `partno` = '87382-234HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.005483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12725508 [ RunTime:0.043975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52755911 LIMIT 5 [ RunTime:0.030547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52755911 ORDER BY `minOrder` ASC [ RunTime:0.016404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52755911 ORDER BY `unit` DESC [ RunTime:0.012536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52755911 LIMIT 2 [ RunTime:0.047524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52755911 ORDER BY `minOrder` ASC [ RunTime:0.018425s ]
select * from pdf where partno='87382-226' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.018314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-226' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.039931s ]
SELECT `id` FROM `stock` WHERE `id` <> 52755911 AND `partno` = '87382-226' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.060553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12724011 [ RunTime:0.059260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52754709 LIMIT 5 [ RunTime:0.027604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52754709 ORDER BY `minOrder` ASC [ RunTime:0.034996s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52754709 ORDER BY `unit` DESC [ RunTime:0.005391s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52754709 LIMIT 2 [ RunTime:0.018962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52754709 ORDER BY `minOrder` ASC [ RunTime:0.007217s ]
select * from pdf where partno='87382-226HLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.003206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87382-226HLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.007014s ]
SELECT `id` FROM `stock` WHERE `id` <> 52754709 AND `partno` = '87382-226HLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.004789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11559482 [ RunTime:0.012773s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009766s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001673s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016096s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015643s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011797s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009068s ]
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 '87382%' OR `brand` LIKE '87382%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015611s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '87382%' OR `brand` LIKE '87382%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.021289s ]