SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001526s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046905s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11527067 LIMIT 5 [ RunTime:0.012757s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11527067 ORDER BY `minOrder` ASC [ RunTime:0.039484s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11527067 ORDER BY `unit` DESC [ RunTime:0.102483s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.053378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11527067 LIMIT 2 [ RunTime:0.021209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11527067 ORDER BY `minOrder` ASC [ RunTime:0.018931s ]
select * from pdf where partno='15210122401000' and brandshort='HARTING' limit 1 [ RunTime:0.084232s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678755 LIMIT 5 [ RunTime:0.058811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678755 ORDER BY `minOrder` ASC [ RunTime:0.280632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11678755 ORDER BY `unit` DESC [ RunTime:0.196891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11678755 LIMIT 2 [ RunTime:0.100340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11678755 ORDER BY `minOrder` ASC [ RunTime:0.125533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12675468 LIMIT 5 [ RunTime:0.090852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12675468 ORDER BY `minOrder` ASC [ RunTime:0.082983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12675468 ORDER BY `unit` DESC [ RunTime:0.092454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12675468 LIMIT 2 [ RunTime:0.165072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12675468 ORDER BY `minOrder` ASC [ RunTime:0.077491s ]
select * from pdf where partno='15210182601000' and brandshort='HARTING' limit 1 [ RunTime:0.118574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664432 LIMIT 5 [ RunTime:0.146074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664432 ORDER BY `minOrder` ASC [ RunTime:0.080330s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12664432 ORDER BY `unit` DESC [ RunTime:0.367596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12664432 LIMIT 2 [ RunTime:0.180760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664432 ORDER BY `minOrder` ASC [ RunTime:0.075919s ]
select * from pdf where partno='15210162601000' and brandshort='HARTING' limit 1 [ RunTime:0.088831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520977 LIMIT 5 [ RunTime:0.220109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520977 ORDER BY `minOrder` ASC [ RunTime:0.163459s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11520977 ORDER BY `unit` DESC [ RunTime:0.057340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11520977 LIMIT 2 [ RunTime:0.091441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520977 ORDER BY `minOrder` ASC [ RunTime:0.022976s ]
select * from pdf where partno='15210142601000' and brandshort='HARTING' limit 1 [ RunTime:0.051150s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484641 LIMIT 5 [ RunTime:0.051340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484641 ORDER BY `minOrder` ASC [ RunTime:0.098075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484641 ORDER BY `unit` DESC [ RunTime:0.156944s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484641 LIMIT 2 [ RunTime:0.053200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484641 ORDER BY `minOrder` ASC [ RunTime:0.051001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699795 LIMIT 5 [ RunTime:0.073538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699795 ORDER BY `minOrder` ASC [ RunTime:0.156155s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12699795 ORDER BY `unit` DESC [ RunTime:0.160491s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12699795 LIMIT 2 [ RunTime:0.218752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12699795 ORDER BY `minOrder` ASC [ RunTime:0.047556s ]
select * from pdf where partno='15210186601000' and brandshort='HARTING' limit 1 [ RunTime:0.052603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12697524 LIMIT 5 [ RunTime:0.074119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697524 ORDER BY `minOrder` ASC [ RunTime:0.059668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12697524 ORDER BY `unit` DESC [ RunTime:0.123282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12697524 LIMIT 2 [ RunTime:0.141198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697524 ORDER BY `minOrder` ASC [ RunTime:0.063798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12686509 LIMIT 5 [ RunTime:0.126282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12686509 ORDER BY `minOrder` ASC [ RunTime:0.143933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12686509 ORDER BY `unit` DESC [ RunTime:0.149163s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12686509 LIMIT 2 [ RunTime:0.036845s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12686509 ORDER BY `minOrder` ASC [ RunTime:0.077028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671665 LIMIT 5 [ RunTime:0.063691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671665 ORDER BY `minOrder` ASC [ RunTime:0.043633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12671665 ORDER BY `unit` DESC [ RunTime:0.116830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12671665 LIMIT 2 [ RunTime:0.024169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671665 ORDER BY `minOrder` ASC [ RunTime:0.056361s ]
select * from pdf where partno='15210162401000' and brandshort='HARTING' limit 1 [ RunTime:0.100153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671438 LIMIT 5 [ RunTime:0.061029s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671438 ORDER BY `minOrder` ASC [ RunTime:0.094618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12671438 ORDER BY `unit` DESC [ RunTime:0.153900s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12671438 LIMIT 2 [ RunTime:0.076194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12671438 ORDER BY `minOrder` ASC [ RunTime:0.020897s ]
select * from pdf where partno='15210122601000' and brandshort='HARTING' limit 1 [ RunTime:0.043059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12661438 LIMIT 5 [ RunTime:0.097701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12661438 ORDER BY `minOrder` ASC [ RunTime:0.127922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12661438 ORDER BY `unit` DESC [ RunTime:0.032825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12661438 LIMIT 2 [ RunTime:0.030109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12661438 ORDER BY `minOrder` ASC [ RunTime:0.019927s ]
select * from pdf where partno='15210162601333' and brandshort='HARTING' limit 1 [ RunTime:0.091000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12661437 LIMIT 5 [ RunTime:0.096665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12661437 ORDER BY `minOrder` ASC [ RunTime:0.087380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12661437 ORDER BY `unit` DESC [ RunTime:0.041363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12661437 LIMIT 2 [ RunTime:0.100678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12661437 ORDER BY `minOrder` ASC [ RunTime:0.044827s ]
select * from pdf where partno='15210142601333' and brandshort='HARTING' limit 1 [ RunTime:0.032522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11540976 LIMIT 5 [ RunTime:0.028052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11540976 ORDER BY `minOrder` ASC [ RunTime:0.015332s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11540976 ORDER BY `unit` DESC [ RunTime:0.052330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11540976 LIMIT 2 [ RunTime:0.015140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11540976 ORDER BY `minOrder` ASC [ RunTime:0.017630s ]
select * from pdf where partno='15210126601000' and brandshort='HARTING' limit 1 [ RunTime:0.048295s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538893 LIMIT 5 [ RunTime:0.016234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538893 ORDER BY `minOrder` ASC [ RunTime:0.005629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11538893 ORDER BY `unit` DESC [ RunTime:0.015725s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11538893 LIMIT 2 [ RunTime:0.018974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11538893 ORDER BY `minOrder` ASC [ RunTime:0.017088s ]
select * from pdf where partno='15210106601000' and brandshort='HARTING' limit 1 [ RunTime:0.009073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11516469 LIMIT 5 [ RunTime:0.013300s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516469 ORDER BY `minOrder` ASC [ RunTime:0.031577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11516469 ORDER BY `unit` DESC [ RunTime:0.028750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11516469 LIMIT 2 [ RunTime:0.013908s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11516469 ORDER BY `minOrder` ASC [ RunTime:0.001022s ]
select * from pdf where partno='15210122601333' and brandshort='HARTING' limit 1 [ RunTime:0.019794s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012100s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59748926 LIMIT 5 [ RunTime:0.010089s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748926 ORDER BY `minOrder` ASC [ RunTime:0.011444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59748926 ORDER BY `unit` DESC [ RunTime:0.003071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59748926 LIMIT 2 [ RunTime:0.005912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59748926 ORDER BY `minOrder` ASC [ RunTime:0.011783s ]
select * from pdf where partno='15210122601000' and brandshort='HARTING' limit 1 [ RunTime:0.000870s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210122601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.005055s ]
SELECT `id` FROM `stock` WHERE `id` <> 59748926 AND `partno` = '15210122601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.018258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671438 [ RunTime:0.012799s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753210 LIMIT 5 [ RunTime:0.015045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753210 ORDER BY `minOrder` ASC [ RunTime:0.037670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753210 ORDER BY `unit` DESC [ RunTime:0.017011s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753210 LIMIT 2 [ RunTime:0.023527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753210 ORDER BY `minOrder` ASC [ RunTime:0.009927s ]
select * from pdf where partno='15210122401000' and brandshort='HARTING' limit 1 [ RunTime:0.002479s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210122401000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.013901s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753210 AND `partno` = '15210122401000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.022899s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11527067 [ RunTime:0.018626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61909331 LIMIT 5 [ RunTime:0.004289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909331 ORDER BY `minOrder` ASC [ RunTime:0.009093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61909331 ORDER BY `unit` DESC [ RunTime:0.000778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61909331 LIMIT 2 [ RunTime:0.008411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61909331 ORDER BY `minOrder` ASC [ RunTime:0.009862s ]
select * from pdf where partno='152101' and brandshort='Amphenol RF' limit 1 [ RunTime:0.006701s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '152101' OR `brand` LIKE 'Amphenol RF%' ) ) LIMIT 1 [ RunTime:0.011873s ]
SELECT `id` FROM `stock` WHERE `id` <> 61909331 AND `partno` = '152101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol rf%' ) [ RunTime:0.009024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11678755 [ RunTime:0.003606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59753550 LIMIT 5 [ RunTime:0.008647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753550 ORDER BY `minOrder` ASC [ RunTime:0.008498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59753550 ORDER BY `unit` DESC [ RunTime:0.009366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59753550 LIMIT 2 [ RunTime:0.009239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59753550 ORDER BY `minOrder` ASC [ RunTime:0.004100s ]
select * from pdf where partno='15210162401000' and brandshort='HARTING' limit 1 [ RunTime:0.006582s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210162401000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.006767s ]
SELECT `id` FROM `stock` WHERE `id` <> 59753550 AND `partno` = '15210162401000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.011408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12671665 [ RunTime:0.012732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59775235 LIMIT 5 [ RunTime:0.001078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775235 ORDER BY `minOrder` ASC [ RunTime:0.015571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59775235 ORDER BY `unit` DESC [ RunTime:0.001081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59775235 LIMIT 2 [ RunTime:0.002141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775235 ORDER BY `minOrder` ASC [ RunTime:0.002126s ]
select * from pdf where partno='15210142601000' and brandshort='HARTING' limit 1 [ RunTime:0.020810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210142601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009466s ]
SELECT `id` FROM `stock` WHERE `id` <> 59775235 AND `partno` = '15210142601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.029542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520977 [ RunTime:0.005611s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59775258 LIMIT 5 [ RunTime:0.000961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775258 ORDER BY `minOrder` ASC [ RunTime:0.007941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59775258 ORDER BY `unit` DESC [ RunTime:0.003089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59775258 LIMIT 2 [ RunTime:0.012412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59775258 ORDER BY `minOrder` ASC [ RunTime:0.001403s ]
select * from pdf where partno='15210182601000' and brandshort='HARTING' limit 1 [ RunTime:0.005526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210182601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.010011s ]
SELECT `id` FROM `stock` WHERE `id` <> 59775258 AND `partno` = '15210182601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.018626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12675468 [ RunTime:0.013587s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60365528 LIMIT 5 [ RunTime:0.021735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60365528 ORDER BY `minOrder` ASC [ RunTime:0.019089s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60365528 ORDER BY `unit` DESC [ RunTime:0.020711s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60365528 LIMIT 2 [ RunTime:0.024244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60365528 ORDER BY `minOrder` ASC [ RunTime:0.000941s ]
select * from pdf where partno='1521018' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.001057s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1521018' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.029105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59783918 LIMIT 5 [ RunTime:0.004445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59783918 ORDER BY `minOrder` ASC [ RunTime:0.001495s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59783918 ORDER BY `unit` DESC [ RunTime:0.008156s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59783918 LIMIT 2 [ RunTime:0.001106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59783918 ORDER BY `minOrder` ASC [ RunTime:0.008103s ]
select * from pdf where partno='15210162601000' and brandshort='HARTING' limit 1 [ RunTime:0.000660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210162601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009709s ]
SELECT `id` FROM `stock` WHERE `id` <> 59783918 AND `partno` = '15210162601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.022224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664432 [ RunTime:0.004900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59784242 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59784242 ORDER BY `minOrder` ASC [ RunTime:0.001948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59784242 ORDER BY `unit` DESC [ RunTime:0.006539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59784242 LIMIT 2 [ RunTime:0.004735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59784242 ORDER BY `minOrder` ASC [ RunTime:0.002715s ]
select * from pdf where partno='15210102601000' and brandshort='HARTING' limit 1 [ RunTime:0.004852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210102601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.009670s ]
SELECT `id` FROM `stock` WHERE `id` <> 59784242 AND `partno` = '15210102601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.000872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622841 LIMIT 5 [ RunTime:0.000484s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622841 ORDER BY `minOrder` ASC [ RunTime:0.000963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622841 ORDER BY `unit` DESC [ RunTime:0.002624s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622841 LIMIT 2 [ RunTime:0.001049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622841 ORDER BY `minOrder` ASC [ RunTime:0.000332s ]
select * from pdf where partno='1521010000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1521010000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001329s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622841 AND `partno` = '1521010000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59841103 LIMIT 5 [ RunTime:0.008868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841103 ORDER BY `minOrder` ASC [ RunTime:0.009376s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59841103 ORDER BY `unit` DESC [ RunTime:0.001906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59841103 LIMIT 2 [ RunTime:0.007708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59841103 ORDER BY `minOrder` ASC [ RunTime:0.002571s ]
select * from pdf where partno='15210186601000' and brandshort='HARTING' limit 1 [ RunTime:0.001777s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210186601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.000904s ]
SELECT `id` FROM `stock` WHERE `id` <> 59841103 AND `partno` = '15210186601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.007234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12699795 [ RunTime:0.003003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59835326 LIMIT 5 [ RunTime:0.002579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835326 ORDER BY `minOrder` ASC [ RunTime:0.020895s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59835326 ORDER BY `unit` DESC [ RunTime:0.006922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59835326 LIMIT 2 [ RunTime:0.010881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59835326 ORDER BY `minOrder` ASC [ RunTime:0.000506s ]
select * from pdf where partno='15210125601000' and brandshort='HARTING' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210125601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001634s ]
SELECT `id` FROM `stock` WHERE `id` <> 59835326 AND `partno` = '15210125601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002390s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59834458 LIMIT 5 [ RunTime:0.014162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59834458 ORDER BY `minOrder` ASC [ RunTime:0.010598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59834458 ORDER BY `unit` DESC [ RunTime:0.001976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59834458 LIMIT 2 [ RunTime:0.004567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59834458 ORDER BY `minOrder` ASC [ RunTime:0.000517s ]
select * from pdf where partno='15210126601000' and brandshort='HARTING' limit 1 [ RunTime:0.000851s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210126601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.011310s ]
SELECT `id` FROM `stock` WHERE `id` <> 59834458 AND `partno` = '15210126601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.001031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11540976 [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59833394 LIMIT 5 [ RunTime:0.005172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59833394 ORDER BY `minOrder` ASC [ RunTime:0.002497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59833394 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59833394 LIMIT 2 [ RunTime:0.000650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59833394 ORDER BY `minOrder` ASC [ RunTime:0.006608s ]
select * from pdf where partno='15210106601000' and brandshort='HARTING' limit 1 [ RunTime:0.000712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210106601000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001387s ]
SELECT `id` FROM `stock` WHERE `id` <> 59833394 AND `partno` = '15210106601000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538893 [ RunTime:0.000736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59820509 LIMIT 5 [ RunTime:0.000684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820509 ORDER BY `minOrder` ASC [ RunTime:0.005289s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59820509 ORDER BY `unit` DESC [ RunTime:0.001563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59820509 LIMIT 2 [ RunTime:0.007041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59820509 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
select * from pdf where partno='15210142401000' and brandshort='HARTING' limit 1 [ RunTime:0.001262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210142401000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.004646s ]
SELECT `id` FROM `stock` WHERE `id` <> 59820509 AND `partno` = '15210142401000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12697524 [ RunTime:0.007556s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59813925 LIMIT 5 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813925 ORDER BY `minOrder` ASC [ RunTime:0.001653s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59813925 ORDER BY `unit` DESC [ RunTime:0.000767s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59813925 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59813925 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
select * from pdf where partno='15210122620000' and brandshort='HARTING' limit 1 [ RunTime:0.002100s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '15210122620000' OR `brand` LIKE 'HARTING%' ) ) LIMIT 1 [ RunTime:0.001523s ]
SELECT `id` FROM `stock` WHERE `id` <> 59813925 AND `partno` = '15210122620000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%harting%' ) [ RunTime:0.002582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12686509 [ RunTime:0.007865s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001734s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001249s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005975s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002033s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001369s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001378s ]
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 '152101%' OR `brand` LIKE '152101%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021164s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '152101%' OR `brand` LIKE '152101%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006232s ]