SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002791s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026240s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888956 LIMIT 5 [ RunTime:0.014783s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888956 ORDER BY `minOrder` ASC [ RunTime:0.002773s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14888956 ORDER BY `unit` DESC [ RunTime:0.000667s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006335s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14888956 LIMIT 2 [ RunTime:0.015565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888956 ORDER BY `minOrder` ASC [ RunTime:0.010932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887523 LIMIT 5 [ RunTime:0.010291s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887523 ORDER BY `minOrder` ASC [ RunTime:0.037800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14887523 ORDER BY `unit` DESC [ RunTime:0.038219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14887523 LIMIT 2 [ RunTime:0.016462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887523 ORDER BY `minOrder` ASC [ RunTime:0.009839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16725818 LIMIT 5 [ RunTime:0.019865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16725818 ORDER BY `minOrder` ASC [ RunTime:0.016538s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16725818 ORDER BY `unit` DESC [ RunTime:0.018367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16725818 LIMIT 2 [ RunTime:0.008424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16725818 ORDER BY `minOrder` ASC [ RunTime:0.023074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572490 LIMIT 5 [ RunTime:0.029185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572490 ORDER BY `minOrder` ASC [ RunTime:0.014001s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17572490 ORDER BY `unit` DESC [ RunTime:0.036727s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17572490 LIMIT 2 [ RunTime:0.043774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572490 ORDER BY `minOrder` ASC [ RunTime:0.002045s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972462 LIMIT 5 [ RunTime:0.042880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972462 ORDER BY `minOrder` ASC [ RunTime:0.034301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13972462 ORDER BY `unit` DESC [ RunTime:0.065044s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13972462 LIMIT 2 [ RunTime:0.024373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13972462 ORDER BY `minOrder` ASC [ RunTime:0.021834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887529 LIMIT 5 [ RunTime:0.033074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887529 ORDER BY `minOrder` ASC [ RunTime:0.015465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14887529 ORDER BY `unit` DESC [ RunTime:0.022903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14887529 LIMIT 2 [ RunTime:0.028821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887529 ORDER BY `minOrder` ASC [ RunTime:0.021985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17574772 LIMIT 5 [ RunTime:0.005653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17574772 ORDER BY `minOrder` ASC [ RunTime:0.011112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17574772 ORDER BY `unit` DESC [ RunTime:0.009029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17574772 LIMIT 2 [ RunTime:0.011404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17574772 ORDER BY `minOrder` ASC [ RunTime:0.010069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16725322 LIMIT 5 [ RunTime:0.027578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16725322 ORDER BY `minOrder` ASC [ RunTime:0.039122s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16725322 ORDER BY `unit` DESC [ RunTime:0.020589s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16725322 LIMIT 2 [ RunTime:0.015340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16725322 ORDER BY `minOrder` ASC [ RunTime:0.012135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724818 LIMIT 5 [ RunTime:0.010819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724818 ORDER BY `minOrder` ASC [ RunTime:0.008609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16724818 ORDER BY `unit` DESC [ RunTime:0.023934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16724818 LIMIT 2 [ RunTime:0.006184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724818 ORDER BY `minOrder` ASC [ RunTime:0.002044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572629 LIMIT 5 [ RunTime:0.007811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572629 ORDER BY `minOrder` ASC [ RunTime:0.019135s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17572629 ORDER BY `unit` DESC [ RunTime:0.004143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17572629 LIMIT 2 [ RunTime:0.014434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572629 ORDER BY `minOrder` ASC [ RunTime:0.012977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724333 LIMIT 5 [ RunTime:0.011794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724333 ORDER BY `minOrder` ASC [ RunTime:0.000926s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16724333 ORDER BY `unit` DESC [ RunTime:0.000547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16724333 LIMIT 2 [ RunTime:0.001363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724333 ORDER BY `minOrder` ASC [ RunTime:0.003444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16726056 LIMIT 5 [ RunTime:0.007701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16726056 ORDER BY `minOrder` ASC [ RunTime:0.010540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16726056 ORDER BY `unit` DESC [ RunTime:0.023913s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16726056 LIMIT 2 [ RunTime:0.005908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16726056 ORDER BY `minOrder` ASC [ RunTime:0.006732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572564 LIMIT 5 [ RunTime:0.026683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572564 ORDER BY `minOrder` ASC [ RunTime:0.003594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17572564 ORDER BY `unit` DESC [ RunTime:0.013152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17572564 LIMIT 2 [ RunTime:0.008643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17572564 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887632 LIMIT 5 [ RunTime:0.003696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887632 ORDER BY `minOrder` ASC [ RunTime:0.000906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14887632 ORDER BY `unit` DESC [ RunTime:0.000635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14887632 LIMIT 2 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887632 ORDER BY `minOrder` ASC [ RunTime:0.003565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888185 LIMIT 5 [ RunTime:0.002364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888185 ORDER BY `minOrder` ASC [ RunTime:0.001303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14888185 ORDER BY `unit` DESC [ RunTime:0.023018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14888185 LIMIT 2 [ RunTime:0.013554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888185 ORDER BY `minOrder` ASC [ RunTime:0.006365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724314 LIMIT 5 [ RunTime:0.014434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724314 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16724314 ORDER BY `unit` DESC [ RunTime:0.001136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16724314 LIMIT 2 [ RunTime:0.000682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16724314 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887427 LIMIT 5 [ RunTime:0.001667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887427 ORDER BY `minOrder` ASC [ RunTime:0.000639s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14887427 ORDER BY `unit` DESC [ RunTime:0.014243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14887427 LIMIT 2 [ RunTime:0.011821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887427 ORDER BY `minOrder` ASC [ RunTime:0.007065s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888191 LIMIT 5 [ RunTime:0.006363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888191 ORDER BY `minOrder` ASC [ RunTime:0.008616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14888191 ORDER BY `unit` DESC [ RunTime:0.002412s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14888191 LIMIT 2 [ RunTime:0.002648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14888191 ORDER BY `minOrder` ASC [ RunTime:0.002930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13971102 LIMIT 5 [ RunTime:0.010509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13971102 ORDER BY `minOrder` ASC [ RunTime:0.003858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13971102 ORDER BY `unit` DESC [ RunTime:0.007152s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13971102 LIMIT 2 [ RunTime:0.005751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13971102 ORDER BY `minOrder` ASC [ RunTime:0.018977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887765 LIMIT 5 [ RunTime:0.015169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887765 ORDER BY `minOrder` ASC [ RunTime:0.008892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14887765 ORDER BY `unit` DESC [ RunTime:0.000747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14887765 LIMIT 2 [ RunTime:0.002223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14887765 ORDER BY `minOrder` ASC [ RunTime:0.000435s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005982s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32246306 LIMIT 5 [ RunTime:0.003749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246306 ORDER BY `minOrder` ASC [ RunTime:0.008277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32246306 ORDER BY `unit` DESC [ RunTime:0.001191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32246306 LIMIT 2 [ RunTime:0.008505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246306 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
select * from pdf where partno='87502-000' and brandshort='te connectivity / measurement specialties' limit 1 [ RunTime:0.001633s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002510s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '87502-000' OR `brand` LIKE 'te connectivity / measurement specialties%' ) ) LIMIT 1 [ RunTime:0.000895s ]
SELECT `id` FROM `stock` WHERE `id` <> 32246306 AND `partno` = '87502-000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / measurement specialties%' ) [ RunTime:0.001716s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161628 LIMIT 5 [ RunTime:0.004873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161628 ORDER BY `minOrder` ASC [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161628 ORDER BY `unit` DESC [ RunTime:0.001710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161628 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161628 ORDER BY `minOrder` ASC [ RunTime:0.000343s ]
select * from pdf where partno='875015119006' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.000959s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875015119006' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.007277s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161628 AND `partno` = '875015119006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.004146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16725818 [ RunTime:0.009299s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161500 LIMIT 5 [ RunTime:0.000701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161500 ORDER BY `minOrder` ASC [ RunTime:0.001302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161500 ORDER BY `unit` DESC [ RunTime:0.003494s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161500 LIMIT 2 [ RunTime:0.004836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161500 ORDER BY `minOrder` ASC [ RunTime:0.002989s ]
select * from pdf where partno='875015119003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001178s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875015119003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003203s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161500 AND `partno` = '875015119003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.004153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888956 [ RunTime:0.009378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161637 LIMIT 5 [ RunTime:0.001673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161637 ORDER BY `minOrder` ASC [ RunTime:0.006471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161637 ORDER BY `unit` DESC [ RunTime:0.001598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161637 LIMIT 2 [ RunTime:0.000438s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161637 ORDER BY `minOrder` ASC [ RunTime:0.002072s ]
select * from pdf where partno='875015019005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.001561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875015019005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001072s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161637 AND `partno` = '875015019005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13972462 [ RunTime:0.008249s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161233 LIMIT 5 [ RunTime:0.004115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161233 ORDER BY `minOrder` ASC [ RunTime:0.002898s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161233 ORDER BY `unit` DESC [ RunTime:0.001934s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161233 LIMIT 2 [ RunTime:0.003232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161233 ORDER BY `minOrder` ASC [ RunTime:0.005209s ]
select * from pdf where partno='875075355002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.005578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075355002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.006000s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161233 AND `partno` = '875075355002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.006104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724818 [ RunTime:0.004270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161219 LIMIT 5 [ RunTime:0.002053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161219 ORDER BY `minOrder` ASC [ RunTime:0.006858s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161219 ORDER BY `unit` DESC [ RunTime:0.025196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161219 LIMIT 2 [ RunTime:0.008338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161219 ORDER BY `minOrder` ASC [ RunTime:0.011806s ]
select * from pdf where partno='875075355001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.008723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075355001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008827s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161219 AND `partno` = '875075355001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.007962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888185 [ RunTime:0.001588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51162978 LIMIT 5 [ RunTime:0.007039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162978 ORDER BY `minOrder` ASC [ RunTime:0.004478s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51162978 ORDER BY `unit` DESC [ RunTime:0.022397s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51162978 LIMIT 2 [ RunTime:0.008008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162978 ORDER BY `minOrder` ASC [ RunTime:0.000370s ]
select * from pdf where partno='875035019003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.003039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875035019003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.000977s ]
SELECT `id` FROM `stock` WHERE `id` <> 51162978 AND `partno` = '875035019003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.034741s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13971928 [ RunTime:0.011100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51162555 LIMIT 5 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162555 ORDER BY `minOrder` ASC [ RunTime:0.001295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51162555 ORDER BY `unit` DESC [ RunTime:0.010509s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51162555 LIMIT 2 [ RunTime:0.004073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162555 ORDER BY `minOrder` ASC [ RunTime:0.004899s ]
select * from pdf where partno='875015119004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.002586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875015119004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010084s ]
SELECT `id` FROM `stock` WHERE `id` <> 51162555 AND `partno` = '875015119004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.004644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572490 [ RunTime:0.002983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161692 LIMIT 5 [ RunTime:0.000774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161692 ORDER BY `minOrder` ASC [ RunTime:0.000985s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161692 ORDER BY `unit` DESC [ RunTime:0.004637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161692 LIMIT 2 [ RunTime:0.008979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161692 ORDER BY `minOrder` ASC [ RunTime:0.002155s ]
select * from pdf where partno='875046219003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004616s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875046219003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001017s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161692 AND `partno` = '875046219003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.007392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887523 [ RunTime:0.003375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161448 LIMIT 5 [ RunTime:0.001202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161448 ORDER BY `minOrder` ASC [ RunTime:0.003860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161448 ORDER BY `unit` DESC [ RunTime:0.002043s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161448 LIMIT 2 [ RunTime:0.002046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161448 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='875075361005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075361005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.004439s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161448 AND `partno` = '875075361005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.003219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16725322 [ RunTime:0.002073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161056 LIMIT 5 [ RunTime:0.000646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161056 ORDER BY `minOrder` ASC [ RunTime:0.001258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161056 ORDER BY `unit` DESC [ RunTime:0.007401s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161056 LIMIT 2 [ RunTime:0.005245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161056 ORDER BY `minOrder` ASC [ RunTime:0.003093s ]
select * from pdf where partno='875075855005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.004297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075855005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.001117s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161056 AND `partno` = '875075855005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.001523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13971131 [ RunTime:0.001179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51162709 LIMIT 5 [ RunTime:0.012184s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162709 ORDER BY `minOrder` ASC [ RunTime:0.029592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51162709 ORDER BY `unit` DESC [ RunTime:0.007222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51162709 LIMIT 2 [ RunTime:0.026004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51162709 ORDER BY `minOrder` ASC [ RunTime:0.008547s ]
select * from pdf where partno='875035119002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.035241s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875035119002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.012127s ]
SELECT `id` FROM `stock` WHERE `id` <> 51162709 AND `partno` = '875035119002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.011696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17574772 [ RunTime:0.001091s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51163005 LIMIT 5 [ RunTime:0.025093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163005 ORDER BY `minOrder` ASC [ RunTime:0.012137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51163005 ORDER BY `unit` DESC [ RunTime:0.025527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51163005 LIMIT 2 [ RunTime:0.010304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163005 ORDER BY `minOrder` ASC [ RunTime:0.000693s ]
select * from pdf where partno='875075661004' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.006608s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075661004' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.003719s ]
SELECT `id` FROM `stock` WHERE `id` <> 51163005 AND `partno` = '875075661004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.005433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724314 [ RunTime:0.001991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51163850 LIMIT 5 [ RunTime:0.009732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163850 ORDER BY `minOrder` ASC [ RunTime:0.004454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51163850 ORDER BY `unit` DESC [ RunTime:0.006323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51163850 LIMIT 2 [ RunTime:0.026524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163850 ORDER BY `minOrder` ASC [ RunTime:0.007970s ]
select * from pdf where partno='875046219002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.025412s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875046219002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.011415s ]
SELECT `id` FROM `stock` WHERE `id` <> 51163850 AND `partno` = '875046219002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.013691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887529 [ RunTime:0.015973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161878 LIMIT 5 [ RunTime:0.026462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161878 ORDER BY `minOrder` ASC [ RunTime:0.016100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161878 ORDER BY `unit` DESC [ RunTime:0.027437s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161878 LIMIT 2 [ RunTime:0.038530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161878 ORDER BY `minOrder` ASC [ RunTime:0.013442s ]
select * from pdf where partno='875075655006' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.099189s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075655006' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.046192s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161878 AND `partno` = '875075655006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.036378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572629 [ RunTime:0.036800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161895 LIMIT 5 [ RunTime:0.020462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161895 ORDER BY `minOrder` ASC [ RunTime:0.048477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161895 ORDER BY `unit` DESC [ RunTime:0.060650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161895 LIMIT 2 [ RunTime:0.035153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161895 ORDER BY `minOrder` ASC [ RunTime:0.003594s ]
select * from pdf where partno='875075661010' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009908s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075661010' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.051250s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161895 AND `partno` = '875075661010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.027063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16724333 [ RunTime:0.027096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51163857 LIMIT 5 [ RunTime:0.006149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163857 ORDER BY `minOrder` ASC [ RunTime:0.041908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51163857 ORDER BY `unit` DESC [ RunTime:0.032122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51163857 LIMIT 2 [ RunTime:0.036016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163857 ORDER BY `minOrder` ASC [ RunTime:0.007552s ]
select * from pdf where partno='875075655002' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.027234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075655002' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016020s ]
SELECT `id` FROM `stock` WHERE `id` <> 51163857 AND `partno` = '875075655002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.010028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17572564 [ RunTime:0.021999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161843 LIMIT 5 [ RunTime:0.045030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161843 ORDER BY `minOrder` ASC [ RunTime:0.039874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161843 ORDER BY `unit` DESC [ RunTime:0.014981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161843 LIMIT 2 [ RunTime:0.032631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161843 ORDER BY `minOrder` ASC [ RunTime:0.012314s ]
select * from pdf where partno='875075955001' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.035076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075955001' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.034133s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161843 AND `partno` = '875075955001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.036090s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887276 [ RunTime:0.025549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51165141 LIMIT 5 [ RunTime:0.014460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51165141 ORDER BY `minOrder` ASC [ RunTime:0.041947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51165141 ORDER BY `unit` DESC [ RunTime:0.008055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51165141 LIMIT 2 [ RunTime:0.038620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51165141 ORDER BY `minOrder` ASC [ RunTime:0.000555s ]
select * from pdf where partno='875075355003' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.032416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075355003' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.009530s ]
SELECT `id` FROM `stock` WHERE `id` <> 51165141 AND `partno` = '875075355003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.015622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14888422 [ RunTime:0.006211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51161455 LIMIT 5 [ RunTime:0.032900s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161455 ORDER BY `minOrder` ASC [ RunTime:0.043815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51161455 ORDER BY `unit` DESC [ RunTime:0.015892s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51161455 LIMIT 2 [ RunTime:0.025704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51161455 ORDER BY `minOrder` ASC [ RunTime:0.017238s ]
select * from pdf where partno='875075561005' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.018452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075561005' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.025541s ]
SELECT `id` FROM `stock` WHERE `id` <> 51161455 AND `partno` = '875075561005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.022813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13971587 [ RunTime:0.005938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51163183 LIMIT 5 [ RunTime:0.009708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163183 ORDER BY `minOrder` ASC [ RunTime:0.018019s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51163183 ORDER BY `unit` DESC [ RunTime:0.024561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51163183 LIMIT 2 [ RunTime:0.026080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51163183 ORDER BY `minOrder` ASC [ RunTime:0.007774s ]
select * from pdf where partno='875075155007' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '875075155007' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.008548s ]
SELECT `id` FROM `stock` WHERE `id` <> 51163183 AND `partno` = '875075155007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.017254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14887632 [ RunTime:0.005321s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018754s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012932s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000950s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022993s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035981s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014540s ]
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 '8750%' OR `brand` LIKE '8750%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013373s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8750%' OR `brand` LIKE '8750%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013675s ]