SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002349s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037674s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.023262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990790 LIMIT 5 [ RunTime:0.029026s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001958s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11990790 ORDER BY `minOrder` ASC [ RunTime:0.010707s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11990790 ORDER BY `unit` DESC [ RunTime:0.050902s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.007263s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11990790 LIMIT 2 [ RunTime:0.015461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11990790 ORDER BY `minOrder` ASC [ RunTime:0.033448s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053845s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.090976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63265474 LIMIT 5 [ RunTime:0.051697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63265474 ORDER BY `minOrder` ASC [ RunTime:0.040094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63265474 ORDER BY `unit` DESC [ RunTime:0.048863s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63265474 LIMIT 2 [ RunTime:0.039720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63265474 ORDER BY `minOrder` ASC [ RunTime:0.033375s ]
select * from pdf where partno='ICSS-18U-200-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.095596s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-200-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.079803s ]
SELECT `id` FROM `stock` WHERE `id` <> 63265474 AND `partno` = 'ICSS-18U-200-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.049369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63263313 LIMIT 5 [ RunTime:0.077131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263313 ORDER BY `minOrder` ASC [ RunTime:0.031202s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63263313 ORDER BY `unit` DESC [ RunTime:0.048634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63263313 LIMIT 2 [ RunTime:0.046357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63263313 ORDER BY `minOrder` ASC [ RunTime:0.016749s ]
select * from pdf where partno='ICSS-18U-240-NHX' and brandshort='Omega' limit 1 [ RunTime:0.039130s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-240-NHX' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.039475s ]
SELECT `id` FROM `stock` WHERE `id` <> 63263313 AND `partno` = 'ICSS-18U-240-NHX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.046289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63262050 LIMIT 5 [ RunTime:0.051686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63262050 ORDER BY `minOrder` ASC [ RunTime:0.036023s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63262050 ORDER BY `unit` DESC [ RunTime:0.010639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63262050 LIMIT 2 [ RunTime:0.024246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63262050 ORDER BY `minOrder` ASC [ RunTime:0.003364s ]
select * from pdf where partno='ICSS-18U-24-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.012901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-24-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.032382s ]
SELECT `id` FROM `stock` WHERE `id` <> 63262050 AND `partno` = 'ICSS-18U-24-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.025735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63261795 LIMIT 5 [ RunTime:0.029144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63261795 ORDER BY `minOrder` ASC [ RunTime:0.025628s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63261795 ORDER BY `unit` DESC [ RunTime:0.008239s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63261795 LIMIT 2 [ RunTime:0.034812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63261795 ORDER BY `minOrder` ASC [ RunTime:0.003386s ]
select * from pdf where partno='ICSS-18U-23-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.041509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-23-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.025742s ]
SELECT `id` FROM `stock` WHERE `id` <> 63261795 AND `partno` = 'ICSS-18U-23-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.023473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63261343 LIMIT 5 [ RunTime:0.020123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63261343 ORDER BY `minOrder` ASC [ RunTime:0.032395s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63261343 ORDER BY `unit` DESC [ RunTime:0.017257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63261343 LIMIT 2 [ RunTime:0.026202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63261343 ORDER BY `minOrder` ASC [ RunTime:0.025310s ]
select * from pdf where partno='ICSS-18U-2-DUAL' and brandshort='Omega' limit 1 [ RunTime:0.025980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-2-DUAL' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.009711s ]
SELECT `id` FROM `stock` WHERE `id` <> 63261343 AND `partno` = 'ICSS-18U-2-DUAL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.025373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63251111 LIMIT 5 [ RunTime:0.019061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63251111 ORDER BY `minOrder` ASC [ RunTime:0.046820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63251111 ORDER BY `unit` DESC [ RunTime:0.008572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63251111 LIMIT 2 [ RunTime:0.025149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63251111 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
select * from pdf where partno='ICSS-18U-24-NHX' and brandshort='Omega' limit 1 [ RunTime:0.008118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-24-NHX' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.040748s ]
SELECT `id` FROM `stock` WHERE `id` <> 63251111 AND `partno` = 'ICSS-18U-24-NHX' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.009948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63243357 LIMIT 5 [ RunTime:0.007429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63243357 ORDER BY `minOrder` ASC [ RunTime:0.010949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63243357 ORDER BY `unit` DESC [ RunTime:0.006866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63243357 LIMIT 2 [ RunTime:0.022788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63243357 ORDER BY `minOrder` ASC [ RunTime:0.012221s ]
select * from pdf where partno='ICSS-18U-24' and brandshort='Omega' limit 1 [ RunTime:0.025081s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-24' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.020229s ]
SELECT `id` FROM `stock` WHERE `id` <> 63243357 AND `partno` = 'ICSS-18U-24' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.013264s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11990790 [ RunTime:0.012236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63241998 LIMIT 5 [ RunTime:0.018164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63241998 ORDER BY `minOrder` ASC [ RunTime:0.014939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63241998 ORDER BY `unit` DESC [ RunTime:0.000985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63241998 LIMIT 2 [ RunTime:0.017232s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63241998 ORDER BY `minOrder` ASC [ RunTime:0.001548s ]
select * from pdf where partno='ICSS-18U-2' and brandshort='Omega' limit 1 [ RunTime:0.031774s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ICSS-18U-2' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.012215s ]
SELECT `id` FROM `stock` WHERE `id` <> 63241998 AND `partno` = 'ICSS-18U-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.003165s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026269s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014465s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012642s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007490s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029291s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021494s ]
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-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014017s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'ICSS-18U-2%' OR `brand` LIKE 'ICSS-18U-2%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.014736s ]