SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002805s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067835s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.018296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043632 LIMIT 5 [ RunTime:0.044676s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17043632 ORDER BY `minOrder` ASC [ RunTime:0.014376s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004936s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17043632 ORDER BY `unit` DESC [ RunTime:0.020644s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17043632 LIMIT 2 [ RunTime:0.043746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17043632 ORDER BY `minOrder` ASC [ RunTime:0.026581s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.026645s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957498 LIMIT 5 [ RunTime:0.066310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957498 ORDER BY `minOrder` ASC [ RunTime:0.014024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18957498 ORDER BY `unit` DESC [ RunTime:0.051438s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18957498 LIMIT 2 [ RunTime:0.043008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957498 ORDER BY `minOrder` ASC [ RunTime:0.010358s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-PI' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.028418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957499 LIMIT 5 [ RunTime:0.016401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957499 ORDER BY `minOrder` ASC [ RunTime:0.021791s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18957499 ORDER BY `unit` DESC [ RunTime:0.008087s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18957499 LIMIT 2 [ RunTime:0.001892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18957499 ORDER BY `minOrder` ASC [ RunTime:0.008681s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-AR' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.004121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260848 LIMIT 5 [ RunTime:0.040131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260848 ORDER BY `minOrder` ASC [ RunTime:0.049188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15260848 ORDER BY `unit` DESC [ RunTime:0.063771s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15260848 LIMIT 2 [ RunTime:0.029764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15260848 ORDER BY `minOrder` ASC [ RunTime:0.024024s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB-PI' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.083487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955764 LIMIT 5 [ RunTime:0.072905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955764 ORDER BY `minOrder` ASC [ RunTime:0.037420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18955764 ORDER BY `unit` DESC [ RunTime:0.055652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18955764 LIMIT 2 [ RunTime:0.048893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955764 ORDER BY `minOrder` ASC [ RunTime:0.023391s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB-AR' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.054484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955649 LIMIT 5 [ RunTime:0.036683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955649 ORDER BY `minOrder` ASC [ RunTime:0.041351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18955649 ORDER BY `unit` DESC [ RunTime:0.062832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18955649 LIMIT 2 [ RunTime:0.044586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18955649 ORDER BY `minOrder` ASC [ RunTime:0.026349s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.040988s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049687s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309707 LIMIT 5 [ RunTime:0.034397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309707 ORDER BY `minOrder` ASC [ RunTime:0.034377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309707 ORDER BY `unit` DESC [ RunTime:0.012119s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309707 LIMIT 2 [ RunTime:0.060090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309707 ORDER BY `minOrder` ASC [ RunTime:0.008205s ]
select * from pdf where partno='gen4-ulcd-50dct-clb' and brandshort='4d systems' limit 1 [ RunTime:0.061241s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002480s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.007433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237193 LIMIT 5 [ RunTime:0.000790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237193 ORDER BY `minOrder` ASC [ RunTime:0.000780s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237193 ORDER BY `unit` DESC [ RunTime:0.037379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237193 LIMIT 2 [ RunTime:0.028389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237193 ORDER BY `minOrder` ASC [ RunTime:0.011190s ]
select * from pdf where partno='gen4-ulcd-50dct-clb' and brandshort='4d systems' limit 1 [ RunTime:0.002473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.002973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309727 LIMIT 5 [ RunTime:0.003286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309727 ORDER BY `minOrder` ASC [ RunTime:0.006388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309727 ORDER BY `unit` DESC [ RunTime:0.001271s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309727 LIMIT 2 [ RunTime:0.003070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309727 ORDER BY `minOrder` ASC [ RunTime:0.008889s ]
select * from pdf where partno='gen4-ulcd-50dct-clb-ar' and brandshort='4d systems' limit 1 [ RunTime:0.002672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb-ar' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.013591s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237352 LIMIT 5 [ RunTime:0.048486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237352 ORDER BY `minOrder` ASC [ RunTime:0.004104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237352 ORDER BY `unit` DESC [ RunTime:0.016004s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237352 LIMIT 2 [ RunTime:0.015958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237352 ORDER BY `minOrder` ASC [ RunTime:0.003733s ]
select * from pdf where partno='gen4-ulcd-50dct-clb-ar' and brandshort='4d systems' limit 1 [ RunTime:0.007564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb-ar' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.033670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32309728 LIMIT 5 [ RunTime:0.017243s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309728 ORDER BY `minOrder` ASC [ RunTime:0.042236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32309728 ORDER BY `unit` DESC [ RunTime:0.033091s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32309728 LIMIT 2 [ RunTime:0.025259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32309728 ORDER BY `minOrder` ASC [ RunTime:0.006156s ]
select * from pdf where partno='gen4-ulcd-50dct-clb-sb' and brandshort='4d systems' limit 1 [ RunTime:0.034071s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb-sb' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.030060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32237353 LIMIT 5 [ RunTime:0.011933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237353 ORDER BY `minOrder` ASC [ RunTime:0.036055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32237353 ORDER BY `unit` DESC [ RunTime:0.026648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32237353 LIMIT 2 [ RunTime:0.026784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32237353 ORDER BY `minOrder` ASC [ RunTime:0.016859s ]
select * from pdf where partno='gen4-ulcd-50dct-clb-sb' and brandshort='4d systems' limit 1 [ RunTime:0.031652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'gen4-ulcd-50dct-clb-sb' OR `brand` LIKE '4d systems%' ) ) LIMIT 1 [ RunTime:0.009642s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58132965 LIMIT 5 [ RunTime:0.007493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132965 ORDER BY `minOrder` ASC [ RunTime:0.016171s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58132965 ORDER BY `unit` DESC [ RunTime:0.066980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58132965 LIMIT 2 [ RunTime:0.028139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58132965 ORDER BY `minOrder` ASC [ RunTime:0.007900s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.006939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.039551s ]
SELECT `id` FROM `stock` WHERE `id` <> 58132965 AND `partno` = 'GEN4-ULCD-50DCT-CLB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.064310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955649 [ RunTime:0.088631s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133455 LIMIT 5 [ RunTime:0.043247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133455 ORDER BY `minOrder` ASC [ RunTime:0.018051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133455 ORDER BY `unit` DESC [ RunTime:0.042440s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133455 LIMIT 2 [ RunTime:0.056954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133455 ORDER BY `minOrder` ASC [ RunTime:0.020961s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.049831s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB-SB' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.049541s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133455 AND `partno` = 'GEN4-ULCD-50DCT-CLB-SB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.061518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17043632 [ RunTime:0.029926s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133604 LIMIT 5 [ RunTime:0.066051s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133604 ORDER BY `minOrder` ASC [ RunTime:0.045227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133604 ORDER BY `unit` DESC [ RunTime:0.032184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133604 LIMIT 2 [ RunTime:0.014704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133604 ORDER BY `minOrder` ASC [ RunTime:0.001126s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-PI' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.019887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB-PI' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.053880s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133604 AND `partno` = 'GEN4-ULCD-50DCT-CLB-PI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.042507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957498 [ RunTime:0.014844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58133670 LIMIT 5 [ RunTime:0.005608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133670 ORDER BY `minOrder` ASC [ RunTime:0.001197s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58133670 ORDER BY `unit` DESC [ RunTime:0.005689s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58133670 LIMIT 2 [ RunTime:0.005359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58133670 ORDER BY `minOrder` ASC [ RunTime:0.014085s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-AR' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.013735s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB-AR' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.004920s ]
SELECT `id` FROM `stock` WHERE `id` <> 58133670 AND `partno` = 'GEN4-ULCD-50DCT-CLB-AR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18957499 [ RunTime:0.005413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58134797 LIMIT 5 [ RunTime:0.008614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134797 ORDER BY `minOrder` ASC [ RunTime:0.015828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58134797 ORDER BY `unit` DESC [ RunTime:0.008066s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58134797 LIMIT 2 [ RunTime:0.031081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134797 ORDER BY `minOrder` ASC [ RunTime:0.002407s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB-AR' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.006468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB-SB-AR' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.016143s ]
SELECT `id` FROM `stock` WHERE `id` <> 58134797 AND `partno` = 'GEN4-ULCD-50DCT-CLB-SB-AR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.021363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18955764 [ RunTime:0.008244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58134701 LIMIT 5 [ RunTime:0.007520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134701 ORDER BY `minOrder` ASC [ RunTime:0.008492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58134701 ORDER BY `unit` DESC [ RunTime:0.005569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58134701 LIMIT 2 [ RunTime:0.010084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58134701 ORDER BY `minOrder` ASC [ RunTime:0.005849s ]
select * from pdf where partno='GEN4-ULCD-50DCT-CLB-SB-PI' and brandshort='4D Systems Pty Ltd' limit 1 [ RunTime:0.002314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GEN4-ULCD-50DCT-CLB-SB-PI' OR `brand` LIKE '4D Systems Pty Ltd%' ) ) LIMIT 1 [ RunTime:0.004176s ]
SELECT `id` FROM `stock` WHERE `id` <> 58134701 AND `partno` = 'GEN4-ULCD-50DCT-CLB-SB-PI' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%4d systems pty ltd%' ) [ RunTime:0.007113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15260848 [ RunTime:0.008812s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015829s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018120s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011537s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020883s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011781s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009269s ]
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 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030390s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'gen4-ulcd-50dct-clb%' OR `brand` LIKE 'gen4-ulcd-50dct-clb%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008547s ]