SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002567s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.081576s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17860589 LIMIT 5 [ RunTime:0.076459s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860589 ORDER BY `minOrder` ASC [ RunTime:0.067226s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.047552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17860589 ORDER BY `unit` DESC [ RunTime:0.046100s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.044248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17860589 LIMIT 2 [ RunTime:0.037645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860589 ORDER BY `minOrder` ASC [ RunTime:0.037866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17860576 LIMIT 5 [ RunTime:0.026088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860576 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17860576 ORDER BY `unit` DESC [ RunTime:0.013902s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17860576 LIMIT 2 [ RunTime:0.005789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860576 ORDER BY `minOrder` ASC [ RunTime:0.003883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17860078 LIMIT 5 [ RunTime:0.001380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860078 ORDER BY `minOrder` ASC [ RunTime:0.001395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17860078 ORDER BY `unit` DESC [ RunTime:0.010283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17860078 LIMIT 2 [ RunTime:0.006819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17860078 ORDER BY `minOrder` ASC [ RunTime:0.001349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16802301 LIMIT 5 [ RunTime:0.003137s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16802301 ORDER BY `minOrder` ASC [ RunTime:0.006755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16802301 ORDER BY `unit` DESC [ RunTime:0.013893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16802301 LIMIT 2 [ RunTime:0.037491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16802301 ORDER BY `minOrder` ASC [ RunTime:0.020478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16802300 LIMIT 5 [ RunTime:0.023464s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16802300 ORDER BY `minOrder` ASC [ RunTime:0.011389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16802300 ORDER BY `unit` DESC [ RunTime:0.026665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16802300 LIMIT 2 [ RunTime:0.002663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16802300 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14071875 LIMIT 5 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14071875 ORDER BY `minOrder` ASC [ RunTime:0.000940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14071875 ORDER BY `unit` DESC [ RunTime:0.009228s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14071875 LIMIT 2 [ RunTime:0.017004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14071875 ORDER BY `minOrder` ASC [ RunTime:0.002852s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028477s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58172331 LIMIT 5 [ RunTime:0.033576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172331 ORDER BY `minOrder` ASC [ RunTime:0.017496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58172331 ORDER BY `unit` DESC [ RunTime:0.007973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58172331 LIMIT 2 [ RunTime:0.006068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172331 ORDER BY `minOrder` ASC [ RunTime:0.010214s ]
select * from pdf where partno='SMI30C-P-EV' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.009181s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001640s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-EV' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.002693s ]
SELECT `id` FROM `stock` WHERE `id` <> 58172331 AND `partno` = 'SMI30C-P-EV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58172330 LIMIT 5 [ RunTime:0.000871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172330 ORDER BY `minOrder` ASC [ RunTime:0.010260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58172330 ORDER BY `unit` DESC [ RunTime:0.010135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58172330 LIMIT 2 [ RunTime:0.030989s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172330 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='SMI30C-P-EWV' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.010097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-EWV' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.020303s ]
SELECT `id` FROM `stock` WHERE `id` <> 58172330 AND `partno` = 'SMI30C-P-EWV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.008500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58172249 LIMIT 5 [ RunTime:0.008497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172249 ORDER BY `minOrder` ASC [ RunTime:0.015782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58172249 ORDER BY `unit` DESC [ RunTime:0.006587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58172249 LIMIT 2 [ RunTime:0.019918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172249 ORDER BY `minOrder` ASC [ RunTime:0.009571s ]
select * from pdf where partno='SMI30C-P-EU' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.014279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-EU' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.037339s ]
SELECT `id` FROM `stock` WHERE `id` <> 58172249 AND `partno` = 'SMI30C-P-EU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.037635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58172248 LIMIT 5 [ RunTime:0.026239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172248 ORDER BY `minOrder` ASC [ RunTime:0.022661s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58172248 ORDER BY `unit` DESC [ RunTime:0.020159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58172248 LIMIT 2 [ RunTime:0.013042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58172248 ORDER BY `minOrder` ASC [ RunTime:0.041107s ]
select * from pdf where partno='SMI30C-P-EWU' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.004807s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-EWU' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.003372s ]
SELECT `id` FROM `stock` WHERE `id` <> 58172248 AND `partno` = 'SMI30C-P-EWU' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.012327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58171637 LIMIT 5 [ RunTime:0.034651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58171637 ORDER BY `minOrder` ASC [ RunTime:0.048041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58171637 ORDER BY `unit` DESC [ RunTime:0.082520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58171637 LIMIT 2 [ RunTime:0.016006s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58171637 ORDER BY `minOrder` ASC [ RunTime:0.002926s ]
select * from pdf where partno='SMI30C-P-E' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.031547s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-E' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.036223s ]
SELECT `id` FROM `stock` WHERE `id` <> 58171637 AND `partno` = 'SMI30C-P-E' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.016169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58171636 LIMIT 5 [ RunTime:0.054108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58171636 ORDER BY `minOrder` ASC [ RunTime:0.017769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58171636 ORDER BY `unit` DESC [ RunTime:0.022282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58171636 LIMIT 2 [ RunTime:0.036324s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58171636 ORDER BY `minOrder` ASC [ RunTime:0.016660s ]
select * from pdf where partno='SMI30C-P-EW' and brandshort='Bel Power Solutions' limit 1 [ RunTime:0.014721s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SMI30C-P-EW' OR `brand` LIKE 'Bel Power Solutions%' ) ) LIMIT 1 [ RunTime:0.016901s ]
SELECT `id` FROM `stock` WHERE `id` <> 58171636 AND `partno` = 'SMI30C-P-EW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bel power solutions%' ) [ RunTime:0.019298s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048971s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018721s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007133s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021817s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024305s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028973s ]
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 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030877s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SMI30C-P-E%' OR `brand` LIKE 'SMI30C-P-E%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.102196s ]