SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002945s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.111451s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991832 LIMIT 5 [ RunTime:0.051519s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006589s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991832 ORDER BY `minOrder` ASC [ RunTime:0.015801s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.030193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11991832 ORDER BY `unit` DESC [ RunTime:0.099777s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.072548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11991832 LIMIT 2 [ RunTime:0.044315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11991832 ORDER BY `minOrder` ASC [ RunTime:0.068690s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.162637s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.098925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63263740 LIMIT 5 [ RunTime:0.065606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263740 ORDER BY `minOrder` ASC [ RunTime:0.213195s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63263740 ORDER BY `unit` DESC [ RunTime:0.082718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63263740 LIMIT 2 [ RunTime:0.038526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263740 ORDER BY `minOrder` ASC [ RunTime:0.096036s ]
select * from pdf where partno='ICSS-14U-24-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.078515s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002638s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-24-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.049959s ]
SELECT `id` FROM `stock` WHERE `id` <> 63263740 AND `partno` = 'ICSS-14U-24-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.043557s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11991832 [ RunTime:0.099234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63263559 LIMIT 5 [ RunTime:0.161985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263559 ORDER BY `minOrder` ASC [ RunTime:0.046470s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63263559 ORDER BY `unit` DESC [ RunTime:0.027572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63263559 LIMIT 2 [ RunTime:0.089660s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263559 ORDER BY `minOrder` ASC [ RunTime:0.008322s ]
select * from pdf where partno='ICSS-14U-21-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.047689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-21-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.024563s ]
SELECT `id` FROM `stock` WHERE `id` <> 63263559 AND `partno` = 'ICSS-14U-21-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.036433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63256347 LIMIT 5 [ RunTime:0.036634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63256347 ORDER BY `minOrder` ASC [ RunTime:0.080651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63256347 ORDER BY `unit` DESC [ RunTime:0.016966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63256347 LIMIT 2 [ RunTime:0.056461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63256347 ORDER BY `minOrder` ASC [ RunTime:0.009683s ]
select * from pdf where partno='ICSS-14U-24-NHX' and brandshort='Omega' limit 1 [ RunTime:0.027435s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-24-NHX' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.025055s ]
SELECT `id` FROM `stock` WHERE `id` <> 63256347 AND `partno` = 'ICSS-14U-24-NHX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.058327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63252982 LIMIT 5 [ RunTime:0.018187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63252982 ORDER BY `minOrder` ASC [ RunTime:0.045855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63252982 ORDER BY `unit` DESC [ RunTime:0.003671s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63252982 LIMIT 2 [ RunTime:0.007515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63252982 ORDER BY `minOrder` ASC [ RunTime:0.043552s ]
select * from pdf where partno='ICSS-14U-2-NHX' and brandshort='Omega' limit 1 [ RunTime:0.046017s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-2-NHX' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.037207s ]
SELECT `id` FROM `stock` WHERE `id` <> 63252982 AND `partno` = 'ICSS-14U-2-NHX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.046991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63251074 LIMIT 5 [ RunTime:0.059597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63251074 ORDER BY `minOrder` ASC [ RunTime:0.098703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63251074 ORDER BY `unit` DESC [ RunTime:0.059031s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63251074 LIMIT 2 [ RunTime:0.038694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63251074 ORDER BY `minOrder` ASC [ RunTime:0.027458s ]
select * from pdf where partno='ICSS-14U-24' and brandshort='Omega' limit 1 [ RunTime:0.023542s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-24' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.073364s ]
SELECT `id` FROM `stock` WHERE `id` <> 63251074 AND `partno` = 'ICSS-14U-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.071414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63245660 LIMIT 5 [ RunTime:0.096250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63245660 ORDER BY `minOrder` ASC [ RunTime:0.071862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63245660 ORDER BY `unit` DESC [ RunTime:0.084511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63245660 LIMIT 2 [ RunTime:0.045273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63245660 ORDER BY `minOrder` ASC [ RunTime:0.127385s ]
select * from pdf where partno='ICSS-14U-24RP' and brandshort='Omega' limit 1 [ RunTime:0.057966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-24RP' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.126101s ]
SELECT `id` FROM `stock` WHERE `id` <> 63245660 AND `partno` = 'ICSS-14U-24RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.113305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63245659 LIMIT 5 [ RunTime:0.080008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63245659 ORDER BY `minOrder` ASC [ RunTime:0.135977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63245659 ORDER BY `unit` DESC [ RunTime:0.088994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63245659 LIMIT 2 [ RunTime:0.185309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63245659 ORDER BY `minOrder` ASC [ RunTime:0.043396s ]
select * from pdf where partno='ICSS-14U-2' and brandshort='Omega' limit 1 [ RunTime:0.081937s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-14U-2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.079775s ]
SELECT `id` FROM `stock` WHERE `id` <> 63245659 AND `partno` = 'ICSS-14U-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.166823s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.083628s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.071929s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.057531s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063028s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.120604s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.166582s ]
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 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064030s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ICSS-14U-2%' OR `brand` LIKE 'ICSS-14U-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.107095s ]