SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003043s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006740s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040770 LIMIT 5 [ RunTime:0.022787s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040770 ORDER BY `minOrder` ASC [ RunTime:0.009734s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001851s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12040770 ORDER BY `unit` DESC [ RunTime:0.010470s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014274s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12040770 LIMIT 2 [ RunTime:0.008192s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040770 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564815 LIMIT 5 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564815 ORDER BY `minOrder` ASC [ RunTime:0.031176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564815 ORDER BY `unit` DESC [ RunTime:0.016685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564815 LIMIT 2 [ RunTime:0.027871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564815 ORDER BY `minOrder` ASC [ RunTime:0.024336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562454 LIMIT 5 [ RunTime:0.024271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562454 ORDER BY `minOrder` ASC [ RunTime:0.017094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562454 ORDER BY `unit` DESC [ RunTime:0.035081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562454 LIMIT 2 [ RunTime:0.016680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562454 ORDER BY `minOrder` ASC [ RunTime:0.008557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446628 LIMIT 5 [ RunTime:0.011408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446628 ORDER BY `minOrder` ASC [ RunTime:0.022699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446628 ORDER BY `unit` DESC [ RunTime:0.009874s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446628 LIMIT 2 [ RunTime:0.004014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446628 ORDER BY `minOrder` ASC [ RunTime:0.006197s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446512 LIMIT 5 [ RunTime:0.000980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446512 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11446512 ORDER BY `unit` DESC [ RunTime:0.002492s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11446512 LIMIT 2 [ RunTime:0.005443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11446512 ORDER BY `minOrder` ASC [ RunTime:0.003600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562520 LIMIT 5 [ RunTime:0.017693s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562520 ORDER BY `minOrder` ASC [ RunTime:0.002698s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562520 ORDER BY `unit` DESC [ RunTime:0.004686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562520 LIMIT 2 [ RunTime:0.011868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562520 ORDER BY `minOrder` ASC [ RunTime:0.009137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562600 LIMIT 5 [ RunTime:0.001806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562600 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12562600 ORDER BY `unit` DESC [ RunTime:0.000638s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12562600 LIMIT 2 [ RunTime:0.003565s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12562600 ORDER BY `minOrder` ASC [ RunTime:0.004963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561795 LIMIT 5 [ RunTime:0.001557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561795 ORDER BY `minOrder` ASC [ RunTime:0.003874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561795 ORDER BY `unit` DESC [ RunTime:0.006213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561795 LIMIT 2 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561795 ORDER BY `minOrder` ASC [ RunTime:0.009146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564132 LIMIT 5 [ RunTime:0.007977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564132 ORDER BY `minOrder` ASC [ RunTime:0.002741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12564132 ORDER BY `unit` DESC [ RunTime:0.001796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12564132 LIMIT 2 [ RunTime:0.003621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12564132 ORDER BY `minOrder` ASC [ RunTime:0.002122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644248 LIMIT 5 [ RunTime:0.001804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644248 ORDER BY `minOrder` ASC [ RunTime:0.000958s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644248 ORDER BY `unit` DESC [ RunTime:0.007474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644248 LIMIT 2 [ RunTime:0.003965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644248 ORDER BY `minOrder` ASC [ RunTime:0.000528s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008232s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002308s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63389994 LIMIT 5 [ RunTime:0.003172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389994 ORDER BY `minOrder` ASC [ RunTime:0.000982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63389994 ORDER BY `unit` DESC [ RunTime:0.008442s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63389994 LIMIT 2 [ RunTime:0.003220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63389994 ORDER BY `minOrder` ASC [ RunTime:0.008088s ]
select * from pdf where partno='24289' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.009034s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '24289' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.003745s ]
SELECT `id` FROM `stock` WHERE `id` <> 63389994 AND `partno` = '24289' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.007908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040770 [ RunTime:0.001331s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60468755 LIMIT 5 [ RunTime:0.004578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468755 ORDER BY `minOrder` ASC [ RunTime:0.000787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60468755 ORDER BY `unit` DESC [ RunTime:0.006485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60468755 LIMIT 2 [ RunTime:0.003751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468755 ORDER BY `minOrder` ASC [ RunTime:0.008711s ]
select * from pdf where partno='2428960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.011699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003799s ]
SELECT `id` FROM `stock` WHERE `id` <> 60468755 AND `partno` = '2428960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.011751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564815 [ RunTime:0.029744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60470794 LIMIT 5 [ RunTime:0.016864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470794 ORDER BY `minOrder` ASC [ RunTime:0.008166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60470794 ORDER BY `unit` DESC [ RunTime:0.022466s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60470794 LIMIT 2 [ RunTime:0.027329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470794 ORDER BY `minOrder` ASC [ RunTime:0.019755s ]
select * from pdf where partno='2428910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.019799s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.027405s ]
SELECT `id` FROM `stock` WHERE `id` <> 60470794 AND `partno` = '2428910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446628 [ RunTime:0.011422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60469251 LIMIT 5 [ RunTime:0.023651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469251 ORDER BY `minOrder` ASC [ RunTime:0.031695s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60469251 ORDER BY `unit` DESC [ RunTime:0.017786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60469251 LIMIT 2 [ RunTime:0.013341s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60469251 ORDER BY `minOrder` ASC [ RunTime:0.003283s ]
select * from pdf where partno='2428920000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428920000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018203s ]
SELECT `id` FROM `stock` WHERE `id` <> 60469251 AND `partno` = '2428920000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561795 [ RunTime:0.011274s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60470868 LIMIT 5 [ RunTime:0.001916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470868 ORDER BY `minOrder` ASC [ RunTime:0.002638s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60470868 ORDER BY `unit` DESC [ RunTime:0.002586s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60470868 LIMIT 2 [ RunTime:0.003042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60470868 ORDER BY `minOrder` ASC [ RunTime:0.002155s ]
select * from pdf where partno='2428990000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013926s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428990000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000553s ]
SELECT `id` FROM `stock` WHERE `id` <> 60470868 AND `partno` = '2428990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001246s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562600 [ RunTime:0.000415s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60471154 LIMIT 5 [ RunTime:0.005095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471154 ORDER BY `minOrder` ASC [ RunTime:0.015274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60471154 ORDER BY `unit` DESC [ RunTime:0.004237s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60471154 LIMIT 2 [ RunTime:0.004792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60471154 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
select * from pdf where partno='2428940000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001098s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428940000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007474s ]
SELECT `id` FROM `stock` WHERE `id` <> 60471154 AND `partno` = '2428940000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.008046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562454 [ RunTime:0.005131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60468851 LIMIT 5 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468851 ORDER BY `minOrder` ASC [ RunTime:0.001652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60468851 ORDER BY `unit` DESC [ RunTime:0.009592s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60468851 LIMIT 2 [ RunTime:0.012098s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60468851 ORDER BY `minOrder` ASC [ RunTime:0.000672s ]
select * from pdf where partno='2428930000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428930000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013132s ]
SELECT `id` FROM `stock` WHERE `id` <> 60468851 AND `partno` = '2428930000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446512 [ RunTime:0.003899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60539875 LIMIT 5 [ RunTime:0.001734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539875 ORDER BY `minOrder` ASC [ RunTime:0.001196s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60539875 ORDER BY `unit` DESC [ RunTime:0.007597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60539875 LIMIT 2 [ RunTime:0.003412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60539875 ORDER BY `minOrder` ASC [ RunTime:0.007407s ]
select * from pdf where partno='2428900000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428900000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015798s ]
SELECT `id` FROM `stock` WHERE `id` <> 60539875 AND `partno` = '2428900000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644248 [ RunTime:0.003972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60474872 LIMIT 5 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60474872 ORDER BY `minOrder` ASC [ RunTime:0.016496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60474872 ORDER BY `unit` DESC [ RunTime:0.003857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60474872 LIMIT 2 [ RunTime:0.000941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60474872 ORDER BY `minOrder` ASC [ RunTime:0.000817s ]
select * from pdf where partno='2428980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013099s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022389s ]
SELECT `id` FROM `stock` WHERE `id` <> 60474872 AND `partno` = '2428980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018458s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12564132 [ RunTime:0.016414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60472093 LIMIT 5 [ RunTime:0.012416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60472093 ORDER BY `minOrder` ASC [ RunTime:0.028136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60472093 ORDER BY `unit` DESC [ RunTime:0.034306s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60472093 LIMIT 2 [ RunTime:0.025640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60472093 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
select * from pdf where partno='2428950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.021586s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2428950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010144s ]
SELECT `id` FROM `stock` WHERE `id` <> 60472093 AND `partno` = '2428950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016902s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12562520 [ RunTime:0.000996s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011424s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006396s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001514s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004410s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007325s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003552s ]
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 '24289%' OR `brand` LIKE '24289%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005328s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '24289%' OR `brand` LIKE '24289%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001704s ]