SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002579s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015559s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10752064 LIMIT 5 [ RunTime:0.028484s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752064 ORDER BY `minOrder` ASC [ RunTime:0.016339s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003059s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10752064 ORDER BY `unit` DESC [ RunTime:0.010999s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001025s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10752064 LIMIT 2 [ RunTime:0.022570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10752064 ORDER BY `minOrder` ASC [ RunTime:0.007666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11124798 LIMIT 5 [ RunTime:0.015896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11124798 ORDER BY `minOrder` ASC [ RunTime:0.007534s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11124798 ORDER BY `unit` DESC [ RunTime:0.038979s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11124798 LIMIT 2 [ RunTime:0.026167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11124798 ORDER BY `minOrder` ASC [ RunTime:0.055211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10885884 LIMIT 5 [ RunTime:0.053776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10885884 ORDER BY `minOrder` ASC [ RunTime:0.047455s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10885884 ORDER BY `unit` DESC [ RunTime:0.019478s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10885884 LIMIT 2 [ RunTime:0.021478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10885884 ORDER BY `minOrder` ASC [ RunTime:0.011054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11748307 LIMIT 5 [ RunTime:0.060611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11748307 ORDER BY `minOrder` ASC [ RunTime:0.053458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11748307 ORDER BY `unit` DESC [ RunTime:0.036133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11748307 LIMIT 2 [ RunTime:0.044681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11748307 ORDER BY `minOrder` ASC [ RunTime:0.018129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20101323 LIMIT 5 [ RunTime:0.048806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20101323 ORDER BY `minOrder` ASC [ RunTime:0.006459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20101323 ORDER BY `unit` DESC [ RunTime:0.014656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20101323 LIMIT 2 [ RunTime:0.007743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20101323 ORDER BY `minOrder` ASC [ RunTime:0.014117s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046656s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030942s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61099691 LIMIT 5 [ RunTime:0.019414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61099691 ORDER BY `minOrder` ASC [ RunTime:0.015576s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61099691 ORDER BY `unit` DESC [ RunTime:0.028968s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61099691 LIMIT 2 [ RunTime:0.013804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61099691 ORDER BY `minOrder` ASC [ RunTime:0.029073s ]
select * from pdf where partno='D38999/20WE99PN' and brandshort='Corsair' limit 1 [ RunTime:0.007485s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN' OR `brand` LIKE 'Corsair%' ) ) LIMIT 1 [ RunTime:0.010630s ]
SELECT `id` FROM `stock` WHERE `id` <> 61099691 AND `partno` = 'D38999/20WE99PN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%corsair%' ) [ RunTime:0.012545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53120367 LIMIT 5 [ RunTime:0.027161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120367 ORDER BY `minOrder` ASC [ RunTime:0.025887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53120367 ORDER BY `unit` DESC [ RunTime:0.014102s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53120367 LIMIT 2 [ RunTime:0.001653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53120367 ORDER BY `minOrder` ASC [ RunTime:0.012347s ]
select * from pdf where partno='D38999/20WE99PNL' and brandshort='Corsair' limit 1 [ RunTime:0.011971s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PNL' OR `brand` LIKE 'Corsair%' ) ) LIMIT 1 [ RunTime:0.008403s ]
SELECT `id` FROM `stock` WHERE `id` <> 53120367 AND `partno` = 'D38999/20WE99PNL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%corsair%' ) [ RunTime:0.017541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11748307 [ RunTime:0.010537s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61044189 LIMIT 5 [ RunTime:0.008026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61044189 ORDER BY `minOrder` ASC [ RunTime:0.003468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61044189 ORDER BY `unit` DESC [ RunTime:0.001092s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61044189 LIMIT 2 [ RunTime:0.017139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61044189 ORDER BY `minOrder` ASC [ RunTime:0.006864s ]
select * from pdf where partno='D38999/20WE99PN' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.007566s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.021579s ]
SELECT `id` FROM `stock` WHERE `id` <> 61044189 AND `partno` = 'D38999/20WE99PN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.014925s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10752064 [ RunTime:0.012573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61145605 LIMIT 5 [ RunTime:0.000911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61145605 ORDER BY `minOrder` ASC [ RunTime:0.005066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61145605 ORDER BY `unit` DESC [ RunTime:0.005961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61145605 LIMIT 2 [ RunTime:0.000871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61145605 ORDER BY `minOrder` ASC [ RunTime:0.010076s ]
select * from pdf where partno='D38999/20WE99PN' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.010376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.010686s ]
SELECT `id` FROM `stock` WHERE `id` <> 61145605 AND `partno` = 'D38999/20WE99PN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.004577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10885884 [ RunTime:0.013110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61155945 LIMIT 5 [ RunTime:0.009603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61155945 ORDER BY `minOrder` ASC [ RunTime:0.024573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61155945 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61155945 LIMIT 2 [ RunTime:0.017154s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61155945 ORDER BY `minOrder` ASC [ RunTime:0.007075s ]
select * from pdf where partno='D38999/20WE99PN' and brandshort='Souriau-Sunbank by Eaton' limit 1 [ RunTime:0.009394s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN' OR `brand` LIKE 'Souriau-Sunbank by Eaton%' ) ) LIMIT 1 [ RunTime:0.003459s ]
SELECT `id` FROM `stock` WHERE `id` <> 61155945 AND `partno` = 'D38999/20WE99PN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%souriau-sunbank by eaton%' ) [ RunTime:0.013914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11124798 [ RunTime:0.002989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53141916 LIMIT 5 [ RunTime:0.001472s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53141916 ORDER BY `minOrder` ASC [ RunTime:0.013275s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53141916 ORDER BY `unit` DESC [ RunTime:0.005974s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53141916 LIMIT 2 [ RunTime:0.003811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53141916 ORDER BY `minOrder` ASC [ RunTime:0.006578s ]
select * from pdf where partno='D38999/20WE99PNL' and brandshort='Souriau-Sunbank by Eaton' limit 1 [ RunTime:0.028748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PNL' OR `brand` LIKE 'Souriau-Sunbank by Eaton%' ) ) LIMIT 1 [ RunTime:0.001315s ]
SELECT `id` FROM `stock` WHERE `id` <> 53141916 AND `partno` = 'D38999/20WE99PNL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%souriau-sunbank by eaton%' ) [ RunTime:0.009185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61540664 LIMIT 5 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61540664 ORDER BY `minOrder` ASC [ RunTime:0.002277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61540664 ORDER BY `unit` DESC [ RunTime:0.000927s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61540664 LIMIT 2 [ RunTime:0.006449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61540664 ORDER BY `minOrder` ASC [ RunTime:0.020794s ]
select * from pdf where partno='D38999/20WE99PN' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.010835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007395s ]
SELECT `id` FROM `stock` WHERE `id` <> 61540664 AND `partno` = 'D38999/20WE99PN' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60042126 LIMIT 5 [ RunTime:0.021201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60042126 ORDER BY `minOrder` ASC [ RunTime:0.007319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60042126 ORDER BY `unit` DESC [ RunTime:0.006658s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60042126 LIMIT 2 [ RunTime:0.029667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60042126 ORDER BY `minOrder` ASC [ RunTime:0.018279s ]
select * from pdf where partno='D38999/20WE99PN(LC)' and brandshort='Amphenol Aerospace Operations' limit 1 [ RunTime:0.016482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'D38999/20WE99PN(LC)' OR `brand` LIKE 'Amphenol Aerospace Operations%' ) ) LIMIT 1 [ RunTime:0.017269s ]
SELECT `id` FROM `stock` WHERE `id` <> 60042126 AND `partno` = 'D38999/20WE99PN(LC)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol aerospace operations%' ) [ RunTime:0.018734s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20101323 [ RunTime:0.003664s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011186s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015404s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005837s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001947s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002356s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001003s ]
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 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018664s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'D38999/20WE99PN%' OR `brand` LIKE 'D38999/20WE99PN%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.015672s ]