SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002923s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045126s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001047s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562936 LIMIT 5 [ RunTime:0.048744s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562936 ORDER BY `minOrder` ASC [ RunTime:0.023774s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562936 ORDER BY `unit` DESC [ RunTime:0.015068s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.017234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562936 LIMIT 2 [ RunTime:0.041610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562936 ORDER BY `minOrder` ASC [ RunTime:0.012982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561902 LIMIT 5 [ RunTime:0.007003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561902 ORDER BY `minOrder` ASC [ RunTime:0.023076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561902 ORDER BY `unit` DESC [ RunTime:0.022759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561902 LIMIT 2 [ RunTime:0.018389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561902 ORDER BY `minOrder` ASC [ RunTime:0.005302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561874 LIMIT 5 [ RunTime:0.031735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561874 ORDER BY `minOrder` ASC [ RunTime:0.032702s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561874 ORDER BY `unit` DESC [ RunTime:0.038753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561874 LIMIT 2 [ RunTime:0.048385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561874 ORDER BY `minOrder` ASC [ RunTime:0.050847s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446763 LIMIT 5 [ RunTime:0.077015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446763 ORDER BY `minOrder` ASC [ RunTime:0.055276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446763 ORDER BY `unit` DESC [ RunTime:0.037273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446763 LIMIT 2 [ RunTime:0.029187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446763 ORDER BY `minOrder` ASC [ RunTime:0.017714s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446497 LIMIT 5 [ RunTime:0.050222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446497 ORDER BY `minOrder` ASC [ RunTime:0.005514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446497 ORDER BY `unit` DESC [ RunTime:0.039975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446497 LIMIT 2 [ RunTime:0.044795s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446497 ORDER BY `minOrder` ASC [ RunTime:0.040773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526098 LIMIT 5 [ RunTime:0.019183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526098 ORDER BY `minOrder` ASC [ RunTime:0.047205s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13526098 ORDER BY `unit` DESC [ RunTime:0.053576s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13526098 LIMIT 2 [ RunTime:0.009203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13526098 ORDER BY `minOrder` ASC [ RunTime:0.019721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564130 LIMIT 5 [ RunTime:0.053934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564130 ORDER BY `minOrder` ASC [ RunTime:0.031733s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564130 ORDER BY `unit` DESC [ RunTime:0.022117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564130 LIMIT 2 [ RunTime:0.064946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564130 ORDER BY `minOrder` ASC [ RunTime:0.031115s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059736s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.174301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384879 LIMIT 5 [ RunTime:0.116072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384879 ORDER BY `minOrder` ASC [ RunTime:0.053278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384879 ORDER BY `unit` DESC [ RunTime:0.045582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384879 LIMIT 2 [ RunTime:0.038602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384879 ORDER BY `minOrder` ASC [ RunTime:0.032356s ]
select * from pdf where partno='1088746' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.055203s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088746' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.085102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384885 LIMIT 5 [ RunTime:0.069951s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384885 ORDER BY `minOrder` ASC [ RunTime:0.161747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384885 ORDER BY `unit` DESC [ RunTime:0.040812s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384885 LIMIT 2 [ RunTime:0.083620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384885 ORDER BY `minOrder` ASC [ RunTime:0.000782s ]
select * from pdf where partno='1088748' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.111539s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088748' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385570 LIMIT 5 [ RunTime:0.112841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385570 ORDER BY `minOrder` ASC [ RunTime:0.085418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385570 ORDER BY `unit` DESC [ RunTime:0.043333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385570 LIMIT 2 [ RunTime:0.058842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385570 ORDER BY `minOrder` ASC [ RunTime:0.039184s ]
select * from pdf where partno='1088747' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.020601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088747' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.073022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469469 LIMIT 5 [ RunTime:0.031499s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469469 ORDER BY `minOrder` ASC [ RunTime:0.026697s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469469 ORDER BY `unit` DESC [ RunTime:0.035940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469469 LIMIT 2 [ RunTime:0.088767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469469 ORDER BY `minOrder` ASC [ RunTime:0.040809s ]
select * from pdf where partno='1088742' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022661s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088742' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041967s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469526 LIMIT 5 [ RunTime:0.010821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469526 ORDER BY `minOrder` ASC [ RunTime:0.058805s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469526 ORDER BY `unit` DESC [ RunTime:0.023499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469526 LIMIT 2 [ RunTime:0.023521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469526 ORDER BY `minOrder` ASC [ RunTime:0.029257s ]
select * from pdf where partno='1088745' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019886s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088745' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.082910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469522 LIMIT 5 [ RunTime:0.054738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469522 ORDER BY `minOrder` ASC [ RunTime:0.030694s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469522 ORDER BY `unit` DESC [ RunTime:0.073187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469522 LIMIT 2 [ RunTime:0.015670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469522 ORDER BY `minOrder` ASC [ RunTime:0.039624s ]
select * from pdf where partno='1088743' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.037018s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088743' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.050320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60470589 LIMIT 5 [ RunTime:0.041241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470589 ORDER BY `minOrder` ASC [ RunTime:0.026573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60470589 ORDER BY `unit` DESC [ RunTime:0.043474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60470589 LIMIT 2 [ RunTime:0.038003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470589 ORDER BY `minOrder` ASC [ RunTime:0.039313s ]
select * from pdf where partno='1088740' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.134860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088740' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.076026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60472128 LIMIT 5 [ RunTime:0.098664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60472128 ORDER BY `minOrder` ASC [ RunTime:0.057102s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60472128 ORDER BY `unit` DESC [ RunTime:0.071875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60472128 LIMIT 2 [ RunTime:0.023029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60472128 ORDER BY `minOrder` ASC [ RunTime:0.010414s ]
select * from pdf where partno='1088744' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019352s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088744' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64517685 LIMIT 5 [ RunTime:0.014551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64517685 ORDER BY `minOrder` ASC [ RunTime:0.024458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64517685 ORDER BY `unit` DESC [ RunTime:0.034316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64517685 LIMIT 2 [ RunTime:0.043049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64517685 ORDER BY `minOrder` ASC [ RunTime:0.019242s ]
select * from pdf where partno='108874' and brandshort='Brady Corporation' limit 1 [ RunTime:0.046343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108874' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.028704s ]
SELECT `id` FROM `stock` WHERE `id` <> 64517685 AND `partno` = '108874' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.049308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13526098 [ RunTime:0.080201s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60474575 LIMIT 5 [ RunTime:0.028642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60474575 ORDER BY `minOrder` ASC [ RunTime:0.055689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60474575 ORDER BY `unit` DESC [ RunTime:0.030192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60474575 LIMIT 2 [ RunTime:0.069703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60474575 ORDER BY `minOrder` ASC [ RunTime:0.015355s ]
select * from pdf where partno='1088749' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.030944s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088749' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.089596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60471800 LIMIT 5 [ RunTime:0.049498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471800 ORDER BY `minOrder` ASC [ RunTime:0.037610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60471800 ORDER BY `unit` DESC [ RunTime:0.058309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60471800 LIMIT 2 [ RunTime:0.049918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471800 ORDER BY `minOrder` ASC [ RunTime:0.021106s ]
select * from pdf where partno='1088741' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019338s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1088741' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.051882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60012902 LIMIT 5 [ RunTime:0.000627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60012902 ORDER BY `minOrder` ASC [ RunTime:0.003700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60012902 ORDER BY `unit` DESC [ RunTime:0.004011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60012902 LIMIT 2 [ RunTime:0.005102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60012902 ORDER BY `minOrder` ASC [ RunTime:0.008395s ]
select * from pdf where partno='108874-ZZ' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.004031s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '108874-ZZ' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002766s ]
SELECT `id` FROM `stock` WHERE `id` <> 60012902 AND `partno` = '108874-ZZ' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000967s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011193s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015672s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001779s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005641s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032354s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013713s ]
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 '108874%' OR `brand` LIKE '108874%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009884s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '108874%' OR `brand` LIKE '108874%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007402s ]