SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002747s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093578s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.041744s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651320 LIMIT 5 [ RunTime:0.056822s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651320 ORDER BY `minOrder` ASC [ RunTime:0.044291s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.008972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19651320 ORDER BY `unit` DESC [ RunTime:0.027027s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003018s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19651320 LIMIT 2 [ RunTime:0.026176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19651320 ORDER BY `minOrder` ASC [ RunTime:0.011783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649952 LIMIT 5 [ RunTime:0.027890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649952 ORDER BY `minOrder` ASC [ RunTime:0.067225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19649952 ORDER BY `unit` DESC [ RunTime:0.012922s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19649952 LIMIT 2 [ RunTime:0.017407s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19649952 ORDER BY `minOrder` ASC [ RunTime:0.020363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647793 LIMIT 5 [ RunTime:0.021288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647793 ORDER BY `minOrder` ASC [ RunTime:0.101951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19647793 ORDER BY `unit` DESC [ RunTime:0.003683s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19647793 LIMIT 2 [ RunTime:0.060842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19647793 ORDER BY `minOrder` ASC [ RunTime:0.006228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644979 LIMIT 5 [ RunTime:0.069290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644979 ORDER BY `minOrder` ASC [ RunTime:0.050359s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19644979 ORDER BY `unit` DESC [ RunTime:0.050803s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19644979 LIMIT 2 [ RunTime:0.088886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19644979 ORDER BY `minOrder` ASC [ RunTime:0.020541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643494 LIMIT 5 [ RunTime:0.033960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643494 ORDER BY `minOrder` ASC [ RunTime:0.057411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19643494 ORDER BY `unit` DESC [ RunTime:0.130554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19643494 LIMIT 2 [ RunTime:0.077460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19643494 ORDER BY `minOrder` ASC [ RunTime:0.014575s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310354 LIMIT 5 [ RunTime:0.056106s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310354 ORDER BY `minOrder` ASC [ RunTime:0.015107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310354 ORDER BY `unit` DESC [ RunTime:0.051990s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310354 LIMIT 2 [ RunTime:0.077103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310354 ORDER BY `minOrder` ASC [ RunTime:0.022319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444344 LIMIT 5 [ RunTime:0.028149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444344 ORDER BY `minOrder` ASC [ RunTime:0.021855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15444344 ORDER BY `unit` DESC [ RunTime:0.067608s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15444344 LIMIT 2 [ RunTime:0.057808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15444344 ORDER BY `minOrder` ASC [ RunTime:0.026816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423916 LIMIT 5 [ RunTime:0.027595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423916 ORDER BY `minOrder` ASC [ RunTime:0.074408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14423916 ORDER BY `unit` DESC [ RunTime:0.156688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14423916 LIMIT 2 [ RunTime:0.060070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14423916 ORDER BY `minOrder` ASC [ RunTime:0.032070s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422536 LIMIT 5 [ RunTime:0.032728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422536 ORDER BY `minOrder` ASC [ RunTime:0.040403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422536 ORDER BY `unit` DESC [ RunTime:0.019544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422536 LIMIT 2 [ RunTime:0.022388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422536 ORDER BY `minOrder` ASC [ RunTime:0.017668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421955 LIMIT 5 [ RunTime:0.073642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421955 ORDER BY `minOrder` ASC [ RunTime:0.010380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14421955 ORDER BY `unit` DESC [ RunTime:0.011042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14421955 LIMIT 2 [ RunTime:0.019083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14421955 ORDER BY `minOrder` ASC [ RunTime:0.026646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274378 LIMIT 5 [ RunTime:0.009798s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274378 ORDER BY `minOrder` ASC [ RunTime:0.009530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274378 ORDER BY `unit` DESC [ RunTime:0.022135s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274378 LIMIT 2 [ RunTime:0.012140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274378 ORDER BY `minOrder` ASC [ RunTime:0.017260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14246497 LIMIT 5 [ RunTime:0.012169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246497 ORDER BY `minOrder` ASC [ RunTime:0.044297s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14246497 ORDER BY `unit` DESC [ RunTime:0.015778s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14246497 LIMIT 2 [ RunTime:0.004751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14246497 ORDER BY `minOrder` ASC [ RunTime:0.003476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556975 LIMIT 5 [ RunTime:0.008383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556975 ORDER BY `minOrder` ASC [ RunTime:0.008377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13556975 ORDER BY `unit` DESC [ RunTime:0.037585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13556975 LIMIT 2 [ RunTime:0.020946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13556975 ORDER BY `minOrder` ASC [ RunTime:0.016369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555559 LIMIT 5 [ RunTime:0.006864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555559 ORDER BY `minOrder` ASC [ RunTime:0.014370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13555559 ORDER BY `unit` DESC [ RunTime:0.003852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13555559 LIMIT 2 [ RunTime:0.000723s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13555559 ORDER BY `minOrder` ASC [ RunTime:0.013146s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553866 LIMIT 5 [ RunTime:0.013429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553866 ORDER BY `minOrder` ASC [ RunTime:0.001986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13553866 ORDER BY `unit` DESC [ RunTime:0.009173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13553866 LIMIT 2 [ RunTime:0.011718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13553866 ORDER BY `minOrder` ASC [ RunTime:0.010620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551956 LIMIT 5 [ RunTime:0.013643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13551956 ORDER BY `minOrder` ASC [ RunTime:0.004334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13551956 ORDER BY `unit` DESC [ RunTime:0.000851s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13551956 LIMIT 2 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13551956 ORDER BY `minOrder` ASC [ RunTime:0.000467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11450157 LIMIT 5 [ RunTime:0.003777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450157 ORDER BY `minOrder` ASC [ RunTime:0.004301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11450157 ORDER BY `unit` DESC [ RunTime:0.001766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11450157 LIMIT 2 [ RunTime:0.012250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11450157 ORDER BY `minOrder` ASC [ RunTime:0.001338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11448951 LIMIT 5 [ RunTime:0.004762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11448951 ORDER BY `minOrder` ASC [ RunTime:0.000577s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11448951 ORDER BY `unit` DESC [ RunTime:0.003773s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11448951 LIMIT 2 [ RunTime:0.000508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11448951 ORDER BY `minOrder` ASC [ RunTime:0.000961s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275986 LIMIT 5 [ RunTime:0.002651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275986 ORDER BY `minOrder` ASC [ RunTime:0.009764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275986 ORDER BY `unit` DESC [ RunTime:0.003622s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275986 LIMIT 2 [ RunTime:0.002885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275986 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='1289910000' and brandshort='weidmuller' limit 1 [ RunTime:0.008219s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289910000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.002320s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275986 AND `partno` = '1289910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.001871s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643494 [ RunTime:0.003841s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032811s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53727394 LIMIT 5 [ RunTime:0.000676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727394 ORDER BY `minOrder` ASC [ RunTime:0.004230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53727394 ORDER BY `unit` DESC [ RunTime:0.001741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53727394 LIMIT 2 [ RunTime:0.001519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53727394 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
select * from pdf where partno='1289990000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289990000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.009867s ]
SELECT `id` FROM `stock` WHERE `id` <> 53727394 AND `partno` = '1289990000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19651320 [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53726522 LIMIT 5 [ RunTime:0.000501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726522 ORDER BY `minOrder` ASC [ RunTime:0.000801s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53726522 ORDER BY `unit` DESC [ RunTime:0.002513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53726522 LIMIT 2 [ RunTime:0.014099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53726522 ORDER BY `minOrder` ASC [ RunTime:0.003206s ]
select * from pdf where partno='1289980000' and brandshort='Weidmüller' limit 1 [ RunTime:0.006632s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289980000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004098s ]
SELECT `id` FROM `stock` WHERE `id` <> 53726522 AND `partno` = '1289980000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.002897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14246497 [ RunTime:0.000823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53725499 LIMIT 5 [ RunTime:0.008904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53725499 ORDER BY `minOrder` ASC [ RunTime:0.007063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53725499 ORDER BY `unit` DESC [ RunTime:0.004823s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53725499 LIMIT 2 [ RunTime:0.003474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53725499 ORDER BY `minOrder` ASC [ RunTime:0.000486s ]
select * from pdf where partno='1289970000' and brandshort='Weidmüller' limit 1 [ RunTime:0.002518s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289970000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.001612s ]
SELECT `id` FROM `stock` WHERE `id` <> 53725499 AND `partno` = '1289970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.007911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19649952 [ RunTime:0.001159s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53723960 LIMIT 5 [ RunTime:0.000883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53723960 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53723960 ORDER BY `unit` DESC [ RunTime:0.006346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53723960 LIMIT 2 [ RunTime:0.005969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53723960 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='1289960000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289960000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.011559s ]
SELECT `id` FROM `stock` WHERE `id` <> 53723960 AND `partno` = '1289960000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003144s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310354 [ RunTime:0.002677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53722620 LIMIT 5 [ RunTime:0.000704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53722620 ORDER BY `minOrder` ASC [ RunTime:0.014861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53722620 ORDER BY `unit` DESC [ RunTime:0.009116s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53722620 LIMIT 2 [ RunTime:0.037843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53722620 ORDER BY `minOrder` ASC [ RunTime:0.004505s ]
select * from pdf where partno='1289950000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289950000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.007282s ]
SELECT `id` FROM `stock` WHERE `id` <> 53722620 AND `partno` = '1289950000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.030041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19647793 [ RunTime:0.005135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53718890 LIMIT 5 [ RunTime:0.004885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53718890 ORDER BY `minOrder` ASC [ RunTime:0.004839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53718890 ORDER BY `unit` DESC [ RunTime:0.010521s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53718890 LIMIT 2 [ RunTime:0.004493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53718890 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
select * from pdf where partno='1289930000' and brandshort='Weidmüller' limit 1 [ RunTime:0.005097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289930000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002012s ]
SELECT `id` FROM `stock` WHERE `id` <> 53718890 AND `partno` = '1289930000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.001006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19644979 [ RunTime:0.016099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53717034 LIMIT 5 [ RunTime:0.000930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717034 ORDER BY `minOrder` ASC [ RunTime:0.001099s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53717034 ORDER BY `unit` DESC [ RunTime:0.001057s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53717034 LIMIT 2 [ RunTime:0.002923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53717034 ORDER BY `minOrder` ASC [ RunTime:0.003591s ]
select * from pdf where partno='1289910000' and brandshort='Weidmüller' limit 1 [ RunTime:0.015124s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289910000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.023368s ]
SELECT `id` FROM `stock` WHERE `id` <> 53717034 AND `partno` = '1289910000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.004569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19643494 [ RunTime:0.011363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667645 LIMIT 5 [ RunTime:0.022711s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667645 ORDER BY `minOrder` ASC [ RunTime:0.045987s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667645 ORDER BY `unit` DESC [ RunTime:0.010598s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667645 LIMIT 2 [ RunTime:0.030606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667645 ORDER BY `minOrder` ASC [ RunTime:0.064606s ]
select * from pdf where partno='1289940000' and brandshort='Weidmüller' limit 1 [ RunTime:0.058481s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289940000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.031990s ]
SELECT `id` FROM `stock` WHERE `id` <> 53667645 AND `partno` = '1289940000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.044426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15444344 [ RunTime:0.019603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53653832 LIMIT 5 [ RunTime:0.028173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53653832 ORDER BY `minOrder` ASC [ RunTime:0.161660s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53653832 ORDER BY `unit` DESC [ RunTime:0.041840s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53653832 LIMIT 2 [ RunTime:0.042063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53653832 ORDER BY `minOrder` ASC [ RunTime:0.042398s ]
select * from pdf where partno='1289920000' and brandshort='Weidmüller' limit 1 [ RunTime:0.029136s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1289920000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.021688s ]
SELECT `id` FROM `stock` WHERE `id` <> 53653832 AND `partno` = '1289920000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.068176s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11448951 [ RunTime:0.068013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51220306 LIMIT 5 [ RunTime:0.040330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51220306 ORDER BY `minOrder` ASC [ RunTime:0.016193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51220306 ORDER BY `unit` DESC [ RunTime:0.000551s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51220306 LIMIT 2 [ RunTime:0.043755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51220306 ORDER BY `minOrder` ASC [ RunTime:0.010116s ]
select * from pdf where partno='12899' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.016743s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12899' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.002802s ]
SELECT `id` FROM `stock` WHERE `id` <> 51220306 AND `partno` = '12899' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274378 [ RunTime:0.004954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50746884 LIMIT 5 [ RunTime:0.011234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746884 ORDER BY `minOrder` ASC [ RunTime:0.002237s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50746884 ORDER BY `unit` DESC [ RunTime:0.002411s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50746884 LIMIT 2 [ RunTime:0.002587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50746884 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
select * from pdf where partno='12899' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.001607s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12899' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.002874s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50713373 LIMIT 5 [ RunTime:0.009140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713373 ORDER BY `minOrder` ASC [ RunTime:0.005362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50713373 ORDER BY `unit` DESC [ RunTime:0.001140s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50713373 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50713373 ORDER BY `minOrder` ASC [ RunTime:0.000509s ]
select * from pdf where partno='128991' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001177s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128991' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005065s ]
SELECT `id` FROM `stock` WHERE `id` <> 50713373 AND `partno` = '128991' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.008472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556975 [ RunTime:0.003696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50710961 LIMIT 5 [ RunTime:0.005925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710961 ORDER BY `minOrder` ASC [ RunTime:0.002981s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50710961 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50710961 LIMIT 2 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50710961 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
select * from pdf where partno='128994' and brandshort='Brady Corporation' limit 1 [ RunTime:0.003699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128994' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002534s ]
SELECT `id` FROM `stock` WHERE `id` <> 50710961 AND `partno` = '128994' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.002410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13555559 [ RunTime:0.002882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50709554 LIMIT 5 [ RunTime:0.001518s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709554 ORDER BY `minOrder` ASC [ RunTime:0.001748s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50709554 ORDER BY `unit` DESC [ RunTime:0.003045s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50709554 LIMIT 2 [ RunTime:0.000752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50709554 ORDER BY `minOrder` ASC [ RunTime:0.000515s ]
select * from pdf where partno='128992' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128992' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.005233s ]
SELECT `id` FROM `stock` WHERE `id` <> 50709554 AND `partno` = '128992' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14423916 [ RunTime:0.002356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50708219 LIMIT 5 [ RunTime:0.007524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50708219 ORDER BY `minOrder` ASC [ RunTime:0.005492s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50708219 ORDER BY `unit` DESC [ RunTime:0.003372s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50708219 LIMIT 2 [ RunTime:0.006721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50708219 ORDER BY `minOrder` ASC [ RunTime:0.004422s ]
select * from pdf where partno='128993' and brandshort='Brady Corporation' limit 1 [ RunTime:0.010669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128993' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.004072s ]
SELECT `id` FROM `stock` WHERE `id` <> 50708219 AND `partno` = '128993' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13553866 [ RunTime:0.000512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50706599 LIMIT 5 [ RunTime:0.006199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706599 ORDER BY `minOrder` ASC [ RunTime:0.002284s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50706599 ORDER BY `unit` DESC [ RunTime:0.004447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50706599 LIMIT 2 [ RunTime:0.002983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50706599 ORDER BY `minOrder` ASC [ RunTime:0.000740s ]
select * from pdf where partno='128995' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001474s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128995' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.017637s ]
SELECT `id` FROM `stock` WHERE `id` <> 50706599 AND `partno` = '128995' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.006700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422536 [ RunTime:0.005599s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705342 LIMIT 5 [ RunTime:0.007847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705342 ORDER BY `minOrder` ASC [ RunTime:0.005181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705342 ORDER BY `unit` DESC [ RunTime:0.010262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705342 LIMIT 2 [ RunTime:0.002108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705342 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
select * from pdf where partno='128996' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002168s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128996' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.009830s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705342 AND `partno` = '128996' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.011368s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14421955 [ RunTime:0.003607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705338 LIMIT 5 [ RunTime:0.003090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705338 ORDER BY `minOrder` ASC [ RunTime:0.014485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705338 ORDER BY `unit` DESC [ RunTime:0.004947s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705338 LIMIT 2 [ RunTime:0.010875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705338 ORDER BY `minOrder` ASC [ RunTime:0.003341s ]
select * from pdf where partno='128990' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128990' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.026054s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705338 AND `partno` = '128990' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.014382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13551956 [ RunTime:0.003968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38152368 LIMIT 5 [ RunTime:0.008553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38152368 ORDER BY `minOrder` ASC [ RunTime:0.017063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38152368 ORDER BY `unit` DESC [ RunTime:0.007203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38152368 LIMIT 2 [ RunTime:0.002826s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38152368 ORDER BY `minOrder` ASC [ RunTime:0.009665s ]
select * from pdf where partno='12899' and brandshort='Allied Vision, Inc.' limit 1 [ RunTime:0.000550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12899' OR `brand` LIKE 'Allied Vision, Inc.%' ) ) LIMIT 1 [ RunTime:0.000425s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38102374 LIMIT 5 [ RunTime:0.003994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38102374 ORDER BY `minOrder` ASC [ RunTime:0.003273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38102374 ORDER BY `unit` DESC [ RunTime:0.003639s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38102374 LIMIT 2 [ RunTime:0.028416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38102374 ORDER BY `minOrder` ASC [ RunTime:0.002090s ]
select * from pdf where partno='128991' and brandshort='Brady Corporation' limit 1 [ RunTime:0.004957s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '128991' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.002594s ]
SELECT `id` FROM `stock` WHERE `id` <> 38102374 AND `partno` = '128991' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.004280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13556975 [ RunTime:0.004275s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007068s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010271s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016923s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012796s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008245s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003280s ]
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 '12899%' OR `brand` LIKE '12899%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004864s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12899%' OR `brand` LIKE '12899%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008465s ]