SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001633s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037347s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317584 LIMIT 5 [ RunTime:0.047955s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317584 ORDER BY `minOrder` ASC [ RunTime:0.035808s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.009150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13317584 ORDER BY `unit` DESC [ RunTime:0.007715s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13317584 LIMIT 2 [ RunTime:0.026949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317584 ORDER BY `minOrder` ASC [ RunTime:0.017064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654624 LIMIT 5 [ RunTime:0.021539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654624 ORDER BY `minOrder` ASC [ RunTime:0.014186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654624 ORDER BY `unit` DESC [ RunTime:0.017430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654624 LIMIT 2 [ RunTime:0.010632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654624 ORDER BY `minOrder` ASC [ RunTime:0.022913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654240 LIMIT 5 [ RunTime:0.036504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654240 ORDER BY `minOrder` ASC [ RunTime:0.028612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19654240 ORDER BY `unit` DESC [ RunTime:0.021694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19654240 LIMIT 2 [ RunTime:0.024211s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19654240 ORDER BY `minOrder` ASC [ RunTime:0.026815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653761 LIMIT 5 [ RunTime:0.025159s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653761 ORDER BY `minOrder` ASC [ RunTime:0.034248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19653761 ORDER BY `unit` DESC [ RunTime:0.014821s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19653761 LIMIT 2 [ RunTime:0.024942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19653761 ORDER BY `minOrder` ASC [ RunTime:0.004364s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652170 LIMIT 5 [ RunTime:0.010636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652170 ORDER BY `minOrder` ASC [ RunTime:0.041017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19652170 ORDER BY `unit` DESC [ RunTime:0.025741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19652170 LIMIT 2 [ RunTime:0.020266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19652170 ORDER BY `minOrder` ASC [ RunTime:0.020473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651518 LIMIT 5 [ RunTime:0.041672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651518 ORDER BY `minOrder` ASC [ RunTime:0.018469s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651518 ORDER BY `unit` DESC [ RunTime:0.006972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651518 LIMIT 2 [ RunTime:0.016027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651518 ORDER BY `minOrder` ASC [ RunTime:0.002808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650758 LIMIT 5 [ RunTime:0.016206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650758 ORDER BY `minOrder` ASC [ RunTime:0.009809s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650758 ORDER BY `unit` DESC [ RunTime:0.024084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650758 LIMIT 2 [ RunTime:0.013864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650758 ORDER BY `minOrder` ASC [ RunTime:0.023509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648734 LIMIT 5 [ RunTime:0.014755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648734 ORDER BY `minOrder` ASC [ RunTime:0.011998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19648734 ORDER BY `unit` DESC [ RunTime:0.000518s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19648734 LIMIT 2 [ RunTime:0.014115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19648734 ORDER BY `minOrder` ASC [ RunTime:0.034898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642079 LIMIT 5 [ RunTime:0.016466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642079 ORDER BY `minOrder` ASC [ RunTime:0.024518s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19642079 ORDER BY `unit` DESC [ RunTime:0.026310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19642079 LIMIT 2 [ RunTime:0.038233s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19642079 ORDER BY `minOrder` ASC [ RunTime:0.004078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632612 LIMIT 5 [ RunTime:0.010440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632612 ORDER BY `minOrder` ASC [ RunTime:0.035445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19632612 ORDER BY `unit` DESC [ RunTime:0.025677s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19632612 LIMIT 2 [ RunTime:0.011194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19632612 ORDER BY `minOrder` ASC [ RunTime:0.012225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605991 LIMIT 5 [ RunTime:0.012330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605991 ORDER BY `minOrder` ASC [ RunTime:0.028871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605991 ORDER BY `unit` DESC [ RunTime:0.010406s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605991 LIMIT 2 [ RunTime:0.010442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605991 ORDER BY `minOrder` ASC [ RunTime:0.002376s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020023s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56579030 LIMIT 5 [ RunTime:0.001553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56579030 ORDER BY `minOrder` ASC [ RunTime:0.006959s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56579030 ORDER BY `unit` DESC [ RunTime:0.012999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56579030 LIMIT 2 [ RunTime:0.004541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56579030 ORDER BY `minOrder` ASC [ RunTime:0.028448s ]
select * from pdf where partno='24424' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.027575s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002622s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '24424' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.008026s ]
SELECT `id` FROM `stock` WHERE `id` <> 56579030 AND `partno` = '24424' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.001379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317584 [ RunTime:0.009130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731773 LIMIT 5 [ RunTime:0.023436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731773 ORDER BY `minOrder` ASC [ RunTime:0.026009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731773 ORDER BY `unit` DESC [ RunTime:0.015513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731773 LIMIT 2 [ RunTime:0.009087s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731773 ORDER BY `minOrder` ASC [ RunTime:0.000642s ]
select * from pdf where partno='2442470000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442470000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015853s ]
SELECT `id` FROM `stock` WHERE `id` <> 53731773 AND `partno` = '2442470000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654624 [ RunTime:0.008189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53731261 LIMIT 5 [ RunTime:0.021774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731261 ORDER BY `minOrder` ASC [ RunTime:0.014170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53731261 ORDER BY `unit` DESC [ RunTime:0.006038s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53731261 LIMIT 2 [ RunTime:0.007959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53731261 ORDER BY `minOrder` ASC [ RunTime:0.006031s ]
select * from pdf where partno='2442450000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010625s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442450000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.020782s ]
SELECT `id` FROM `stock` WHERE `id` <> 53731261 AND `partno` = '2442450000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19654240 [ RunTime:0.026731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53730729 LIMIT 5 [ RunTime:0.017064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730729 ORDER BY `minOrder` ASC [ RunTime:0.010250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53730729 ORDER BY `unit` DESC [ RunTime:0.002734s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53730729 LIMIT 2 [ RunTime:0.019045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53730729 ORDER BY `minOrder` ASC [ RunTime:0.015088s ]
select * from pdf where partno='2442440000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442440000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016472s ]
SELECT `id` FROM `stock` WHERE `id` <> 53730729 AND `partno` = '2442440000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.042132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19653761 [ RunTime:0.010531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53728637 LIMIT 5 [ RunTime:0.017964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728637 ORDER BY `minOrder` ASC [ RunTime:0.012646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53728637 ORDER BY `unit` DESC [ RunTime:0.016923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53728637 LIMIT 2 [ RunTime:0.008667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53728637 ORDER BY `minOrder` ASC [ RunTime:0.027682s ]
select * from pdf where partno='2442420000' and brandshort='Weidmüller' limit 1 [ RunTime:0.030219s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442420000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017320s ]
SELECT `id` FROM `stock` WHERE `id` <> 53728637 AND `partno` = '2442420000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013332s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19652170 [ RunTime:0.024529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727707 LIMIT 5 [ RunTime:0.008828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727707 ORDER BY `minOrder` ASC [ RunTime:0.023430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727707 ORDER BY `unit` DESC [ RunTime:0.011545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727707 LIMIT 2 [ RunTime:0.011195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727707 ORDER BY `minOrder` ASC [ RunTime:0.002700s ]
select * from pdf where partno='2442460000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442460000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.017619s ]
SELECT `id` FROM `stock` WHERE `id` <> 53727707 AND `partno` = '2442460000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651518 [ RunTime:0.005250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53726643 LIMIT 5 [ RunTime:0.004416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726643 ORDER BY `minOrder` ASC [ RunTime:0.005143s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53726643 ORDER BY `unit` DESC [ RunTime:0.016517s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53726643 LIMIT 2 [ RunTime:0.003755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726643 ORDER BY `minOrder` ASC [ RunTime:0.010005s ]
select * from pdf where partno='2442410000' and brandshort='Weidmüller' limit 1 [ RunTime:0.010361s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442410000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016455s ]
SELECT `id` FROM `stock` WHERE `id` <> 53726643 AND `partno` = '2442410000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650758 [ RunTime:0.006956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53723893 LIMIT 5 [ RunTime:0.034433s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53723893 ORDER BY `minOrder` ASC [ RunTime:0.013103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53723893 ORDER BY `unit` DESC [ RunTime:0.013062s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53723893 LIMIT 2 [ RunTime:0.006760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53723893 ORDER BY `minOrder` ASC [ RunTime:0.009508s ]
select * from pdf where partno='2442400000' and brandshort='Weidmüller' limit 1 [ RunTime:0.007052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442400000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.025503s ]
SELECT `id` FROM `stock` WHERE `id` <> 53723893 AND `partno` = '2442400000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.016961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19648734 [ RunTime:0.002413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53715256 LIMIT 5 [ RunTime:0.016664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53715256 ORDER BY `minOrder` ASC [ RunTime:0.041130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53715256 ORDER BY `unit` DESC [ RunTime:0.019026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53715256 LIMIT 2 [ RunTime:0.032228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53715256 ORDER BY `minOrder` ASC [ RunTime:0.011798s ]
select * from pdf where partno='2442490000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029399s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442490000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.019705s ]
SELECT `id` FROM `stock` WHERE `id` <> 53715256 AND `partno` = '2442490000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.026961s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19642079 [ RunTime:0.032799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53701486 LIMIT 5 [ RunTime:0.026381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53701486 ORDER BY `minOrder` ASC [ RunTime:0.014477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53701486 ORDER BY `unit` DESC [ RunTime:0.014521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53701486 LIMIT 2 [ RunTime:0.005035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53701486 ORDER BY `minOrder` ASC [ RunTime:0.009008s ]
select * from pdf where partno='2442480000' and brandshort='Weidmüller' limit 1 [ RunTime:0.013855s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442480000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.016773s ]
SELECT `id` FROM `stock` WHERE `id` <> 53701486 AND `partno` = '2442480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.006520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19632612 [ RunTime:0.007002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667485 LIMIT 5 [ RunTime:0.000870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667485 ORDER BY `minOrder` ASC [ RunTime:0.012664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667485 ORDER BY `unit` DESC [ RunTime:0.034182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667485 LIMIT 2 [ RunTime:0.021179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667485 ORDER BY `minOrder` ASC [ RunTime:0.003244s ]
select * from pdf where partno='2442430000' and brandshort='Weidmüller' limit 1 [ RunTime:0.012260s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2442430000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.013097s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667485 AND `partno` = '2442430000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.012017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605991 [ RunTime:0.020737s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018168s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014305s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014468s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020539s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015708s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019768s ]
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 '24424%' OR `brand` LIKE '24424%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012457s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '24424%' OR `brand` LIKE '24424%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.034123s ]