SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002095s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117016s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.087818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12441731 LIMIT 5 [ RunTime:0.114959s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.059707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441731 ORDER BY `minOrder` ASC [ RunTime:0.048246s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.090762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12441731 ORDER BY `unit` DESC [ RunTime:0.110769s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12441731 LIMIT 2 [ RunTime:0.286275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441731 ORDER BY `minOrder` ASC [ RunTime:0.069296s ]
select * from pdf where partno='UB215SKG036B-2B' and brandshort='NKK Switches' limit 1 [ RunTime:0.113221s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12441732 LIMIT 5 [ RunTime:0.089587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441732 ORDER BY `minOrder` ASC [ RunTime:0.283420s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12441732 ORDER BY `unit` DESC [ RunTime:0.051017s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12441732 LIMIT 2 [ RunTime:0.061788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12441732 ORDER BY `minOrder` ASC [ RunTime:0.093963s ]
select * from pdf where partno='UB215SKG036B-1JB' and brandshort='NKK Switches' limit 1 [ RunTime:0.236140s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11348212 LIMIT 5 [ RunTime:0.262142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11348212 ORDER BY `minOrder` ASC [ RunTime:0.197758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11348212 ORDER BY `unit` DESC [ RunTime:0.050824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11348212 LIMIT 2 [ RunTime:0.038722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11348212 ORDER BY `minOrder` ASC [ RunTime:0.088241s ]
select * from pdf where partno='UB215SKG036B-3JB' and brandshort='NKK Switches' limit 1 [ RunTime:0.127840s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064792s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.185858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43831977 LIMIT 5 [ RunTime:0.072250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831977 ORDER BY `minOrder` ASC [ RunTime:0.186609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43831977 ORDER BY `unit` DESC [ RunTime:0.028608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43831977 LIMIT 2 [ RunTime:0.034612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43831977 ORDER BY `minOrder` ASC [ RunTime:0.021095s ]
select * from pdf where partno='UB215SKG036B-2B' and brandshort='NKK Switches' limit 1 [ RunTime:0.073115s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UB215SKG036B-2B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.045572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43833251 LIMIT 5 [ RunTime:0.018239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43833251 ORDER BY `minOrder` ASC [ RunTime:0.048348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43833251 ORDER BY `unit` DESC [ RunTime:0.032863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43833251 LIMIT 2 [ RunTime:0.049626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43833251 ORDER BY `minOrder` ASC [ RunTime:0.025344s ]
select * from pdf where partno='UB215SKG036B-1JB' and brandshort='NKK Switches' limit 1 [ RunTime:0.009512s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UB215SKG036B-1JB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.030198s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43833214 LIMIT 5 [ RunTime:0.032877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43833214 ORDER BY `minOrder` ASC [ RunTime:0.135919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43833214 ORDER BY `unit` DESC [ RunTime:0.045166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43833214 LIMIT 2 [ RunTime:0.018300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43833214 ORDER BY `minOrder` ASC [ RunTime:0.006693s ]
select * from pdf where partno='UB215SKG036B' and brandshort='NKK Switches' limit 1 [ RunTime:0.014463s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UB215SKG036B' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.002272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43835168 LIMIT 5 [ RunTime:0.068223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43835168 ORDER BY `minOrder` ASC [ RunTime:0.130592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43835168 ORDER BY `unit` DESC [ RunTime:0.066108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43835168 LIMIT 2 [ RunTime:0.031125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43835168 ORDER BY `minOrder` ASC [ RunTime:0.034508s ]
select * from pdf where partno='UB215SKG036B-3JB' and brandshort='NKK Switches' limit 1 [ RunTime:0.025747s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'UB215SKG036B-3JB' OR `brand` LIKE 'NKK Switches%' ) ) LIMIT 1 [ RunTime:0.042948s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020330s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.089055s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045735s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.112519s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086986s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.118420s ]
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 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031312s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'UB215SKG036B%' OR `brand` LIKE 'UB215SKG036B%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.025534s ]