SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003212s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011615s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11339751 LIMIT 5 [ RunTime:0.017782s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.021540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11339751 ORDER BY `minOrder` ASC [ RunTime:0.006183s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11339751 ORDER BY `unit` DESC [ RunTime:0.017413s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011980s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11339751 LIMIT 2 [ RunTime:0.021537s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11339751 ORDER BY `minOrder` ASC [ RunTime:0.037976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336356 LIMIT 5 [ RunTime:0.028178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336356 ORDER BY `minOrder` ASC [ RunTime:0.041669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11336356 ORDER BY `unit` DESC [ RunTime:0.041435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11336356 LIMIT 2 [ RunTime:0.016058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11336356 ORDER BY `minOrder` ASC [ RunTime:0.082760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511078 LIMIT 5 [ RunTime:0.049500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511078 ORDER BY `minOrder` ASC [ RunTime:0.037043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19511078 ORDER BY `unit` DESC [ RunTime:0.078441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19511078 LIMIT 2 [ RunTime:0.018651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19511078 ORDER BY `minOrder` ASC [ RunTime:0.010907s ]
select * from pdf where partno='MAXREFDES16#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.004064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510957 LIMIT 5 [ RunTime:0.047322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510957 ORDER BY `minOrder` ASC [ RunTime:0.047399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19510957 ORDER BY `unit` DESC [ RunTime:0.034785s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19510957 LIMIT 2 [ RunTime:0.019921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19510957 ORDER BY `minOrder` ASC [ RunTime:0.025055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11340177 LIMIT 5 [ RunTime:0.009771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11340177 ORDER BY `minOrder` ASC [ RunTime:0.061964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11340177 ORDER BY `unit` DESC [ RunTime:0.023019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11340177 LIMIT 2 [ RunTime:0.020698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11340177 ORDER BY `minOrder` ASC [ RunTime:0.006520s ]
select * from pdf where partno='MAXREFDES164#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.057290s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021239s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64023759 LIMIT 5 [ RunTime:0.009011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64023759 ORDER BY `minOrder` ASC [ RunTime:0.018121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64023759 ORDER BY `unit` DESC [ RunTime:0.031297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64023759 LIMIT 2 [ RunTime:0.006685s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64023759 ORDER BY `minOrder` ASC [ RunTime:0.020781s ]
select * from pdf where partno='MAXREFDES165#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.016062s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAXREFDES165#' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.044878s ]
SELECT `id` FROM `stock` WHERE `id` <> 64023759 AND `partno` = 'MAXREFDES165#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.028633s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11339751 [ RunTime:0.018259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64051473 LIMIT 5 [ RunTime:0.017548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64051473 ORDER BY `minOrder` ASC [ RunTime:0.015796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64051473 ORDER BY `unit` DESC [ RunTime:0.028511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64051473 LIMIT 2 [ RunTime:0.031909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64051473 ORDER BY `minOrder` ASC [ RunTime:0.053612s ]
select * from pdf where partno='MAXREFDES161#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.034871s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAXREFDES161#' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.062681s ]
SELECT `id` FROM `stock` WHERE `id` <> 64051473 AND `partno` = 'MAXREFDES161#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.023689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11336356 [ RunTime:0.011799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64047641 LIMIT 5 [ RunTime:0.024378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64047641 ORDER BY `minOrder` ASC [ RunTime:0.013177s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64047641 ORDER BY `unit` DESC [ RunTime:0.014846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64047641 LIMIT 2 [ RunTime:0.058076s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64047641 ORDER BY `minOrder` ASC [ RunTime:0.034461s ]
select * from pdf where partno='MAXREFDES16#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.012619s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAXREFDES16#' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.002268s ]
SELECT `id` FROM `stock` WHERE `id` <> 64047641 AND `partno` = 'MAXREFDES16#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.001040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19511078 [ RunTime:0.008430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64047563 LIMIT 5 [ RunTime:0.035556s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64047563 ORDER BY `minOrder` ASC [ RunTime:0.036266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64047563 ORDER BY `unit` DESC [ RunTime:0.011760s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64047563 LIMIT 2 [ RunTime:0.011584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64047563 ORDER BY `minOrder` ASC [ RunTime:0.067808s ]
select * from pdf where partno='MAXREFDES163#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.014660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAXREFDES163#' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.012298s ]
SELECT `id` FROM `stock` WHERE `id` <> 64047563 AND `partno` = 'MAXREFDES163#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.022553s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19510957 [ RunTime:0.008437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64024728 LIMIT 5 [ RunTime:0.013924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64024728 ORDER BY `minOrder` ASC [ RunTime:0.006825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64024728 ORDER BY `unit` DESC [ RunTime:0.003804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64024728 LIMIT 2 [ RunTime:0.017205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64024728 ORDER BY `minOrder` ASC [ RunTime:0.006863s ]
select * from pdf where partno='MAXREFDES164#' and brandshort='Analog Devices Inc./Maxim Integrated' limit 1 [ RunTime:0.014826s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAXREFDES164#' OR `brand` LIKE 'Analog Devices Inc./Maxim Integrated%' ) ) LIMIT 1 [ RunTime:0.010085s ]
SELECT `id` FROM `stock` WHERE `id` <> 64024728 AND `partno` = 'MAXREFDES164#' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%analog devices inc./maxim integrated%' ) [ RunTime:0.002943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11340177 [ RunTime:0.007014s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012163s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007642s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015057s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038635s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016157s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017335s ]
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 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005906s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'MAXREFDES16%' OR `brand` LIKE 'MAXREFDES16%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.002401s ]