SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001476s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005220s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001208s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16438404 LIMIT 5 [ RunTime:0.023401s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438404 ORDER BY `minOrder` ASC [ RunTime:0.005571s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16438404 ORDER BY `unit` DESC [ RunTime:0.001386s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16438404 LIMIT 2 [ RunTime:0.019667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16438404 ORDER BY `minOrder` ASC [ RunTime:0.009199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543588 LIMIT 5 [ RunTime:0.011644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543588 ORDER BY `minOrder` ASC [ RunTime:0.025347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13543588 ORDER BY `unit` DESC [ RunTime:0.016924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13543588 LIMIT 2 [ RunTime:0.015380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13543588 ORDER BY `minOrder` ASC [ RunTime:0.014350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285506 LIMIT 5 [ RunTime:0.011870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285506 ORDER BY `minOrder` ASC [ RunTime:0.018328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13285506 ORDER BY `unit` DESC [ RunTime:0.014065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13285506 LIMIT 2 [ RunTime:0.034031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13285506 ORDER BY `minOrder` ASC [ RunTime:0.019123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563094 LIMIT 5 [ RunTime:0.027303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563094 ORDER BY `minOrder` ASC [ RunTime:0.058714s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12563094 ORDER BY `unit` DESC [ RunTime:0.038954s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12563094 LIMIT 2 [ RunTime:0.027113s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12563094 ORDER BY `minOrder` ASC [ RunTime:0.032840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183845 LIMIT 5 [ RunTime:0.075584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183845 ORDER BY `minOrder` ASC [ RunTime:0.041769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183845 ORDER BY `unit` DESC [ RunTime:0.038672s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183845 LIMIT 2 [ RunTime:0.019819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183845 ORDER BY `minOrder` ASC [ RunTime:0.025549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447984 LIMIT 5 [ RunTime:0.027641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447984 ORDER BY `minOrder` ASC [ RunTime:0.050589s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11447984 ORDER BY `unit` DESC [ RunTime:0.010882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11447984 LIMIT 2 [ RunTime:0.011591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11447984 ORDER BY `minOrder` ASC [ RunTime:0.004628s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001996s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56281054 LIMIT 5 [ RunTime:0.022240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56281054 ORDER BY `minOrder` ASC [ RunTime:0.009537s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56281054 ORDER BY `unit` DESC [ RunTime:0.010285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56281054 LIMIT 2 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56281054 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
select * from pdf where partno='2534214002' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.023355s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001452s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534214002' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.009537s ]
SELECT `id` FROM `stock` WHERE `id` <> 56281054 AND `partno` = '2534214002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.004922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16438404 [ RunTime:0.030360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53649205 LIMIT 5 [ RunTime:0.020549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649205 ORDER BY `minOrder` ASC [ RunTime:0.012500s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53649205 ORDER BY `unit` DESC [ RunTime:0.008770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53649205 LIMIT 2 [ RunTime:0.000837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649205 ORDER BY `minOrder` ASC [ RunTime:0.007873s ]
select * from pdf where partno='2534260000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534260000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031569s ]
SELECT `id` FROM `stock` WHERE `id` <> 53649205 AND `partno` = '2534260000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007318s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12563094 [ RunTime:0.006368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53649194 LIMIT 5 [ RunTime:0.003777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649194 ORDER BY `minOrder` ASC [ RunTime:0.011139s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53649194 ORDER BY `unit` DESC [ RunTime:0.024394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53649194 LIMIT 2 [ RunTime:0.032351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53649194 ORDER BY `minOrder` ASC [ RunTime:0.035442s ]
select * from pdf where partno='2534230000' and brandshort='Weidmüller' limit 1 [ RunTime:0.027268s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534230000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.021422s ]
SELECT `id` FROM `stock` WHERE `id` <> 53649194 AND `partno` = '2534230000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.025643s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58549836 LIMIT 5 [ RunTime:0.006538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549836 ORDER BY `minOrder` ASC [ RunTime:0.011209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58549836 ORDER BY `unit` DESC [ RunTime:0.040138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58549836 LIMIT 2 [ RunTime:0.026567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549836 ORDER BY `minOrder` ASC [ RunTime:0.020639s ]
select * from pdf where partno='2534210000' and brandshort='Weidmüller' limit 1 [ RunTime:0.019069s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534210000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.018404s ]
SELECT `id` FROM `stock` WHERE `id` <> 58549836 AND `partno` = '2534210000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.048407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183845 [ RunTime:0.011364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56335364 LIMIT 5 [ RunTime:0.026055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56335364 ORDER BY `minOrder` ASC [ RunTime:0.036109s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56335364 ORDER BY `unit` DESC [ RunTime:0.021277s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56335364 LIMIT 2 [ RunTime:0.027002s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56335364 ORDER BY `minOrder` ASC [ RunTime:0.055155s ]
select * from pdf where partno='25342.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.016125s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25342.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.015028s ]
SELECT `id` FROM `stock` WHERE `id` <> 56335364 AND `partno` = '25342.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.047048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13543588 [ RunTime:0.016286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53651541 LIMIT 5 [ RunTime:0.004021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53651541 ORDER BY `minOrder` ASC [ RunTime:0.016062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53651541 ORDER BY `unit` DESC [ RunTime:0.005622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53651541 LIMIT 2 [ RunTime:0.018714s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53651541 ORDER BY `minOrder` ASC [ RunTime:0.012008s ]
select * from pdf where partno='2534290000' and brandshort='Weidmüller' limit 1 [ RunTime:0.020517s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534290000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.014726s ]
SELECT `id` FROM `stock` WHERE `id` <> 53651541 AND `partno` = '2534290000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.028520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11447984 [ RunTime:0.014057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32468540 LIMIT 5 [ RunTime:0.006701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468540 ORDER BY `minOrder` ASC [ RunTime:0.022442s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32468540 ORDER BY `unit` DESC [ RunTime:0.006333s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32468540 LIMIT 2 [ RunTime:0.009221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32468540 ORDER BY `minOrder` ASC [ RunTime:0.007782s ]
select * from pdf where partno='25342' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.008060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25342' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.011370s ]
SELECT `id` FROM `stock` WHERE `id` <> 32468540 AND `partno` = '25342' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.022378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32370372 LIMIT 5 [ RunTime:0.021848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370372 ORDER BY `minOrder` ASC [ RunTime:0.023232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32370372 ORDER BY `unit` DESC [ RunTime:0.018007s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32370372 LIMIT 2 [ RunTime:0.004697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32370372 ORDER BY `minOrder` ASC [ RunTime:0.020430s ]
select * from pdf where partno='2534240000' and brandshort='Weidmüller' limit 1 [ RunTime:0.026855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2534240000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.022519s ]
SELECT `id` FROM `stock` WHERE `id` <> 32370372 AND `partno` = '2534240000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.015355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13285506 [ RunTime:0.006738s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012877s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029661s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009868s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001748s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013329s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006816s ]
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 '25342%' OR `brand` LIKE '25342%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002560s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25342%' OR `brand` LIKE '25342%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.010651s ]